-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|