tag:blogger.com,1999:blog-4169710303065679169.post9089583009045565800..comments2024-03-18T20:50:36.708-07:00Comments on A Wider View : BLOG HAS MOVED *<a href="http://blog.orapub.com">HERE</a>*: Are you sure it's the index root block?Craig Shallahamer, President/Founder, OraPubhttp://www.blogger.com/profile/04109635337570098781noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4169710303065679169.post-22250950419106196872018-05-09T02:30:32.433-07:002018-05-09T02:30:32.433-07:00Thanks for sharing these information. It’s a very ...Thanks for sharing these information. It’s a very nice topic. We are providing online training classes<br /><br /><a href="http://www.ciitnoida.com/best-bca-degree-course-college-in-noida.php" rel="nofollow">Best bca college in noida</a><br /><a href="http://www.ciitnoida.com/best-bca-degree-course-college-in-noida.php" rel="nofollow">Top bca colleges in noida</a><br />ciitnoidahttps://www.blogger.com/profile/13411560277382130436noreply@blogger.comtag:blogger.com,1999:blog-4169710303065679169.post-13476357646543248662011-12-23T03:26:03.588-08:002011-12-23T03:26:03.588-08:00Hi Craig
There is at least a situation when the r...Hi Craig<br /><br />There is at least a situation when the root block is not the first one after the segment header. Which one? When the freelist groups parameter is set to a value higher than 1. In such a case the freelist group blocks are inserted between the header block and the root block.<br /><br />Cheers,<br />Chris Antognini<br /><br />Troubleshooting Oracle Performance, Apress 2008<br />http://top.antognini.chChris Antogninihttps://www.blogger.com/profile/06817383099389331608noreply@blogger.comtag:blogger.com,1999:blog-4169710303065679169.post-68000122451902757312011-11-20T09:52:49.978-08:002011-11-20T09:52:49.978-08:00Bundit,
1. Regarding ASSM tablespace comment. I u...Bundit,<br /><br />1. Regarding ASSM tablespace comment. I understood your comment to mean, "For an index created/residing in an ASSM tablespace, it's index root block is NOT the block following the index's segment header block."<br /><br />Interesting observation because I did NOT perform my experiments in an ASSM tablespace. Since you did not include any experimental evidence, I repeated the experiment using an ASSM tablespace.<br /><br />Here's what I did: I created an ASSM tablespace and verified it's space mangement via dba_tablespaces. I created a new user, granted it DBA (makes things easy), and set it's default tablespace to the ASSM tablespace. I re-ran the experiment by running, just as in the posting, the script doRbExpr.sql. I verified that the test objects where created in the ASSM tablespace.<br /><br />The result was the same in every situation I tested. That is, the index root block is indeed the block following the index segment header block.<br /><br />2. Your #2 comment confused me, so I'll generally comment. I use dba_segments to get the proposed index root block's, file and block number so I can generate the DBA of this proposed index root block. I use dba_objects to get the index's object_id so I can dump the index, which shows the index root block's DBA. Now that I have have two DBAs, I can compare them and see if they match... which they always have (so far anyways).<br /><br />Thanks for taking the time to read my posting and comment. I truly appreciate that. It would be very helpful though, if you would supply a test case in your comments. It's allows me to very quickly review your comments.<br /><br />All the best,<br /><br />Craig.Craig Shallahamer, President/Founder, OraPubhttps://www.blogger.com/profile/04109635337570098781noreply@blogger.comtag:blogger.com,1999:blog-4169710303065679169.post-56099144353001302382011-11-17T05:41:56.420-08:002011-11-17T05:41:56.420-08:00Hi Craig,
1. If using assm tablespace, the first ...Hi Craig,<br /><br />1. If using assm tablespace, the first block of first extent is not the same with segment_header. <br /><br />2. Your script is fine to get block_id from dba_objects, however your post describes to get from dba_segments.<br /><br />Cheers,<br />BunditBundithttps://www.blogger.com/profile/15932387945449727016noreply@blogger.com