Home » RDBMS Server » Performance Tuning » "slave shutdown wait" - event
"slave shutdown wait" - event [message #138392] Wed, 21 September 2005 11:59 Go to next message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

hi,
i'm looking for info on this wait event : slave shutdown wait
can someone help/direct me ?
thanks
shlomi,
Re: "slave shutdown wait" - event [message #138397 is a reply to message #138392] Wed, 21 September 2005 13:13 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I found this in the 10gR1 docs. What version are you?

PX server shutdown
During normal or immediate shutdown the parallel execution slaves are posted to shutdown cleanly. If any parallel execution slaves are still alive after 10 seconds, they are killed.

Wait Time: Wait up to 0.5 seconds

Parameter Description
nalive The number of parallel execution slaves that are still running
sleeptime The total sleeptime since the session started to wait on this event
loop The number of times the session waited for this event



dispatcher shutdown
During shutdown immediate or normal, the shutdown process must wait for all the dispatchers to shutdown. As each dispatcher is signaled, the session that causes the shutdown is waits on this event until the requested dispatcher is no longer alive.

Wait Time: 1 second

Parameter Description
waited Indicates the cumulative wait time. After 5 minutes, the session writes to the alert and trace files to indicate that there might be a problem.
Previous Topic: Error while installing Statspack
Next Topic: Tuning the sql by using explain plan
Goto Forum:
  


Current Time: Sat Nov 23 17:46:41 CST 2024