Database Administration (MOSC)

MOSC Banner

disconnect or kill session

edited Dec 10, 2009 10:36PM in Database Administration (MOSC) 2 commentsAnswered
hi,

I try to find an interest to use "alter system disconnect session immediate" rather "alter system kill session". The msg in output is not the same (ORA-).

The online doc explains, it's the same. But why create the same action with two different statement ? 

SQL> show user
USER est "SYSTEM"
SQL> select * from v$mystat;
select * from v$mystat
                     *
ERREUR Ó la ligne 1 :
ORA-03113: fin de fichier sur canal de communication
ID de processus : 0
ID de session : 146,  NumÚro de sÚrie : 437

alter system kill session '146,439';

SQL> show user
USER est "SYSTEM"
SQL> select * from v$mystat;
select * from v$mystat

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