best way for tree dump??

From: Raghu Kota <raghukota_at_hotmail.com>
Date: Fri, 08 Jun 2001 13:22:05 -0700
Message-ID: <F001.00322A28.20010608112126@fatcity.com>

Hi Friends

Iam doing tree dump some times it will come correct, Some times it gave ora-600 and disconnecting from server. What is best way doing tree dump. Mine is oracle7.3 on AIX.

Iam doing like this

select header_file, header_block from dba_segments where segment_type='INDEX'
and segment_name='index_name';

select DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS(<header_file>,<header_block>) from dual;

alter session set events 'immediate trace name treedump level <level_number>';

Any ideas???

TIA
Raghu.

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Raghu Kota
INET: raghukota_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 08 2001 - 15:22:05 CDT