DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - free process state object

free process state object

Used during the creation of a process. The session will scan the process table and look for a free process slot. If none can be found, PMON is posted to check if all the processes currently in the process table are still alive. If there are dead processes, then PMON will clean them and make the process slot available to new processes. The waiting process will then rescan the process table to find the new slot. If this happens often, one should consider increasing the size of the process table (processes init.ora parameter).