Introduction to PL/SQL: PL/SQL guide in oracle 11g for naives to experts

Product Description This book has been written by giving enormous simple examples of each feature so it is easily understandable for new developers, and there are many advance features that most of the conventional books ignore so it is equally beneficial to the experts. There are more than 400 practical examples, which are being given … Read more

How To Kill Session In Oracle 11g Database With New Feature?

In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle 11g database. At this moment remote Oracle DBA should need to terminate session/process called as murder of session of any instance.   From Oracle 11g database there is new feature introduced to kill session from sqlplus. Alter system disconnect session command is introduced in Oracle 11g database with some extra new scope.

New feature in Oracle 11g database to kill session:

Using SQL*Plus (alter system with disconnect session command): Now we can kill session after finishing existing transaction to be finished. Means in previous release there was no scope to finish on going transaction. Instead of “alter system kill session” here we can use “alter system disconnect session”. Using syntax “POST_TRANSACTION” we can kill session for active transaction has to be completed first and after that it will be automatically killed. Example of same syntax is given

Read more