我的论坛主题

• who knows the index building mechanism?

  2008-09-28 21:00:54   /   Oracle数据库管理

  Is there any body know which mechanism Oracle uses to build an index.for example:a table A (a1, a2)has 1000 rows, I want to create an index idx_a1 on column a1.Then how does oracle create the index?Hypothesis 1:Oracle extracts all the data in column a1,and put it all into the sort area(memory or temp space or both of them), after completed sorting, writes the sorted data into the permanent tablespace to build the index.Hypothesis 2:Oracle divides the data of column a1 in

  查看(140) 评论(5)

• why the dbwr process write the dirty blocks when dropping or truncating a table

  2008-07-05 22:39:29   /   Oracle数据库管理

  Is there any body can give me an answer?I am really confused about thiswelcome discusion!!!

  查看(169) 评论(2)