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,

FROM v$sql) a

WHERE COUNT > 20

ORDER BY COUNT DESC) b

WHERE num = 1