Re: ORA-00020 with orphaned processes

I'm afraid you have to write v$session output to your own log with a DBMS job or OS job. Do your "orphaned" processes look like P0000, P0001... in v$process.program? If so, what does show parameter parallel tell you? Consider reducing parallel_min_servers and keep an eye on v$px_process and v$px_session. You can find the process start time from OS. Sysinternals.com's pslist shows Elapsed Time.

Yong Huang Received on Wed Dec 08 2004 - 13:56:27 CST