Re: Full table scan: what order?

From: Stefan <sroesch3_at_attbi.com>
Date: Sun, 13 Jan 2002 04:10:02 GMT
Message-ID: <uM708.16421$Vq.110365@rwcrnsc53>

Hi Jaap,

with 8i and 9i there is a view available for that: v$session_longops. Maybe this one is already available with version 8.

The reason you might no get a stady increasing value is the usage of asynchronous i/o.

Stefan

Jaap W. van Dijk wrote:

> I've written a script (or at least tried) that shows me how far a full
> table scan has progressed for a session. I can determine the block the
> session is currently reading by retrieving p1 (file_id) en p2
> (blocknumber) from v$session_wait in case of event 'db file scattered
> read'. But in which order does Oracle read the blocks?
> - file_id,extent_id?
> - extent_id?
> Is there a difference between Oracle 7 and Oracle 8?
> I've tried both assumptions but the result my script is giving is
> never a steady increasing value.
Received on Sat Jan 12 2002 - 22:10:02 CST