Oracle-L: Re: Help on resolving block number and file number from 10046 trace to table or index

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Tue, 15 Oct 2002 19:58:30 -0800
Message-ID: <F001.004E9FFE.20021015195830@fatcity.com>

select * from dba_extents
where file_id = P1
and P2 between block_id and (block_id + (blocks - 1));

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 15, 2002 9:03 PM 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: Tim Gorman
  INET: Tim_at_SageLogix.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 Tue Oct 15 2002 - 22:58:30 CDT