on 06-19-2007 9:46 AM
Hello together,
is there anybody who knows what the "wait time" or "Wait time per execution" within a SQL-statement means?
Bye
Heike
Hello Heike,
the wait time displayed in the Oracle shared cursor cache in transaction ST04 is the time the SQL statement had to wait for a wait event (e.g. reading a block from disk, lock). More details on Oracle wait events are contained in note 619188. The total elapsed time of a SQL statement is the sum of CPU time (real work) and wait time.
Regards
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Wait time in milliseconds: This is the time a user request sits in the dispatcher queue. It starts when user request is entered in the dispatcher queue; and ends when the request starts being processed and it shud be
Wait time < 10% response time
(response time : Starts when a user request enters the dispatcher queue; ends when the next screen is returned to the user. The response time does not include the time to transfer from the screen to the front end.)
Regards
Umesh K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.