Oracle-L: Re: How to find an object associated with a file # and block #

From: <Rick_Cale_at_teamhealth.com>
Date: Mon, 21 Oct 2002 06:49:21 -0800
Message-ID: <F001.004EEAB9.20021021064921@fatcity.com>

I got it!!! V$datafile and dba_extents will get what I need.

                                                                                                                   
                    Rick_Cale_at_team                                                                                 
                    health.com           To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    Sent by:             cc:                                                                       
                    root_at_fatcity.c       Subject:     How to find an object associated with a file # and block #   
                    om                                                                                             
                                                                                                                   
                                                                                                                   
                    10/21/2002                                                                                     
                    09:54 AM                                                                                       
                    Please respond                                                                                 
                    to ORACLE-L

Hi,

Can someone tell me how I can find which object resides in a given file # and block #? This is from a trace file. I do not have a rowid to use dbms_rowid.

Thanks
Rick

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).




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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Mon Oct 21 2002 - 09:49:21 CDT