Database Administration (MOSC)

MOSC Banner

old inactive sessions

On a given database we're having report of old sessions in V$session, which are stated as being INACTIVE. The oldest are more than 1 month old, and they are NOT from the day of starting of the instance (which also has inactive sessions but they are detailed as system sessions anyway).


But for these " inactive " processes, old (1 month+) and having special USERNAME, special OSUSER, special MACHINE,

I'm thinking : there shouldn't be a reason for them to be there, right ?

So the question I have is: why is Oracle database keeping these inactive sessions ?

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