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