display_cursor with PLAN_HASH_VALUE
From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 3 Feb 2020 10:43:48 -0800
Message-ID: <CADsdiQgtfS+xjbFzy_Rb0EQf-_yJvmaEU-k2Pt=TKwZJxADRFA_at_mail.gmail.com>
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.
Date: Mon, 3 Feb 2020 10:43:48 -0800
Message-ID: <CADsdiQgtfS+xjbFzy_Rb0EQf-_yJvmaEU-k2Pt=TKwZJxADRFA_at_mail.gmail.com>
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 - 19:43:48 CET