How to load xxx_sqlset_plans view

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Nov 2005 13:53:39 -0800
Message-ID: <1132523625.325195@yasure>

I am building a class on SQL Tuning with dbms_sqltune and dbms_xplan and everything is working with the exception that all_sqlset_plans is never populated resulting in:

SQL> SELECT *
   2 FROM TABLE(dbms_xplan.display_sqlset('UW Set','6hwjmjgrpsuaa'));

PLAN_TABLE_OUTPUT

---

SQL Tuning Set Name: UW Set
SQL Tuning Set Owner: UWCLASS
SQL_ID: 6hwjmjgrpsuaa
SQL Text: insert into wrh$_enqueue_stat (snap_id, dbid, instance_number,

           eq_type, req_reason, total_req#, total_wait#, succ_req#,
           failed_req#, cum_wait_time, event#) select :snap_id, :dbid,
           :instance_number, eq_type, req_reason, total_req#,total_wait#,
           succ_req#, failed_req#, cum_wait_time, event#  from
           v$enqueue_statistics where total_req# != 0 order by eq_type,
           req_reason


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

Error: cannot fetch specified explain plan from all_sqlset_plans

And not a single similar report at metalink I could find.

Any help will be appreciated.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sun Nov 20 2005 - 15:53:39 CST