RE: wait event puzzler

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 11 Jun 2003 11:07:01 -0700
Message-ID: <F001.005AF565.20030611103458@fatcity.com>

The "db file sequential read" means that oracle is trying to read a sequence of
consecutive blocks, shorter then DB_FILE_MULTIBLOCK_READ_COUNT. That usually happens
when reading indexes, but it's not inconceivable to happen during table access as well.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]

-----Original Message-----
Sent: Wednesday, June 11, 2003 2:02 PM
To: Multiple recipients of list ORACLE-L

Good day all,
We have a bunch of queries in our data warehouse environment that are taking a long time to complete.
I did a select on v$session_wait on one of the queries when it is running and it shows the wait event to be 'db file sequential read', which means it is scanning index blocks, correct? But when I put the p1 p2 p3 values into another query to see which segment it belongs to, it shows me a table, not an index. How can this be?

TIA
Dennis

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author: Meng, Dennis
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------