Re: ORA-00018 but where are the connections coming from?
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: rjoralist3@xxxxxxxxxxxxxxxxxxxxx
- Date: Mon, 21 Oct 2013 12:24:42 -0400
On Mon, Oct 21, 2013 at 11:58 AM, Rich Jesse <
rjoralist3@xxxxxxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
