RE: db file scattered/sequential read wait

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 16 Jun 2004 12:59:46 -0400
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F730A3453C7@xchgbrsm1.corp.espn.pvt>

P1 is the file#, p2 is the block number and p3 is number of blocks being read in the current call.

Select owner, segment_name, segment_type   from dba_extents
 where file_id = <p1>
   and p2 between block_id and (block_id+blocks) /

Should get you closer.
Raj

---

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of solbeach_at_cox.net Sent: Wednesday, June 16, 2004 12:54 PM
To: oracle-l_at_freelists.org
Subject: db file scattered/sequential read wait

How do I determine which database object is being accessed when v$session_wait reports a "db file * read" is in progress?

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Jun 16 2004 - 11:57:16 CDT