Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Monitoring questionable long running sessions
100.17706_at_germanynet.de (Rick Denoire) wrote in message news:<f0c1107f.0407130502.5d8088bd_at_posting.google.com>...
>
> The wait_event here is said to be "db file sequential read", but as
> far as I can see (and I can see far enough on the OS side), no I/O is
> taking place. It *can not* be waiting for that. It does not even show
> the file being read (it shows only "file#"). Repeating the query
> yields the same result.
FYI: http://www.hotsos.com/dnloads/1/kevents/db_file_sequential_read.html
jg
-- @home.com is bogus. http://www.bizjournals.com/denver/stories/2002/12/02/focus1.htmlReceived on Wed Jul 14 2004 - 16:35:31 CDT