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