botang 发表于 2020-9-17 20:17:52

SQL性能分析

select sid, serial# from v$session where terminal='pts/1';

select* from v$lock where sid=631;

select* from v$session where blocking_session is not null;

selectsql_id from v$session where sid=932;

select * from v$sql where sql_id='3xf229cbjpxux';

desc v$sql;

select * from (select* from v$sql order byELAPSED_TIME desc)   where rownum < 6;




页: [1]
查看完整版本: SQL性能分析