AW: Urgent: db file sequential read - wait
- From: Stefan Jahnke <Stefan.Jahnke@xxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Mar 2004 20:26:50 +0200
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@xxxxxxxxxxxxxxx]
Gesendet: Wednesday, March 31, 2004 8:10 PM
An: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
Other related posts:
