ORA-00018 but where are the connections coming from?

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Mon, 21 Oct 2013 13:02:41 +0100
Message-ID: <CAPMSPxMrQ33BEVHmm--vghJRcutHg66Mw_Z+9Rn7==0u4Twk8A_at_mail.gmail.com>

Database: Oracle EE
OS: RHL 4 Hi
This Saturday just gone, one of our production databases suffered a partial outage because all of the available sessions on the first of the two cluster instances got used up.

We only have the local database console recording management data, which connects to instance 1, so as a result there is about a 3 hour gap in what I can see in dba_hist_active_sess_history.

Having checked dba_hist_resource_limit, I can see when the problem occurred by the lack of snapshots on instance 1.

Anybody got any good ideas on how to find out where the sessions originated from?


Received on Mon Oct 21 2013 - 14:02:41 CEST

Original text of this message