Well, I'll be danged. Good catch. I guess I should have reviewed all the
parameters more closely :)
Yes, adding "awr_location" does the trick!
Thanks!
select * from table
(dbms_xplan.display_workload_repository(sql_id=>'fvzdpy1950kya',awr_location=>'AWR_PDB'
))
/
Chris
On Fri, Jan 13, 2023 at 10:04 AM Jonathan Lewis <jlewisoracle@xxxxxxxxx>
wrote:
Are you querying from a PDB ?
In 19c (possibly only the later version thereof) the default report is
from the AWR_ROOT (in both functions)
If you want to report from the current PDB you have to add the parameter
"awr_location => 'AWR_PDB'"
Regards
Jonathan Lewis
On Thu, 12 Jan 2023 at 17:09, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
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
