V$sql to dba_histxx adaptive features
From: Moustafa Ahmed <moustafa_dba_at_hotmail.com>
Date: Wed, 6 Jan 2021 00:58:00 +0000
Message-ID: <BN6PR06MB2785C89D5693CA1E21A2104AE1D00_at_BN6PR06MB2785.namprd06.prod.outlook.com>
Date: Wed, 6 Jan 2021 00:58:00 +0000
Message-ID: <BN6PR06MB2785C89D5693CA1E21A2104AE1D00_at_BN6PR06MB2785.namprd06.prod.outlook.com>
1-Are the below new 19c v$sql columns
"IS_RESOLVED_ADAPTIVE_PLAN" "IS_REOPTIMIZABLE"
Persisted to disk and exposed in any
DBA_HIST_xxxx views?
2-"IS_RESOLVED_ADAPTIVE_PLAN"
Confirms of the plan was adaptive only,Correct?
"IS_REOPTIMIZABLE"
Confirms that sql plan directives due to
Apative_plan_stariststics took place,
Correct?
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 06 2021 - 01:58:00 CET