Optimizer settings in 21C in Oracle

 SQL> show parameter optimizer

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

optimizer_adaptive_plans             boolean     TRUE

optimizer_adaptive_reporting_only    boolean     FALSE

optimizer_adaptive_statistics        boolean     FALSE

optimizer_capture_sql_plan_baselines boolean     FALSE

optimizer_capture_sql_quarantine     boolean     FALSE

optimizer_cross_shard_resiliency     boolean     FALSE

optimizer_dynamic_sampling           integer     2

optimizer_features_enable            string      21.1.0

optimizer_ignore_hints               boolean     FALSE

optimizer_ignore_parallel_hints      boolean     FALSE

optimizer_index_caching              integer     0

optimizer_index_cost_adj             integer     100

optimizer_inmemory_aware             boolean     TRUE

optimizer_mode                       string      ALL_ROWS

optimizer_real_time_statistics       boolean     FALSE

optimizer_secure_view_merging        boolean     TRUE

optimizer_session_type               string      NORMAL

optimizer_use_invisible_indexes      boolean     FALSE

optimizer_use_pending_statistics     boolean     FALSE

optimizer_use_sql_plan_baselines     boolean     TRUE

optimizer_use_sql_quarantine         boolean     TRUE

SQL*Plus: Release 21.0.0.0.0 - Production on Fri Apr 28 22:17:53 2023

Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to:

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Version 21.3.0.0.0

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

    CON_ID

----------

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Version 21.3.0.0.0

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

         0

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

    CON_ID

----------