课程第19次

secoug

1. select  * from tvalue order by 1  desc;
   
2. 
   
3. select  * from v$lock;
   
4. 
   
5. select * from dba_lock;
   
6. 
   
7. 
   
8. select s."TERMINAL" ,  s."SID"
   
9. from v$session s , v$process p
   
10. where s."PADDR"=p."ADDR"
    
11. and s."TERMINAL"  in ('pts/0','pts/1');
    
12. 
    
13. select  * from v$lock where sid  in (21,78);
    
14. 
    
15. 
    
16. select  *  from dba_objects o where o.object_id  in (
    
17. 88047 ,89523);

复制代码

1. 
   
2. 
   
3. select  * from v$lock where sid  in (21,78);
   
4. 
   
5. select  distinct  blocking_session   from v$session ;
   
6. 
   
7. select  s.sid
   
8.   from v$session s
   
9.   where s."BLOCKING_SESSION"  is not null;
   
10.   
    
11.   

复制代码