Skip to Content
0
Former Member
Jun 11, 2009 at 03:45 AM

Trouble occurs when reading Oracle view V$SQLTEXT,Help me,Please!!!

50 Views

由于需要一个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