由于需要一个SQL执行效率报表,我把ST04OLD中SQL request的取数代码复制成新程序,前段时间一直运行正常,只需10分钟左右,最近,运行非常缓慢!
ST04OLD中的取数限制条件为默认!
SM50查看,发现程序一直在读取V$SQLTEXT这个视图
程序中与V$SQLTEXT相关的代码为:
EXEC SQL PERFORMING APPEND_VSQLTEXT.
SELECT
ADDRESS,
HASH_VALUE,
COMMAND_TYPE,
PIECE,
SQL_TEXT
FROM V$SQLTEXT
INTO :V_SQLTEXT_TAB
WHERE SQL_ID IN
( SELECT DISTINCT SQL_ID FROM V$SQL
WHERE EXECUTIONS >= :ABAP_REST-EXECUTIONS
AND DISK_READS >= :ABAP_REST-DISKREADS
AND USERS_EXECUTING >= :ABAP_REST-CURRENTEXE
AND BUFFER_GETS >= :ABAP_REST-BUFFERGETS
AND PERSISTENT_MEM >= :ABAP_REST-SHAREDMEM
AND SQL_TEXT LIKE :ABAP_REST-SQLTEXT
)
ENDEXEC.
Edited by: Guodong Wang on Jun 11, 2009 6:01 AM