SQL性能分析

botang

1. select sid, serial# from v$session where terminal='pts/1';
   
2. 
   
3. select  * from v$lock where sid=631;
   
4. 
   
5. select  * from v$session where blocking_session is not null;
   
6. 
   
7. select  sql_id from v$session where sid=932;
   
8. 
   
9. select * from v$sql where sql_id='3xf229cbjpxux';
   
10. 
    
11. desc v$sql;
    
12. 
    
13. select * from (select  * from v$sql order by  ELAPSED_TIME desc)   where rownum < 6;

复制代码