ORA-00020 with orphaned processes

From: Dom <post.to.group_at_newsgroup.com>
Date: Tue, 07 Dec 2004 21:23:55 GMT
Message-ID: <Lbptd.697$9r.496@newsfe4-win.ntli.net>

RDBMS Version: 7.3.4
OS: NT 4 SPa

Is there any way to keep a log of v$session (or similar) so I can try and track what is causing our ORA-00020 problem (our 7.3.4 db which was running fine now seems to max out at 500 orphaned processes after a day or two - only 30 or so show up in v$session). I thought of using a logon trigger but this isn't available in 7.3.4. I can view the orphaned processes using v
$process (select * from v$process where addr not in (select paddr from v
$session) but don't really know when the session was launched and other
much needed info. Any ideas would be much appreciated - I would love to upgrade but this is not an option in this case. Is it possible to do a trace of just the logon so I can get the paddr and reference it back?

Thanks

Dom Received on Tue Dec 07 2004 - 15:23:55 CST