Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent: db file sequential read - wait

Re: Urgent: db file sequential read - wait

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 31 Mar 2004 21:26:55 +0100
Message-ID: <01c001c4175e$87d16bf0$7102a8c0@Primary>

If the status is "waited known time" then you are no longer waiting, and have been burning CPU since the completion of the last wait.

The "seconds_in_wait" will then be a fair indicator of how long you've been burning CPU, given that it would have reset to zero as the last wait started and been counting roughly every 3 seconds since.

The last wait was a "db file sequential read", so the actual time_waited will be in the order of 1/100 of a second and ignorable compared to seconds_in_wait (probably).

The title "seconds_in_wait" is very misleading, it should
be "seconds_since_the_start_of_the_last_wait_but_only_
accurate_to_about_the_nearest_three_seconds".  But the
limit on a column name is only 32 characters.

Your correlated delete needs fixing to stop it burning CPU.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar

I actually got waited known time as a status. And the seconds where still counted up. So I guess the session was still waiting on this event.

Stefan

-----Ursprüngliche Nachricht-----

Von: Mladen Gogala [mailto:mladen_at_wangtrading.com] Gesendet: Wednesday, March 31, 2004 8:10 PM An: oracle-l_at_freelists.org
Betreff: Re: Urgent: db file sequential read - wait



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

-----------------------------------------------------------------
Received on Wed Mar 31 2004 - 14:24:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US