Re: 19c DISPLAY_AWR deprecated in favor of DISPLAY_WORKLOAD_REPOSITORY = Confused

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_at_gmail.com> 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
>
>

--
http://www.freelists.org/webpage/oracle-l