2014-08-02-5.sql

botang

select  * from v_$session s where s.TERMINAL='pts/1';

alter system kill session '78,1305' immediate;

--00000001E4551330
--135

select  * from v$transaction;

select * from v$lock where sid=135;


select   s.sid , s.TERMINAL  ,s.BLOCKING_SESSION   from v_$session s where s.TERMINAL  in  ( 'pts/2', 'pts/3') ;


select   s.sid , s.TERMINAL  ,s.BLOCKING_SESSION   from v_$session s
   where s.sid  in ( select   blocking_session  from v$session where blocking_session is not null);
   
   select   sid  from v$session where blocking_session is not null;
   
  
   
   
   create table hr.t05209_dead( employee_id number ,  salary number(8,2)  , manager_id number )   ;
   
   insert into  hr.t05209_dead  values ( 1, 1000.1, 100 ) ;
   
     insert into  hr.t05209_dead  values ( 2, 2000.2, 200 ) ;
     
     select  * from dba_rollback_segs;
     
      select  * from dba_tablespaces;
   
   alter tablespace undotbs1 retention noguarantee;