Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it possible to look at the entries of the index file?
"Ariel Burbaickij" <ariel.burbaickij_at_gmail.com> wrote in message
news:3058f9b4.0410192323.3bae290d_at_posting.google.com...
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> news:<Xns9587B342F8972SunnySD_at_68.6.19.6>...
>> ariel.burbaickij_at_gmail.com (Ariel Burbaickij) wrote in
>> news:3058f9b4.0410191221.7085de_at_posting.google.com:
>>
>> > Hello dear newsgroup particpants,
>> > I would like to take a look at what is exactly is stores in B-Tree
>> > index of Oracle. Is there a way to do it?
>> >
>>
>> There is more than one way. The *nix command "od" will show the contents
>> of
>> any file.
>>
>> What are you expecting to "see" within the index?
>
> Preferably, the structure. Contents of all leafs, how leafs are
> interrelated etc.
http://julian.dyke.users.btopenworld.com/Oracle/Diagnostics/Dumps/TREEDUMP.html
will likely give you a good start.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.comReceived on Tue Oct 26 2004 - 14:14:02 CDT