Re: SQL tuning nightmare - db file sequential reads

<joshic75_at_gmail.com> a écrit dans le message de news: 1152122166.768543.41030_at_p79g2000cwp.googlegroups.com...
|
| Michel,
|
| <MC>
| >From doc. about v$session_wait.seconds_in_wait:
|
| <quote>
| If WAIT_TIME > 0, then SECONDS_IN_WAIT is the seconds since the start
| of the last wait
| ...
| WAIT_TIME = duration of last wait
| </quote>
|
| Your last wait time lasted 1cs and it started 897s before.
| </MC>
|
| Yikes! I have read this in the reference guide but am somewhat confused
| about what it means. I can understand 'Your last wait time lasted 1cs'
| but don't get what 'it started 897s before' means.
|

Sorry I didn't see your post as it was not attached to mine in the tree. This means that :

- you're not currently waiting
- your last wait last 1cs
- it begans 897s ago and ended 897s-1cs ago
- since 897s-1cs you're working (or have waited on something that is not instrumentalized in Oracle code)

Regards
Michel Cadot

|
| Thanks all,
| Charu.
|
Received on Fri Jul 07 2006 - 12:12:00 CDT