查询sql语句执行次数

SELECT

COUNT exe_count , module , SQL_TEXT

FROM ( SELECT ROW_NUMBER ()

OVER (PARTITION BY SUBSTR ( SQL_TEXT , 1 , 50 )

ORDER BY SQL_TEXT )

num

,

a. *

FROM (SELECT COUNT ( * )

OVER (PARTITION BY SUBSTR ( SQL_TEXT , 1 , 50 ))

COUNT,

SQL_TEXT

,

SHARABLE_MEM

,

PERSISTENT_MEM

,

RUNTIME_MEM

,

SORTS

,

LOADED_VERSIONS

,

OPEN_VERSIONS

,

USERS_OPENING

,

FETCHES

,

EXECUTIONS

,

USERS_EXECUTING

,

LOADS

,

FIRST_LOAD_TIME

,

INVALIDATIONS

,

PARSE_CALLS

,

DISK_READS

,

BUFFER_GETS

,

ROWS_PROCESSED

,

COMMAND_TYPE

,

OPTIMIZER_MODE

,

OPTIMIZER_COST

,

PARSING_USER_ID

,

PARSING_SCHEMA_ID

,

KEPT_VERSIONS

,

ADDRESS

,

TYPE_CHK_HEAP

,

HASH_VALUE

,

PLAN_HASH_VALUE

,

CHILD_NUMBER

,

MODULE

,

MODULE_HASH

,

ACTION

,

ACTION_HASH

,

SERIALIZABLE_ABORTS

,

OUTLINE_CATEGORY

,

CPU_TIME

,

ELAPSED_TIME

,

OUTLINE_SID

,

CHILD_ADDRESS

,

SQLTYPE

,

REMOTE

,

OBJECT_STATUS

,

LITERAL_HASH_VALUE

,

LAST_LOAD_TIME

,

IS_OBSOLETE

,

CHILD_LATCH

FROM v$sql ) a

WHERE COUNT > 20

ORDER BY COUNT DESC) b

WHERE num = 1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-710388/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-710388/