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)

Building an Employee Attrition Prediction Model with Azure ML Studio and Oracle HCM

  Category: Azure ML / HCM Integration Tags: Azure ML, OTBI, VBCS, Attrition Predicting employee attrition before it happens is one of the m...

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