查看数据库中运行时间最长的查询花费了多少秒

SQL> select dbms_undo_adv.longest_query(sysdate-1/24,sysdate) from dual;

 

DBMS_UNDO_ADV.LONGEST_QUERY(SYSDATE-1/24,SYSDATE)

-------------------------------------------------

910

 

SQL> select dbms_undo_adv.required_retention(sysdate-1/24,sysdate) from dual;

 

DBMS_UNDO_ADV.REQUIRED_RETENTION(SYSDATE-1/24,SYSDATE)

------------------------------------------------------

910