cancel
Showing results for 
Search instead for 
Did you mean: 

shared cursor cache at ST04- What means the "wait tim"?

higgic
Explorer
0 Kudos

Hello together,

is there anybody who knows what the "wait time" or "Wait time per execution" within a SQL-statement means?

Bye

Heike

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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