Database Administration (MOSC)

MOSC Banner

Sessions

edited Feb 20, 2014 3:38PM in Database Administration (MOSC) 4 commentsAnswered

When I am checking my Active/Non Active sessions

example
My Inactive Sessions will show a count of 325 and Active will show 39

How is Oracle cleaning up my inactive sessions? Thinking it's PMON job?  Is there a default number on how long INACTIVE sessions hang around, and  can I change this value?

What i am seeing once my session count hits about 700 the database hangs, also the application server sessions start to back up.

Can you point me in the direction to debug this issue, and let me know if there is anything else you need.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center