Re: ORA-00018 but where are the connections coming from?

From: Andy Klock <>
Date: Mon, 21 Oct 2013 12:24:42 -0400
Message-ID: <>

On Mon, Oct 21, 2013 at 11:58 AM, Rich Jesse <> 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:

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.


Received on Mon Oct 21 2013 - 18:24:42 CEST

Original text of this message