Monday, November 16, 2015

KILL Session 

SELECT SID, SERIAL# FROM V$SESSION WHERE USERNAME = 'username'
ALTER SYSTEM KILL SESSION '14,30';










By



at





















Labels:


















No comments:















Post a Comment






















        

      









Subscribe to:
Post Comments (Atom)









How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g/12c



1. Create Temporary Tablespace Temp create temporary tablespace temp2 tempfile '/mnt/mnt04/oradata/temp01.dbf'size 2000M;  2. Move D...