Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does INACTIVE sessions really consume any resources or have any IMPACT on performance of the databas

Think_dbaMay 23 2014 — edited May 30 2014

OS-IBM AIX 6 bit platform

Oracle:11.2.0.3.0

Hi Experts/folks,, It could be another repeated question about INACTIVE sessions ,,but this time i want to understand ,,please bear with me..

So if i have around 300+ INACTIVE sessions in a database which all have last_call_et time is large...Do they really consume some resources or have any bad performance impact on the database..

Because recently i have encountered a case in prod environment..where slowness reported and when i killed all INACTIVE sessions ..it was fine..

But i am not sure if this was due to the INACTIVE sessions..Please clear my doubts...

Regards

Think_DBA

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2014

Added on May 23 2014

#general-database-discussions

19 comments

17,601 views