ORA-13794 When comparing trials across 2 SQL Tuning sets.
Hi.
I am trying to get a SQL performance comparison, between two trials, each of which is associated with two separate tuning set. When I do this I get the error ORA-13794: execution type mismatch.
My database version is 12.2.0.1.
Here are the steps:
I run a SQL statement which has a hint, /* BLUEPACK3 */, so that I can recognise the SQL when loading my tuning set. I then execute the following steps in sqlplus:
(exec_sts.sql)
DECLARE
v_sts_name VARCHAR2(30) := UPPER('&&1');
v_comment VARCHAR2(50);
c_sqlarea_cursor DBMS_SQLTUNE.SQLSET_CURSOR;
BEGIN
v_comment := 'DUA-' || v_sts_name;