Skip to Content
0
Former Member
Jun 11, 2009 at 04:00 AM

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

16 Views

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