Oracle-L: RE: Help on resolving block number and file number from 10046 tra

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Tue, 15 Oct 2002 19:28:28 -0800
Message-ID: <F001.004E9FE3.20021015192828@fatcity.com>

You can use this query:

find_segment.sql
Finds segment name based on input file_id and block_id

set Lines 132
col Owner for a10
col Segment_name for a30
col Segment_type for a20
col Tablespace_name for a30

select Owner,

       Segment_Name,
       Segment_Type,
       Tablespace_Name

from

DBA_EXTENTS
where

File_Id = &File_Id_In
and &Block_Id_in between Block_Id and Block_Id + Blocks - 1 /

Kirti

-----Original Message-----
Sent: Tuesday, October 15, 2002 10:03 PM To: Multiple recipients of list ORACLE-L to table or index

Hi all,

For some reason my 9.0.1 windows install has no tkprof binary, so I'm trying to decipher some 10046 output. I've got a bunch of

WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340 p3=1

For this event, p1 is the file, and p2 is the block. Any ideas on how to track down what object this is (i.e. table, index or whatever)?

thanks
Fuzzy
:-)

"Woo Hoo!" - H. Simpson

The contents of this post are my opinions only

If swallowed seek medical advice

(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it.
--

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

Author: Grant Allen
INET: Grant_at_towersoft.com.au

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: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------