Thursday, June 27, 2013

Oracle database 12c now available!

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 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.

  • 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/


Cannot access dba_directories inside procedure

 Recently I faced one of familiar Oracle error ORA -00942 : table or view does not exist   I got it in while compiling procedure, becaus...