Hi Kyle, not to my knowledge. dbms_xplan.display_awr can be used how you
describe, but depending on the cursor isn't always available.
Andy K
On Mon, Feb 3, 2020 at 1:46 PM kyle Hailey <kylelf@xxxxxxxxx> 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
