RE: db file scattered/sequential read wait

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 16 Jun 2004 13:02:00 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKGEELEOAA.mwf@rsiz.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jamadagni, Rajendra Sent: Wednesday, June 16, 2004 1:00 PM
To: oracle-l_at_freelists.org
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_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

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

Received on Wed Jun 16 2004 - 12:04:39 CDT