CoderZone.org

Category: >> Oracle PL/SQL >> INDEXES: Block Dump Bookmark and Share

<< lastnext >>

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 in...
» INDEXES: DISABLE (function-based i...
» INDEXES: Alter Index Parallel
» INDEXES: Alter Index Deallocate Un...
» INDEXES: Alter Index Allocate Exte...
» 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)

Author: CoderZone
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
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7