AW: Urgent: db file sequential read - wait

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

On 03/31/2004 12:58:53 PM, John Kanagaraj wrote:
> Hi Stefan,
>
> Not many realize this, but v$session_wait records and displays the _last_
> *instrumented* wait event.

That is not quite true. If the status is "WAITING", then the session is waiting now.
If the list manager throws me out because of the stupid percentage of the quoted text,
I'll start including random comments after my replies. It happened to me 3 times so far
and it is really, really annoying. Can we allow approximately 60% of the quoted text?
That would be ideal.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
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
----------------------------------------------------------------
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
-----------------------------------------------------------------