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

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 22 Oct 2013 13:44:23 +0100
Message-ID: <CAPMSPxN7__k=XWT1WT8WoZj1bax_2T4GcQtG3NM4ZoT1WBXU5Q_at_mail.gmail.com>

Hi
Thanks both for the replies.
I got the kick I needed. The problem does appear to come down to applications for one app server all connecting from around mid-night and running for longer than expected, leading to the all the session slots being exhausted by the afternoon.
Regards
Pete

On 21 October 2013 17:24, Andy Klock <andy_at_oracledepot.com> wrote:

> 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-l
>
>
>

-- 
Regards

Pete


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 22 2013 - 14:44:23 CEST