Re: many seconds waiting for I/O?

Hi

I was joining v$session, v$sess_io, and v$process, the interval every 5 to
10 seconds

Thanks

Alex



On 7/27/07, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> wrote:
>
>
> It would be interesting to see the actual SQL Query that you used to
> generate this list.
> Which views have you joined together  ? At what interval did you
> generate these snapshots ?
> Why do I ask ?
> How do you get Consistent_Gets being reported with Wait_Time and
> Seconds_In_Wait ?
> Your Consitent_Gets  are increasing but the Seq#  remains the same.
> There is some inconsistency in your listing.
>
> Hemant
>
> At 05:09 PM Friday, amonte wrote:
> >Hi
> >
> >I have a batch process running and it seems that it's waiting for
> >I/O all the time, the strange thing is it shows 400 seconds waits!
> >
> >EVENT                      CONSISTENT_GETS SPID          WAIT_TIME
> >SECONDS_IN_WAIT STATE                     SEQ#
> >-------------------------- --------------- ------------ ----------
> >--------------- ------------------- ----------
> >db file sequential read             212532
> >25879                -1             374 WAITED SHORT TIME          892
> >
> >
> >EVENT                      CONSISTENT_GETS SPID          WAIT_TIME
> >SECONDS_IN_WAIT STATE                     SEQ#
> >-------------------------- --------------- ------------ ----------
> >--------------- ------------------- ----------
> >db file sequential read             212717
> >25879                -1             431 WAITED SHORT TIME          892
> >
> >
> >EVENT                      CONSISTENT_GETS SPID          WAIT_TIME
> >SECONDS_IN_WAIT STATE                     SEQ#
> >-------------------------- --------------- ------------ ----------
> >--------------- ------------------- ----------
> >db file sequential read             212925
> >25879                -1             504 WAITED SHORT TIME          892
> >
> >What can cause this???
> >
> >Thanks!
> >
> >Alex
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> "First they ignore you, then they laugh at you, then they fight you,
> then you win" !"
> Mohandas Gandhi Quotes
> :  http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
>

Other related posts: