Toad World® Forums

Should this pipelined table work in 13.0.0.66?


#1

SELECT *
FROM TABLE (DBMS_SQLTUNE.select_workload_repository (
begin_snap => 31771,
end_snap => 31777,
basic_filter => ‘parsing_schema_name not in (’‘DBSNMP’’,’‘SYS’’,’‘ORACLE_OCM’’)’,
ranking_measure1 => ‘elapsed_time’,
result_limit => 250));

Access violation at address 000000000499FAA9 in module ‘Toad.exe’. Read of address FFFFFFFFFFFFFFFF

This query provides results in SQLPlus and SQL Developer.


#2

That’s some timing you’ve got there.

There are ANYDATA datatypes inside that BIND_LIST column. We just fixed a bug with this about an hour ago.

It should be fixed in the GA, and if we have another beta (not including today’s), it should work there too.

As a workaround, do this:

SELECT SQL_ID, FORCE_MATCHING_SIGNATURE, SQL_TEXT, OBJECT_LIST, BIND_DATA, PARSING_SCHEMA_NAME, MODULE, ACTION, ELAPSED_TIME, CPU_TIME, BUFFER_GETS, DISK_READS, DIRECT_WRITES, ROWS_PROCESSED, FETCHES, EXECUTIONS, END_OF_FETCH_COUNT, OPTIMIZER_COST, OPTIMIZER_ENV, PRIORITY, COMMAND_TYPE, FIRST_LOAD_TIME, STAT_PERIOD, ACTIVE_STAT_PERIOD, OTHER, PLAN_HASH_VALUE, SQL_PLAN, CON_DBID
FROM TABLE (DBMS_SQLTUNE.select_workload_repository (
begin_snap => 31771,
end_snap => 31777,
basic_filter => ‘parsing_schema_name not in (’‘DBSNMP’’,’‘SYS’’,’‘ORACLE_OCM’’)’,
ranking_measure1 => ‘elapsed_time’,
result_limit => 250));


#3

Thanks for the quick response! Also a big “thank you” to your team for implementing one of my suggestions in this beta, the ability to exclude directory grants from a user script.