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]