Re: ORA-00020 with orphaned processes

yong321_at_yahoo.com wrote:
> 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

Sorry for a little lack of thought. pslist lists process elapsed time, but on Windows, Oracle "processes" are OS threads. So you have to use tools like Process Explorer (also from sysinternals.com) to look at thread Start time, under the Threads tab.

Yong Huang Received on Wed Dec 08 2004 - 16:38:48 CST