A variety of critical situation Oracle DBA has to make a decision to kill existing session or kill the backdrop procedure of Oracle 11g database. Distant Oracle DBA should require to finish session process called as terminate of the session of any instance. Dbametrix explain declaration of this issue. Oracle 11g database there is a fresh feature introduce to kill session from sql plus. Modify system cut off session command is introduced in Oracle 11g database with a number of additional new capacity.
We can kill session past finishing an accessible transaction to be ended. In previous release there was no range to close on going transaction. As an alternative of “alter system kill session” here we can utilize “alter system disconnect session”. Use syntax “POST_TRANSACTION” we can kill session for a active transaction has to be finished first and after that it will be mechanically killed. Example of same syntax is given below.
SQL> alter system disconnect session ‘9,171’ post_transaction;
Session can be kill with out ultimate energetic contract use “IMMEDIATE” syntax with “change system divide session” command. This command kill and end accessible session immediately away and roll back if any energetic transaction. This syntax is comparable as previous command “alter system kill session” with direct syntax as specified following example.
SQL> alter system disconnect session ‘9,171’ immediate;
When we are executing command “alter system disconnect session” without above both clauses (means POST_TRANSACTION & IMMEDIATE), error is being generated called ORA- 02000: missing POST_TRANSACTION or IMMEDIATE keyword.
Linux training to train some one to expand their Linux skill and obtain high quality job in present market. IcanXplore present Linux course for developers, programmers, immigrant and Un employed. Online Linux training build simple to obtain enhanced Linux ability.
We can not perform “alter system disconnect session” without exact keywords like post_transaction or instant. We can perform “alter system kill session” syntax with out any precise more syntax like direct in prior release of Oracle 11g database. This feature “alter system disconnect session” was introduce in Oracle 10g. In Oracle 10g database this characteristic and syntax was as latest feature of Oracle 10g database.
IcanXplore is from San Francisco bay area, in Silicon Valley, CA, USA, focused on providing Linux training around the world at own time, pace, 24/7. Only e-mail skill can renovate person into a successful Linux system administrator. Information technology professionals from Silicon Valley, CA, USA reveal effectual Linux training system to train person with basic knowledge of computer.