我想查询下共享区中存在的耗时最长的sql语句,sql如下:
select SQL_TEXT, ELAPSED_TIME from v$sqlarea where ELAPSED_TIME in (select max( ELAPSED_TIME) from v$sqlarea);
但是有时候查不出来数据,有时候就能出来,请问这是为什么呢?
SQL> select SQL_TEXT, ELAPSED_TIME from v$sqlarea where ELAPSED_TIME in (select max( ELAPSED_TIME) from v$sqlarea);
no rows selected
SQL>
SQL> /
SQL_TEXT
--------------------------------------------------------------------------------
ELAPSED_TIME
------------
select idr_id from usage_bppp_20110701 where customer_id = :v1 and session_id =
:v2 and acct_status = :v3 and nas_ip = :v4 6353020918127
再就是这个ELAPSED_TIME 是 6353020918127 这个时间这么会这么大呢,正常吗?