RE: db file scattered/sequential read wait

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 16 Jun 2004 13:02:00 -0400

I think you want a minus one in the second term.

Let's see, if block_id = 1 and you read 8 blocks, then 1...9, is *not* what
you want, so yeah, (block_id+blocks-1)
would tighten up that predicate.

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jamadagni, Rajendra
Sent: Wednesday, June 16, 2004 1:00 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: db file scattered/sequential read wait


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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of solbeach@xxxxxxx
Sent: Wednesday, June 16, 2004 12:54 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: