Hi all
I need a SQL performance report,so I copy program of transaction:ST04OLD,It running very well until yesterday at background.but until now,it became very slow.
The transaction SM50 shows that this program is reading V$SQLTEXT at all times.
ABAP CODE:
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.
I need help,Please!
ALex
Best Regards!
Edited by: Guodong Wang on Jun 11, 2009 6:02 AM