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

Home -> Community -> Usenet -> c.d.o.server -> Re: Monitoring questionable long running sessions

Re: Monitoring questionable long running sessions

From: Joel Garry <joel-garry_at_home.com>
Date: 14 Jul 2004 14:35:31 -0700
Message-ID: <91884734.0407141335.41013bbe@posting.google.com>


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.html
Received on Wed Jul 14 2004 - 16:35:31 CDT

Original text of this message

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