Skip to Main Content
  • Questions
  • Connection Storm with Inactive sessions on ORACLE RAC

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Nikhil.

Asked: June 03, 2019 - 8:19 pm UTC

Last updated: June 05, 2019 - 6:12 am UTC

Version: 11.2.0.4.0

Viewed 1000+ times

You Asked

Hi All,



We recently migrated from Solaris to AIX and moved to Oracle RAC :



Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production



We are on 3 node. We never had this issue on single node Oracle on Solaris.



It's been 10 days and we are starting to have inactive session storm issues. More than 6K sessions are created and our application goes down during mid-day.



Any pointers where exactly we should look for?



Regards,

Nik

and Connor said...

Not sure what you mean by "inactive session storm". That sounds like just a normal connection storm?

Anyway, I would start with:

SQL> audit session

which will give you a record for every new session in DBA_AUDIT_TRAIL. That should give you a starting point of where the connections are coming from.

Is this answer out of date? If it is, please let us know via a Comment