Oracle PL/SQL: INDEXES: Block Dump - It can be useful to see internal structure of Oracle datablocks that belong to an index.<br /> <br

Quick Search:

Oracle PL/SQL: INDEXES: Block Dump

Jump to:

Category: >> Oracle PL/SQL >> INDEXES: Block Dump

<< last

next >>

Snippet Name: INDEXES: Block Dump

Description: It can be useful to see internal structure of Oracle datablocks that belong to an index.

This example shows dumping an entire index tree, including branch block headers, leaf block headers, and the leaf block contents.

Also see:
» INDEXES: View table indexes
» INDEXES: Analyze Index
» INDEXES: Rebuild Reverse
» INDEXES:
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» INDEXES: Alter Index Parallel
» INDEXES: Alter Index Deallocate Unused
» INDEXES: Alter Index Allocate Extent
» INDEXES: Virtual / NoSegment
» INDEXES: Reverse Key Indexes
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» INDEXES: Unique indexes
» INDEXES: Parallel Index
» INDEXES: Compute Statistics
» INDEXES: SORT and NOSORT
» INDEXES: Function-Based Index
» INDEXES: DROP index
» INDEXES: Alter index
» INDEXES: Single Column Non-unique
» INDEXES: Index Usage Notes
» Compressed Indexes
» Create INDEX

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 11th, 2009

ALTER session SET events 'immediate trace name treedump level xxxx'
 
-- where xxxx is the object id of that index, that can 
-- now be fetched by this:
 
SELECT object_id, object_name
FROM all_objects
WHERE object_type='INDEX'
AND object_name LIKE 'RECEIPT%'
 
 
-- alternative method:
 
ORADEBUG DUMP TREEDUMP xxx