19c DISPLAY_AWR deprecated in favor of DISPLAY_WORKLOAD_REPOSITORY = Confused
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 12 Jan 2023 12:08:54 -0500
Message-ID: <CAP79kiTmYJ+Z9mWL15MxfvKukD+gVS9aLQuQwEVuQ8BzXLs17A_at_mail.gmail.com>
Ok, so my DBMS_XPLAN.DISPLAY_AWR scripts in 19c (19.14) do not seem to be working.
No problem, I check the docs for 19c and there's a note to start using DISPLAY_WORKLOAD_REPOSITORY. Ok, I can do that.
Date: Thu, 12 Jan 2023 12:08:54 -0500
Message-ID: <CAP79kiTmYJ+Z9mWL15MxfvKukD+gVS9aLQuQwEVuQ8BzXLs17A_at_mail.gmail.com>
Ok, so my DBMS_XPLAN.DISPLAY_AWR scripts in 19c (19.14) do not seem to be working.
No problem, I check the docs for 19c and there's a note to start using DISPLAY_WORKLOAD_REPOSITORY. Ok, I can do that.
However, neither is returning a plan for a stored SQL_ID and plan_hash_value and I'm very confused.
Setup:
19.14 with AWR in the CDB (not in the PDB) - Snapshots only occur at the
CDB level on this db.
One PDB per CDB.
I check DBID and CON_DBID and have played around with the arguments but it says it cannot find a result.
Anyone run into this and if so, how did you get it to work in 19c? (I'm still investigating but wanted to post here in case someone ran into this already and got it to work)
Thanks,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 12 2023 - 18:08:54 CET