DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - prior process spawner to be cleaned up

prior process spawner to be cleaned up

When a prior process has died while spawning a background, the current process which is trying to spawn new a background must wait until the prior process state is cleaned up. Wait Time:

Usually 3 - 10 seconds

Parameter

Description

process_pid

process identifier (see V$PROCESS.PID) of the process whose state needs to be cleaned up.

process_sno

process serial number (see V$PROCESS.SERIAL#) of the process whose state needs to be cleaned up.