So, finally Oracle introduced Oracle database 12c (12.1.0.1). You can easily download it from oracle`s official site : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
For now only for Linux and Solaris platform`s download is available, soon for windows platform will have.
Thursday, June 27, 2013
Thursday, June 13, 2013
Kill Session vs Disconnect Session
Today my friend asked me what is the different between kill session and disconnect session. After researching I found useful information and here I`m going to share briefly.
Example:
SQL>ALTER SYSTEM DISCONNECT SESSION 'sid,serial#';
SQL>ALTER SYSTEM KILL SESSION 'sid,serial#';
For more details please refer to : http://oracletempspace.wordpress.com/2011/04/20/example-alter-sytem-disconnect-vs-alter-system-kill-for-currently-connected-sessions/
- Using Disconnect Session clause to disconnect the current session by destroying the dedicated server process.
- Using Kill Session clause let you mark a session as terminated, release locks.
Example:
SQL>ALTER SYSTEM DISCONNECT SESSION 'sid,serial#';
SQL>ALTER SYSTEM KILL SESSION 'sid,serial#';
For more details please refer to : http://oracletempspace.wordpress.com/2011/04/20/example-alter-sytem-disconnect-vs-alter-system-kill-for-currently-connected-sessions/
Subscribe to:
Posts (Atom)