Script not working - High SQL Version Counts Script to determine reason(s) (Doc ID 438755.1)

Oct 12, 2022 8:43PM

Hi

We just downloaded the latest version from (Doc ID 438755.1)

When we run it with SQL ID

We get this error

SELECT * FROM TABLE(version_rpt('091sp53ytc00n'));

COLUMN_VALUE

----------------------------------------------------------------------------------------------------

Note:438755.1 Version Count Report Version 3.2.5 -- Today's Date 12-oct-22 15:30

RDBMS Version :19.0.0.0.0 Host: XXXXXX nstance 1 : xxxx1

Error :ORA-00904: "EXECUTIONS": invalid identifier

for Addr: Hash_Value: SQL_ID 091sp53ytc00n

0 select (sql_id) sql_id,max(Pseudo_cursor||'(PseudoCursor of '||

1 owner||'.'||object_name||')') query,max(hash_value) hash,max(raw

2 tohex(ADDRESS)) addr,sum(SHARABLE_MEM) SHARABLE_MEM,sum(PARSE_CA

3 LLS) PARSE_CALLS,sum(EXECUTIONS) EXECUTIONS from H$PSEUDO_CURSOR

Database Tuning (MOSC)