March 10, 2011

Kill a session

To kill a session use:

ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id';



To kill a particular session use

ALTER SYSTEM KILL SESSION '7,15';(SID ID)
at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

Oracle HCM Extracts — A Practical Guide to Building Your First Integration Extract

  HCM Extracts are Oracle's built-in mechanism for extracting structured HR data for payroll interfaces, benefits carriers, and third-pa...

  • Custom Report Notes:
    While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS   go to propert...
  • Order To Cash
    Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales pers...
  • Number into word
    This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...