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

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