Re: ORA-00018 but where are the connections coming from?
From: Andy Klock <andy_at_oracledepot.com>
Date: Mon, 21 Oct 2013 12:24:42 -0400
Message-ID: <CADo_RaMrEK9Gj5q4NKiW+Rt+OEjV+eceYJ5+L2xuaV2O471d-g_at_mail.gmail.com>
On Mon, Oct 21, 2013 at 11:58 AM, Rich Jesse < rjoralist3_at_society.servebeer.com> wrote:
>
> There's the possibility that the connections aren't logged via the listener
> (bequeath connections do not use the listener) or you may have a large
> number of job processes available that all became active, but the listener
> log could be a start for you.
>
> HTH! GL!
>
> Rich
>
>
>
Yeah, definitely the listener is a good place to start. But, also in 11g auditing defaults to DB and audits CREATE SESSION, so if it hasn't been disabled there may be some answers in DBA_AUDIT_SESSION:
Date: Mon, 21 Oct 2013 12:24:42 -0400
Message-ID: <CADo_RaMrEK9Gj5q4NKiW+Rt+OEjV+eceYJ5+L2xuaV2O471d-g_at_mail.gmail.com>
On Mon, Oct 21, 2013 at 11:58 AM, Rich Jesse < rjoralist3_at_society.servebeer.com> wrote:
>
> There's the possibility that the connections aren't logged via the listener
> (bequeath connections do not use the listener) or you may have a large
> number of job processes available that all became active, but the listener
> log could be a start for you.
>
> HTH! GL!
>
> Rich
>
>
>
Yeah, definitely the listener is a good place to start. But, also in 11g auditing defaults to DB and audits CREATE SESSION, so if it hasn't been disabled there may be some answers in DBA_AUDIT_SESSION:
http://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_3071.htm
Sometimes it's not new sessions that are the cause of the problem, but rather sessions that are supposed to close are failing to do so.
Andy
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 21 2013 - 18:24:42 CEST