Re: Finding orphan sessions

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: tanmoydc@xxxxxxxxx
  • Date: Wed, 23 May 2007 13:25:59 -0500

Tanmoy,

You might mention the Oracle version and which server you are using. Are
these sessions local to the server or remote connections? What do you define
as an orphan? Only a database session, but no server process? Was the max
time an Oracle setting or a server setting? Did Oracle kill the session or
did an external process kill the session?

Dennis Williams

Other related posts: