DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to remove inactive sessions?

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    how to remove inactive sessions?

    hi, before shutting down database
    i observed many sessions in v$session view.
    most of them exists eventhough the users closed their applications.
    why does it happens?
    I think this happens because network failure for some time.
    how remove all the sessions?
    will it be problem if i shutdown the database as it is?

    thanks

  2. #2
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    No Problem, if you fire

    SQL> shutdown immediate

    even if you have sessions inactive.

    Inactive sessions can be killed not removed, in case you kill the session it will show the status as KILLED in v$session

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width