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.
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!
Edited by: Guodong Wang on Jun 11, 2009 6:02 AM