Re: display_cursor with PLAN_HASH_VALUE
Date: Mon, 3 Feb 2020 14:57:35 -0500
Message-ID: <CAP79kiSuDJpJ-8Kjw56Qr1k1iXVtHBs5yWBv_HL0hjsX7AMbGg_at_mail.gmail.com>
There's
select * from table (
dbms_xplan.display_awr('&&SQL_ID',&&plan_hash_value, &&dbid,
'ADVANCED, ALL')
);
You'll need to pop the DBID from v$database however.
Chris
On Mon, Feb 3, 2020 at 1:45 PM kyle Hailey <kylelf_at_gmail.com> wrote:
>
> Wondering if there is a way to use display_cursor or some similar
> procedure with PLAN_HASH_VALUE instead of SQL_ID.
> The procedure display_cursor takes the SQL_ID and CHILD_NUMBER as
> arguments, but what if I just had SQL_ID and PLAN_HASH_VALUE?
> I guess I could query the PLAN views directly or look up the child # from
> the PLAN_HASH_VALUE.
> But just wondering if there is already a procedure where I could just give
> the PLAN_HASH_VALUE directly and get output like display_cursor.
>
> Kyle
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 03 2020 - 20:57:35 CET