SQL Performance (MOSC)

MOSC Banner

ORA-13794 When comparing trials across 2 SQL Tuning sets.

edited Oct 2, 2019 3:03PM in SQL Performance (MOSC) 2 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center