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 -----------------------------------------------------------------