Seconds in wait

The term “seconds in wait” means the number of seconds that a SQL Statement, Database User, etc. was waiting on an event. It is possible that the total number of “seconds in wait” exceeds the total amount of time in the period. The following example will illustrate how this occurs.

 

Example: Assume that one session locks a row that is needed by ten other sessions. All ten sessions will wait for the lock. Also assume that the session holds the lock for one hour. Since each of the ten sessions waited for one hour, Ignite will show total wait time of ten hours during the one hour period.

 

The maximum theoretical wait time during a period is the number of session multiplied by the length of the period.

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569