SQL Report SQLID: ggyuy60qqy2w2

PLANS		GLOBAL		CURSOR SHARING AND BINDS		
Last Execution Plan		SQL Text		Peeked vs Monitored Bind Values - In Memory	
Plan Summary		SQL History		Peeked vs Captured Bind Values - In Memory	
All Execution Plans		Parameters(Non-Default Values)	Peeked vs Captured Bind Values - AWR	
Historical Execution Plans		Instance Parameters				
Plan Control Objects		Observations				
		DBMS_STATS Table Preferences				

TABLES		INDEXES		ACTIVE SESSION HISTORY(ASH)		
Table Columns		Index Columns		ASH by Plan (in Memory)		
Table Partitions		Index Partitions		ASH by Plan Line (in Memory)		
Table Constraints				ASH by Plan 		
Table Modifications				ASH by Plan Line		

MISCELLANEOUS						
SQL Object Dependency



SQL Text The SQL text of the target query

Text
select /*+ test01 */object_id,object_name,object_type from t1 where object_id = 9527

Go To Main Menu



Observations The system observations

#PriorityTypeNameObjectObservationDetails
150DBMS_STATSSYSTEM STATISTICSWorkload CBO System Statistics are not gathered. CBO is using default values.(150)Consider gathering workload system statistics using DBMS_STATS.GATHER_SYSTEM_STATS.
See also 465787.1.

Go To Main Menu



Table Columns A list of physical Table attributes

TABLE_NAME: SYSTEM.T1

IndexesColumn
ID		Column
Name		Data
Type		Data
Default		NullableNum
Nulls		Sample
Size		Num
Distinct		Low
Value		High
Value		Last
Analysed		Average
Col Length		DensityNum
Buckets		HistogramHidden
Column		Virtual
Column		Global
Stats		User
Stats
14OBJECT_IDNUMBERY070838708382717972023-10-10/16:14:155 1.411672e-051NONENONOYESNO
1SYS_NC00029$NUMBER0Y0708381002023-10-10/16:14:152 1.000000e+001NONEYESYESYESNO
01OWNERVARCHAR2Y07083824APPQOSSYSXDB2023-10-10/16:14:155 4.166667e-021NONENONOYESNO
02OBJECT_NAMEVARCHAR2Y07083857068/8477e677_AMD64CodeGeneratorAMD64MIR2LIRConverterAMD64RedundantEschedFileWatcherJava2023-10-10/16:14:1539 1.752296e-051NONENONOYESNO
03SUBOBJECT_NAMEVARCHAR2Y4007930759723$VSN_1WRR_REPLAY_THREAD_P12023-10-10/16:14:157 1.383126e-031NONENONOYESNO
05DATA_OBJECT_IDNUMBERY63521731772782717922023-10-10/16:14:152 1.374004e-041NONENONOYESNO
06OBJECT_TYPEVARCHAR2Y07083848CLUSTERXML SCHEMA2023-10-10/16:14:1510 2.083333e-021NONENONOYESNO
07CREATEDDATEY0708386582023-09-02 23:29:012023-10-10 15:53:062023-10-10/16:14:158 1.519757e-031NONENONOYESNO
08LAST_DDL_TIMEDATEY0708388212008-11-18 10:54:012023-10-10 15:56:012023-10-10/16:14:158 1.218027e-031NONENONOYESNO
09TIMESTAMPVARCHAR2Y0708387531990-08-26:11:25:002023-10-10:15:56:012023-10-10/16:14:1520 1.328021e-031NONENONOYESNO
010STATUSVARCHAR2Y0708382INVALIDVALID2023-10-10/16:14:157 5.000000e-011NONENONOYESNO
011TEMPORARYVARCHAR2Y0708382NY2023-10-10/16:14:152 5.000000e-011NONENONOYESNO
012GENERATEDVARCHAR2Y0708382NY2023-10-10/16:14:152 5.000000e-011NONENONOYESNO
013SECONDARYVARCHAR2Y0708382NY2023-10-10/16:14:152 5.000000e-011NONENONOYESNO
014NAMESPACENUMBERY0708382411472023-10-10/16:14:154 4.166667e-021NONENONOYESNO
015EDITION_NAMEVARCHAR2Y7083802023-10-10/16:14:150 0.000000e+000NONENONOYESNO
016SHARINGVARCHAR2Y0708384DATA LINKNONE2023-10-10/16:14:1514 2.500000e-011NONENONOYESNO
017EDITIONABLEVARCHAR2Y43313275252NY2023-10-10/16:14:152 5.000000e-011NONENONOYESNO
018ORACLE_MAINTAINEDVARCHAR2Y0708382NY2023-10-10/16:14:152 5.000000e-011NONENONOYESNO
019APPLICATIONVARCHAR2Y0708381NN2023-10-10/16:14:152 1.000000e+001NONENONOYESNO
020DEFAULT_COLLATIONVARCHAR2Y55383154551USING_NLS_COMPUSING_NLS_COMP2023-10-10/16:14:155 1.000000e+001NONENONOYESNO
021DUPLICATEDVARCHAR2Y0708381NN2023-10-10/16:14:152 1.000000e+001NONENONOYESNO
022SHARDEDVARCHAR2Y0708381NN2023-10-10/16:14:152 1.000000e+001NONENONOYESNO
023IMPORTED_OBJECTVARCHAR2Y0708381NN2023-10-10/16:14:152 1.000000e+001NONENONOYESNO
024SYNCHRONOUS_DUPLICATEDVARCHAR2Y0708381NN2023-10-10/16:14:152 1.000000e+001NONENONOYESNO
025CREATED_APPIDNUMBERY7083802023-10-10/16:14:150 0.000000e+000NONENONOYESNO
026CREATED_VSNIDNUMBERY7083802023-10-10/16:14:150 0.000000e+000NONENONOYESNO
027MODIFIED_APPIDNUMBERY7083802023-10-10/16:14:150 0.000000e+000NONENONOYESNO
028MODIFIED_VSNIDNUMBERY7083802023-10-10/16:14:150 0.000000e+000NONENONOYESNO

Go To Main Menu



Table Constraints Table constraints and if they are enabled or not

No data was found for this section



Go To Main Menu



Table Partitions A list of partitions and their physical attributes

No data was found for this section



Go To Main Menu



Table Modifications Table insert, updates, deletes and other physical changes

No data was found for this section



Go To Main Menu



DBMS_STATS Table Preferences The DBMS_STATS Table preferences

OBJECT_OWNEROBJECT_NAMEPREFERENCE_NAMEPREFERENCE_VALUE
SYSTEMT1

Go To Main Menu



Index Columns Physical attributes of indexed columns and if they are used in the plan or not

TABLE_NAME: SYSTEM.T1

Used?Index
Name		Index
Owner		Column
Position		Column
ID		Column
Name		Desc/
Asc		Num
Nulls		Sample
Size		Num
Distinct		Low
Value		High
Value		Last
Analyzed		Average
Column
Length		DensityNum
Buckets		HistogramGlobal
Stats?		User
Stats?
NIDX_OBJECT_ID0SYSTEM14OBJECT_IDASC070838708382717972023-10-10/16:14:155 1.411672e-051NONEYESNO
NIDX_OBJECT_ID0SYSTEM2SYS_NC00029$ASC0708381002023-10-10/16:14:152 1.000000e+001NONEYESNO

Go To Main Menu



Index Partitions Partition information for partitioned indexes

No data was found for this section



Go To Main Menu



SQL Object Dependency Dependency description between objects

OWNERObject
Name		Object
Type
SYSTEMUNDEFINED/INVALID
SYSTEMT1TABLE

Go To Main Menu



SQL History Historical execution information in chronological order

No data was found for this section



Go To Main Menu



Plan Summary Execution Plans performance metrics for SQL while still in memory. Plans ordered by average elapsed time.

No data was found for this section



Go To Main Menu



Last Execution Plan The execution plan found in memory


Inst: 1   Child: 0   Plan hash value: 3617692013
 
-----------------------------------------------------------------------------------
| Id  | exeOrd| Operation         | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
-----------------------------------------------------------------------------------
|   0 |  N/A  | SELECT STATEMENT  |      |        |       |   412 (100)|          |
|*  1 |  N/A  |  TABLE ACCESS FULL| T1   |      1 |    54 |   412   (1)| 00:00:01 |
-----------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
 
   1 - SEL$1 / "T1"@"SEL$1"
Outline Data
 
  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('23.1.0')
      DB_VERSION('23.1.0')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      FULL(@"SEL$1" "T1"@"SEL$1")
      END_OUTLINE_DATA
  */
Predicate Information (identified by operation id):
 
   1 - filter("OBJECT_ID"=9527)
Column Projection Information (identified by operation id):
 
   1 - "OBJECT_NAME"[VARCHAR2,128], "OBJECT_ID"[NUMBER,22], 
       "OBJECT_TYPE"[VARCHAR2,23]
Hint Report (identified by operation id / Query Block Name / Object Alias):
Total hints for statement: 1 (E - Syntax error (1))
---------------------------------------------------------------------------
 
   1 -  SEL$1
         E -  test01
Note
   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level
Query Block Registry:
 
  SEL$1 (PARSER) [FINAL]

Go To Main Menu



All Execution Plans All execution plans from non-memory sources


Inst: 1   Child: 0   Plan hash value: 3617692013
 
-----------------------------------------------------------------------------------
| Id  | exeOrd| Operation         | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
-----------------------------------------------------------------------------------
|   0 |  | SELECT STATEMENT  |      |        |       |   412 (100)|          |
|*  1 |  |  TABLE ACCESS FULL| T1   |      1 |    54 |   412   (1)| 00:00:01 |
-----------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
 
   1 - SEL$1 / "T1"@"SEL$1"
Outline Data
 
  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('23.1.0')
      DB_VERSION('23.1.0')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      FULL(@"SEL$1" "T1"@"SEL$1")
      END_OUTLINE_DATA
  */
Predicate Information (identified by operation id):
 
   1 - filter("OBJECT_ID"=9527)
Column Projection Information (identified by operation id):
 
   1 - "OBJECT_NAME"[VARCHAR2,128], "OBJECT_ID"[NUMBER,22], 
       "OBJECT_TYPE"[VARCHAR2,23]
Hint Report (identified by operation id / Query Block Name / Object Alias):
Total hints for statement: 1 (E - Syntax error (1))
---------------------------------------------------------------------------
 
   1 -  SEL$1
         E -  test01
Note
   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level
Query Block Registry:
 
  SEL$1 (PARSER) [FINAL]

Go To Main Menu



Historical Execution Plans Historical execution plans including Outline data

No data was found for this section



Go To Main Menu



Plan Control Objects Information related to Profiles and Baselines

No data was found for this section



Go To Main Menu



Parameters(Non-Default Values) A list of system parameters with non-default values

RownumParameter
Name		Instance
ID		OrdinalIs
Default		Is
Modified		ValueDisplay
Value		Description
1_datafile_write_errors_crash_instance11FALSEFALSEFALSEdatafile write errors crash instance
2_db_writer_coalesce_area_size11FALSEFALSE1677721616MSize of memory allocated to dbwriter for coalescing writes
3_disable_interface_checking11FALSEFALSETRUEdisable interface checking at startup
4_enable_NUMA_support11FALSEFALSEFALSEEnable NUMA support and optimizations
5_file_size_increase_increment11FALSEFALSE21432893442044MAmount of file size increase increment, in bytes
6_fix_control11FALSEFALSE18960760:onbug fix control parameter
7_gc_policy_time11FALSEFALSE20how often to make object policy decisions in minutes
8_gc_undo_affinity11FALSEFALSETRUEif TRUE, enable undo affinity
9compatible11FALSEFALSE23.0.0.0Database will be completely compatible with this software version
10control_files11FALSEFALSE+RECO/CDB23C_ZGH_KIX/CONTROLFILE/current.256.1149786007control file names list
11control_management_pack_access11FALSEFALSEDIAGNOSTIC+TUNINGdeclares which manageability packs are enabled
12cpu_count11FALSEFALSE8maximum number of CPUs
13cursor_sharing11FALSEFALSEEXACTcursor sharing mode
14db_block_checking11FALSEFALSEOFFheader checking and data and index block checking
15db_block_checksum11FALSEFALSETYPICALstore checksum in db blocks and check during reads
16db_block_size11FALSEFALSE8192Size of database block in bytes
17db_create_file_dest11FALSEFALSE+DATAdefault database location
18db_create_online_log_dest_111FALSEFALSE+RECOonline log/controlfile destination #1
19db_domain11FALSEFALSEsub01030811150.dbvcn.oraclevcn.comdirectory part of global database name stored with CREATE DATABASE
20db_files11FALSEFALSE1024max allowable # db files
21db_lost_write_protect11FALSEFALSETYPICALenable lost write detection
22db_name11FALSEFALSEcdb23cdatabase name specified in CREATE DATABASE
23db_recovery_file_dest11FALSEFALSE+RECOdefault database recovery file location
24db_recovery_file_dest_size11FALSEFALSE273804165120255Gdatabase recovery files size limit
25db_unique_name11FALSEFALSEcdb23c_zgh_kixDatabase Unique Name
26diagnostic_dest11FALSEFALSE/u01/app/oraclediagnostic base directory
27dispatchers11FALSEFALSE(PROTOCOL=TCP) (SERVICE=cdb23cXDB)specifications of dispatchers
28enable_ddl_logging11FALSEFALSETRUEenable ddl logging
29enable_pluggable_database11FALSEFALSETRUEEnable Pluggable Database
30fast_start_mttr_target11FALSEFALSE300MTTR target in seconds
31filesystemio_options11FALSEFALSEsetallIO operations on filesystem files
32global_names11FALSEFALSETRUEenforce that database links have same name as remote database
33local_listener11FALSEFALSELISTENER_CDB23Clocal listener
34log_archive_format11FALSEFALSE%t_%s_%r.dbfarchival destination format
35log_buffer11FALSEFALSE134217728128Mredo circular buffer size
36nls_language11FALSEFALSEAMERICANNLS language name
37nls_territory11FALSEFALSEAMERICANLS territory name
38open_cursors11FALSEFALSE1000max # cursors per session
39os_authent_prefix11FALSEFALSEops$prefix for auto-logon accounts
40parallel_execution_message_size11FALSEFALSE16384message buffer size for parallel execution
41parallel_threads_per_cpu11FALSEFALSE2number of parallel execution threads per CPU
42pga_aggregate_limit11FALSEFALSE1637456281615616Mlimit of aggregate PGA memory for the instance or PDB
43pga_aggregate_target11FALSEFALSE81872814087808MTarget size for the aggregate PGA memory consumed by the instance
44processes11FALSEFALSE800user processes
45remote_login_passwordfile11FALSEFALSEEXCLUSIVEpassword file usage parameter
46session_cached_cursors11FALSEFALSE100Number of cursors to cache in a session.
47sga_target11FALSEFALSE0Target size of SGA
48spatial_vector_acceleration11FALSEFALSETRUEenable spatial vector acceleration
49sql92_security11FALSEFALSETRUErequire select privilege for searched update/delete
50tde_configuration11FALSEFALSEPer-PDB configuration for Transparent Data Encryption
51undo_retention11FALSEFALSE900undo retention in seconds
52undo_tablespace11FALSEFALSEUNDOTBS1use/switch undo tablespace
53use_large_pages11FALSEFALSEonlyUse large pages if available (TRUE/FALSE/ONLY)
54wallet_root11FALSEFALSE/opt/oracle/dcs/commonstore/wallets/cdb23c_zgh_kixwallet root instance initialization parameter

Go To Main Menu



Instance Parameters All parameter settings, including hidden parameters

RownumParameter
Name		OrdinalIs
Default		Is
Modified		ValueDisplay
Value		Description
1DBFIPS_1401TRUEFALSEFALSEEnable use of crypographic libraries in FIPS mode, public
2_datafile_write_errors_crash_instance1FALSEFALSEFALSEdatafile write errors crash instance
3_db_writer_coalesce_area_size1FALSEFALSE1677721616MSize of memory allocated to dbwriter for coalescing writes
4_disable_interface_checking1FALSEFALSETRUEdisable interface checking at startup
5_enable_NUMA_support1FALSEFALSEFALSEEnable NUMA support and optimizations
6_file_size_increase_increment1FALSEFALSE21432893442044MAmount of file size increase increment, in bytes
7_fix_control1FALSEFALSE18960760:onbug fix control parameter
8_gc_policy_time1FALSEFALSE20how often to make object policy decisions in minutes
9_gc_undo_affinity1FALSEFALSETRUEif TRUE, enable undo affinity
10active_instance_count0TRUEFALSEnumber of active instances in the cluster database
11adg_account_info_tracking1TRUEFALSELOCALADG user account info tracked in standby(LOCAL) or in Primary(GLOBAL)
12adg_redirect_dml1TRUEFALSEFALSEEnable DML Redirection from ADG
13allow_global_dblinks1TRUEFALSEFALSELDAP lookup for DBLINKS
14allow_group_access_to_sga1TRUEFALSEFALSEAllow read access for SGA to users of Oracle owner group
15allow_legacy_reco_protocol1TRUEFALSETRUEShould the database allow the legacy RECO protocol
16allow_rowid_column_type1TRUEFALSEFALSEAllow creation of rowid column
17allow_weak_crypto1TRUEFALSETRUEAllow weak crypto usage in DBMS_CRYPTO
18approx_for_aggregation1TRUEFALSEFALSEReplace exact aggregation with approximate aggregation
19approx_for_count_distinct1TRUEFALSEFALSEReplace count distinct with approx_count_distinct
20approx_for_percentile1TRUEFALSENONEReplace percentile_* with approx_percentile
21aq_tm_processes1TRUEFALSE1number of AQ Time Managers to start
22archive_lag_target1TRUEFALSE0Maximum number of seconds of redos the standby could lose
23asm_diskgroups0TRUEFALSEdisk groups to mount automatically
24asm_diskstring0TRUEFALSEdisk set locations for discovery
25asm_io_processes1TRUEFALSE20number of I/O processes per domain in the ASM IOSERVER instance
26asm_power_limit1TRUEFALSE1number of parallel relocations for disk rebalancing
27asm_preferred_read_failure_groups0TRUEFALSEpreferred read failure groups
28audit_file_dest1TRUEFALSE/u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/auditDirectory in which auditing files are to reside
29audit_sys_operations1TRUEFALSEFALSEenable sys auditing
30audit_syslog_level0TRUEFALSESyslog facility and level
31audit_trail1TRUEFALSENONEenable system auditing
32auto_start_pdb_services1TRUEFALSEFALSEAutomatically start all PDB services on PDB Open
33autotask_max_active_pdbs1TRUEFALSE2Setting for Autotask Maximum Maintenance PDBs
34awr_pdb_autoflush_enabled1TRUEFALSETRUEEnable/Disable AWR automatic PDB flushing
35awr_pdb_max_parallel_slaves1TRUEFALSE10maximum concurrent AWR PDB MMON slaves per instance
36awr_snapshot_time_offset1TRUEFALSE0Setting for AWR Snapshot Time Offset
37background_core_dump1TRUEFALSEpartialCore Size for Background Processes
38background_dump_dest1TRUEFALSE/u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/logDetached process dump directory
39backup_tape_io_slaves1TRUEFALSEFALSEBACKUP Tape I/O slaves
40bitmap_merge_area_size1TRUEFALSE1048576maximum memory allow for BITMAP MERGE
41blank_trimming1TRUEFALSEFALSEblank trimming semantics parameter
42blockchain_table_max_no_drop0TRUEFALSEmaximum idle retention minutes for blockchain tables
43blockchain_table_retention_threshold1TRUEFALSE16maximum retention without TABLE RETENTION privilege
44buffer_pool_keep1TRUEFALSENumber of database blocks/latches in keep buffer pool
45buffer_pool_recycle1TRUEFALSENumber of database blocks/latches in recycle buffer pool
46cdb_cluster1TRUEFALSEFALSEif TRUE startup in CDB Cluster mode
47cdb_cluster_name1TRUEFALSECDB Cluster name
48cell_offload_compaction1TRUEFALSEADAPTIVECell packet compaction strategy
49cell_offload_decryption1TRUEFALSETRUEenable SQL processing offload of encrypted data to cells
50cell_offload_parameters1TRUEFALSEAdditional cell offload parameters
51cell_offload_plan_display1TRUEFALSEAUTOCell offload explain plan display
52cell_offload_processing1TRUEFALSETRUEenable SQL processing offload to cells
53cell_offloadgroup_name0TRUEFALSESet the offload group name
54circuits0TRUEFALSEmax number of circuits
55client_prefetch_rows1TRUEFALSE0Client prefetch rows value
56client_result_cache_lag1TRUEFALSE3000client result cache maximum lag in milliseconds
57client_result_cache_size1TRUEFALSE0client result cache max size in bytes
58client_statistics_level1TRUEFALSETYPICALClient Statistics Level
59clonedb1TRUEFALSEFALSEclone database
60clonedb_dir0TRUEFALSECloneDB Directory
61cluster_database1TRUEFALSEFALSEif TRUE startup in cluster database mode
62cluster_interconnects1TRUEFALSEinterconnects for RAC use
63commit_logging0TRUEFALSEtransaction commit log write behaviour
64commit_point_strength1TRUEFALSE1Bias this node has toward not preparing in a two-phase commit
65commit_wait0TRUEFALSEtransaction commit log wait behaviour
66commit_write0TRUEFALSEtransaction commit log write behaviour
67common_user_prefix1TRUEFALSEEnforce restriction on a prefix of a Common User/Role/Profile name
68compatible1FALSEFALSE23.0.0.0Database will be completely compatible with this software version
69connection_brokers1TRUEFALSE((TYPE=DEDICATED)(BROKERS=1))connection brokers specification
70connection_brokers2TRUEFALSE((TYPE=EMON)(BROKERS=1))connection brokers specification
71container_data1TRUEFALSEALLwhich containers should data be returned from?
72containers_parallel_degree1TRUEFALSE65535Parallel degree for a CONTAINERS() query
73control_file_record_keep_time1TRUEFALSE7control file record keep time in days
74control_files1FALSEFALSE+RECO/CDB23C_ZGH_KIX/CONTROLFILE/current.256.1149786007control file names list
75control_management_pack_access1FALSEFALSEDIAGNOSTIC+TUNINGdeclares which manageability packs are enabled
76core_dump_dest1TRUEFALSE/u01/app/oracle/diag/rdbms/cdb23c_zgh_kix/cdb23c/cdumpCore dump directory
77cpu_count1FALSEFALSE8maximum number of CPUs
78cpu_min_count1TRUEFALSE8minimum number of CPUs required
79create_bitmap_area_size1TRUEFALSE8388608size of create bitmap buffer for bitmap index
80create_stored_outlines0TRUEFALSEcreate stored outlines for DML statements
81cursor_bind_capture_destination1TRUEFALSEmemory+diskAllowed destination for captured bind variables
82cursor_invalidation1TRUEFALSEIMMEDIATEdefault for DDL cursor invalidation semantics
83cursor_sharing1FALSEFALSEEXACTcursor sharing mode
84cursor_space_for_time1TRUEFALSEFALSEuse more memory in order to get faster execution
85data_guard_max_io_time1TRUEFALSE240maximum I/O time before process considered hung
86data_guard_max_longio_time1TRUEFALSE240maximum long I/O time before process considered hung
87data_guard_sync_latency1TRUEFALSE0Data Guard SYNC latency
88data_transfer_cache_size1TRUEFALSE0Size of data transfer cache
89db_16k_cache_size1TRUEFALSE0Size of cache for 16K buffers
90db_2k_cache_size1TRUEFALSE0Size of cache for 2K buffers
91db_32k_cache_size1TRUEFALSE0Size of cache for 32K buffers
92db_4k_cache_size1TRUEFALSE0Size of cache for 4K buffers
93db_8k_cache_size1TRUEFALSE0Size of cache for 8K buffers
94db_big_table_cache_percent_target1TRUEFALSE0Big table cache target size in percentage
95db_block_buffers1TRUEFALSE0Number of database blocks cached in memory
96db_block_checking1FALSEFALSEOFFheader checking and data and index block checking
97db_block_checksum1FALSEFALSETYPICALstore checksum in db blocks and check during reads
98db_block_size1FALSEFALSE8192Size of database block in bytes
99db_cache_advice1TRUEFALSEONBuffer cache sizing advisory
100db_cache_size1TRUEFALSE0Size of DEFAULT buffer pool for standard block size buffers
101db_create_file_dest1FALSEFALSE+DATAdefault database location
102db_create_online_log_dest_11FALSEFALSE+RECOonline log/controlfile destination #1
103db_create_online_log_dest_21TRUEFALSEonline log/controlfile destination #2
104db_create_online_log_dest_31TRUEFALSEonline log/controlfile destination #3
105db_create_online_log_dest_41TRUEFALSEonline log/controlfile destination #4
106db_create_online_log_dest_51TRUEFALSEonline log/controlfile destination #5
107db_domain1FALSEFALSEsub01030811150.dbvcn.oraclevcn.comdirectory part of global database name stored with CREATE DATABASE
108db_file_multiblock_read_count1TRUEFALSE128db block to be read each IO
109db_file_name_convert0TRUEFALSEdatafile name convert patterns and strings for standby/clone db
110db_files1FALSEFALSE1024max allowable # db files
111db_flash_cache_file1TRUEFALSEflash cache file for default block size
112db_flash_cache_size1TRUEFALSE0flash cache size for db_flash_cache_file
113db_flashback_log_dest1TRUEFALSESeparate creation directory for flashback database logs
114db_flashback_log_dest_size1TRUEFALSE0Size limit of separate creation directory for flashback database logs
115db_flashback_retention_target1TRUEFALSE1440Maximum Flashback Database log retention time in minutes.
116db_index_compression_inheritance1TRUEFALSENONEoptions for table or tablespace level compression inheritance
117db_keep_cache_size1TRUEFALSE0Size of KEEP buffer pool for standard block size buffers
118db_lost_write_protect1FALSEFALSETYPICALenable lost write detection
119db_name1FALSEFALSEcdb23cdatabase name specified in CREATE DATABASE
120db_performance_profile1TRUEFALSEDatabase performance category
121db_recovery_file_dest1FALSEFALSE+RECOdefault database recovery file location
122db_recovery_file_dest_size1FALSEFALSE273804165120255Gdatabase recovery files size limit
123db_recycle_cache_size1TRUEFALSE0Size of RECYCLE buffer pool for standard block size buffers
124db_securefile1TRUEFALSEPREFERREDpermit securefile storage during lob creation
125db_ultra_safe1TRUEFALSEOFFSets defaults for other parameters that control protection levels
126db_unique_name1FALSEFALSEcdb23c_zgh_kixDatabase Unique Name
127db_unrecoverable_scn_tracking1TRUEFALSETRUETrack nologging SCN in controlfile
128db_writer_processes1TRUEFALSE1number of background database writer processes to start
129dbnest_enable1TRUEFALSENONEdatabase Nest enable
130dbnest_pdb_fs_conf0TRUEFALSEPDB Filesystem configuration
131dbwr_io_slaves1TRUEFALSE0DBWR I/O slaves
132ddl_lock_timeout1TRUEFALSE0timeout to restrict the time that ddls wait for dml lock
133default_credential1TRUEFALSEdefault credential session parameter
134default_sharing1TRUEFALSEMETADATADefault sharing clause
135deferred_segment_creation1TRUEFALSETRUEdefer segment creation to first insert
136dg_broker_config_file11TRUEFALSE/u01/app/oracle/product/23.0.0.0/dbhome_1/dbs/dr1cdb23c_zgh_kix.datdata guard broker configuration file #1
137dg_broker_config_file21TRUEFALSE/u01/app/oracle/product/23.0.0.0/dbhome_1/dbs/dr2cdb23c_zgh_kix.datdata guard broker configuration file #2
138dg_broker_start1TRUEFALSEFALSEstart Data Guard broker (DMON process)
139diagnostic_dest1FALSEFALSE/u01/app/oraclediagnostic base directory
140diagnostics_control1TRUEFALSEIGNOREcontrols response when 'enabling diagnostics' privilege is absent
141disable_pdb_feature1TRUEFALSE0Disable features
142disk_asynch_io1TRUEFALSETRUEUse asynch I/O for random access devices
143dispatchers1FALSEFALSE(PROTOCOL=TCP) (SERVICE=cdb23cXDB)specifications of dispatchers
144distributed_lock_timeout1TRUEFALSE60number of seconds a distributed transaction waits for a lock
145dml_locks1TRUEFALSE5384dml locks - one for each table modified in a transaction
146dnfs_batch_size1TRUEFALSE4096Max number of dNFS asynch I/O requests queued per session
147drcp_connection_limit1TRUEFALSE0DRCP connection limit
148drcp_dedicated_opt1TRUEFALSENOTurn on/off dedicated optimization for DRCP
149dst_upgrade_insert_conv1TRUEFALSETRUEEnables/Disables internal conversions during DST upgrade
150enable_automatic_maintenance_pdb1TRUEFALSETRUEEnable/Disable Automated Maintenance for Non-Root PDB
151enable_ddl_logging1FALSEFALSETRUEenable ddl logging
152enable_dnfs_dispatcher1TRUEFALSEFALSEEnable DNFS Dispatcher
153enable_goldengate_replication1TRUEFALSEFALSEgoldengate replication enabled
154enable_imc_with_mira1TRUEFALSEFALSEenable IMC with multi instance redo apply
155enable_per_pdb_drcp1TRUEFALSEFALSETurn on/off per PDB DRCP
156enable_pluggable_database1FALSEFALSETRUEEnable Pluggable Database
157enabled_PDBs_on_standby1TRUEFALSE*List of Enabled PDB patterns
158encrypt_new_tablespaces1TRUEFALSEALWAYSwhether to encrypt newly created tablespaces
159error_message_details1TRUEFALSEONprint additional explanatory error details
160event1TRUEFALSEdebug event control - default null string
161external_keystore_credential_location1TRUEFALSEexternal keystore credential location
162fal_client1TRUEFALSEFAL client
163fal_server1TRUEFALSEFAL server list
164fast_start_io_target1TRUEFALSE0Upper bound on recovery reads
165fast_start_mttr_target1FALSEFALSE300MTTR target in seconds
166fast_start_parallel_rollback1TRUEFALSELOWmax number of parallel recovery slaves that may be used
167file_mapping1TRUEFALSEFALSEenable file mapping
168fileio_network_adapters0TRUEFALSENetwork Adapters for File I/O
169filesystemio_options1FALSEFALSEsetallIO operations on filesystem files
170fixed_date1TRUEFALSEfixed SYSDATE value
171forward_listener0TRUEFALSEforward listener
172gcs_server_processes1TRUEFALSE0number of background gcs server processes to start
173global_names1FALSEFALSETRUEenforce that database links have same name as remote database
174global_txn_processes1TRUEFALSE1number of background global transaction processes to start
175group_by_position_enabled1TRUEFALSEFALSEenable/disable group by position
176hash_area_size1TRUEFALSE131072size of in-memory hash work area
177heartbeat_batch_size1TRUEFALSE5Number of heartbeats to be sent in a batch
178heat_map1TRUEFALSEOFFILM Heatmap Tracking
179hi_shared_memory_address1TRUEFALSE0SGA starting address (high order 32-bits on 64-bit platforms)
180hs_autoregister1TRUEFALSETRUEenable automatic server DD updates in HS agent self-registration
181http_proxy0TRUEFALSEhttp_proxy
182hybrid_read_only1TRUEFALSEFALSEHybrid read only mode allows CDB common user to patch the PDB
183identity_provider_config1TRUEFALSEIdentity Provider Configuration
184identity_provider_type1TRUEFALSENONEIdentity Provider Type
185ifile0TRUEFALSEinclude file in init.ora
186ignore_session_set_param_errors0TRUEFALSEIgnore errors during alter session param set
187inmemory_adg_enabled1TRUEFALSETRUEEnable IMC support on ADG
188inmemory_automatic_level1TRUEFALSEOFFEnable Automatic In-Memory management
189inmemory_clause_default1TRUEFALSEDefault in-memory clause for new tables
190inmemory_deep_vectorization1TRUEFALSETRUEIn-Memory Deep Vectorization Enabled
191inmemory_expressions_usage1TRUEFALSEENABLEControls which In-Memory Expressions are populated in-memory
192inmemory_force1TRUEFALSEDEFAULTForce tables to be in-memory or not
193inmemory_graph_algorithm_execution1TRUEFALSEDEFAULTControls the fall-back action of graph algorithm execution if in-memory execution is not possible
194inmemory_max_populate_servers1TRUEFALSE0maximum inmemory populate servers
195inmemory_optimized_arithmetic1TRUEFALSEDISABLEControls whether or not DSBs are stored in-memory
196inmemory_prefer_xmem_memcompress1TRUEFALSEPrefer to store tables with given memcompress levels in xmem
197inmemory_prefer_xmem_priority1TRUEFALSEPrefer to store tables with given priority levels in xmem
198inmemory_query1TRUEFALSEENABLESpecifies whether in-memory queries are allowed
199inmemory_size1TRUEFALSE0size in bytes of in-memory area
200inmemory_trickle_repopulate_servers_percent1TRUEFALSE1inmemory trickle repopulate servers percent
201inmemory_virtual_columns1TRUEFALSEMANUALControls which user-defined virtual columns are stored in-memory
202inmemory_xmem_size1TRUEFALSE0size in bytes of in-memory xmem area
203instance_abort_delay_time1TRUEFALSE0time to delay an internal initiated abort (in seconds)
204instance_groups0TRUEFALSElist of instance group names
205instance_mode1TRUEFALSEREAD-WRITEindicates whether the instance read-only or read-write or read-mostly
206instance_name1TRUEFALSEcdb23cinstance name supported by the instance
207instance_number1TRUEFALSE0instance number
208instance_type1TRUEFALSERDBMStype of instance to be executed
209instant_restore1TRUEFALSEFALSEinstant repopulation of datafiles
210iorm_limit_policy1TRUEFALSERM_PLANPolicy used to compute Exadata IORM limit
211ipddb_enable1TRUEFALSEFALSEEnable IPD/DB data collection
212java_jit_enabled1TRUEFALSETRUEJava VM JIT enabled
213java_max_sessionspace_size1TRUEFALSE0max allowed size in bytes of a Java sessionspace
214java_pool_size1TRUEFALSE0size in bytes of java pool
215java_restrict1TRUEFALSEnoneRestrict Java VM Access
216java_soft_sessionspace_limit1TRUEFALSE0warning limit on size in bytes of a Java sessionspace
217job_queue_processes1TRUEFALSE160maximum number of job queue slave processes
218json_behavior_flags1TRUEFALSEcontrol json behaviors
219json_expression_check1TRUEFALSEoffenable/disable JSON query statement check
220kafka_config_file0TRUEFALSEKSR pub/sub external message bus(KGMPS) CONFIGuration file
221large_pool_size1TRUEFALSE0size in bytes of large pool
222ldap_directory_access1TRUEFALSENONERDBMS's LDAP access option
223ldap_directory_sysauth1TRUEFALSEnoOID usage parameter
224license_max_sessions1TRUEFALSE0maximum number of non-system user sessions allowed
225license_max_users1TRUEFALSE0maximum number of named users that can be created in the database
226license_sessions_warning1TRUEFALSE0warning level for number of non-system user sessions
227listener_networks1TRUEFALSE(( NAME=net1)(LOCAL_LISTENER=(ADDRESS=(PROTOCOL=TCP)(HOST=hong23c-vip.sub01030811150.dbvcn.oraclevcn.com)(PORT=1521))))listener registration networks
228load_without_compile1TRUEFALSENONELoad PL/SQL or Database objects without compilation
229lob_signature_enable1TRUEFALSEFALSEenable lob signature
230local_listener1FALSEFALSELISTENER_CDB23Clocal listener
231lock_name_space0TRUEFALSElock name space used for generating lock names for standby/clone database
232lock_sga1TRUEFALSEFALSELock entire SGA in physical memory
233log_archive_config1TRUEFALSElog archive config
234log_archive_dest1TRUEFALSEarchival destination text string
235log_archive_dest_11TRUEFALSEarchival destination #1 text string
236log_archive_dest_101TRUEFALSEarchival destination #10 text string
237log_archive_dest_111TRUEFALSEarchival destination #11 text string
238log_archive_dest_121TRUEFALSEarchival destination #12 text string
239log_archive_dest_131TRUEFALSEarchival destination #13 text string
240log_archive_dest_141TRUEFALSEarchival destination #14 text string
241log_archive_dest_151TRUEFALSEarchival destination #15 text string
242log_archive_dest_161TRUEFALSEarchival destination #16 text string
243log_archive_dest_171TRUEFALSEarchival destination #17 text string
244log_archive_dest_181TRUEFALSEarchival destination #18 text string
245log_archive_dest_191TRUEFALSEarchival destination #19 text string
246log_archive_dest_21TRUEFALSEarchival destination #2 text string
247log_archive_dest_201TRUEFALSEarchival destination #20 text string
248log_archive_dest_211TRUEFALSEarchival destination #21 text string
249log_archive_dest_221TRUEFALSEarchival destination #22 text string
250log_archive_dest_231TRUEFALSEarchival destination #23 text string
251log_archive_dest_241TRUEFALSEarchival destination #24 text string
252log_archive_dest_251TRUEFALSEarchival destination #25 text string
253log_archive_dest_261TRUEFALSEarchival destination #26 text string
254log_archive_dest_271TRUEFALSEarchival destination #27 text string
255log_archive_dest_281TRUEFALSEarchival destination #28 text string
256log_archive_dest_291TRUEFALSEarchival destination #29 text string
257log_archive_dest_31TRUEFALSEarchival destination #3 text string
258log_archive_dest_301TRUEFALSEarchival destination #30 text string
259log_archive_dest_311TRUEFALSEarchival destination #31 text string
260log_archive_dest_41TRUEFALSEarchival destination #4 text string
261log_archive_dest_51TRUEFALSEarchival destination #5 text string
262log_archive_dest_61TRUEFALSEarchival destination #6 text string
263log_archive_dest_71TRUEFALSEarchival destination #7 text string
264log_archive_dest_81TRUEFALSEarchival destination #8 text string
265log_archive_dest_91TRUEFALSEarchival destination #9 text string
266log_archive_dest_state_11TRUEFALSEenablearchival destination #1 state text string
267log_archive_dest_state_101TRUEFALSEenablearchival destination #10 state text string
268log_archive_dest_state_111TRUEFALSEenablearchival destination #11 state text string
269log_archive_dest_state_121TRUEFALSEenablearchival destination #12 state text string
270log_archive_dest_state_131TRUEFALSEenablearchival destination #13 state text string
271log_archive_dest_state_141TRUEFALSEenablearchival destination #14 state text string
272log_archive_dest_state_151TRUEFALSEenablearchival destination #15 state text string
273log_archive_dest_state_161TRUEFALSEenablearchival destination #16 state text string
274log_archive_dest_state_171TRUEFALSEenablearchival destination #17 state text string
275log_archive_dest_state_181TRUEFALSEenablearchival destination #18 state text string
276log_archive_dest_state_191TRUEFALSEenablearchival destination #19 state text string
277log_archive_dest_state_21TRUEFALSEenablearchival destination #2 state text string
278log_archive_dest_state_201TRUEFALSEenablearchival destination #20 state text string
279log_archive_dest_state_211TRUEFALSEenablearchival destination #21 state text string
280log_archive_dest_state_221TRUEFALSEenablearchival destination #22 state text string
281log_archive_dest_state_231TRUEFALSEenablearchival destination #23 state text string
282log_archive_dest_state_241TRUEFALSEenablearchival destination #24 state text string
283log_archive_dest_state_251TRUEFALSEenablearchival destination #25 state text string
284log_archive_dest_state_261TRUEFALSEenablearchival destination #26 state text string
285log_archive_dest_state_271TRUEFALSEenablearchival destination #27 state text string
286log_archive_dest_state_281TRUEFALSEenablearchival destination #28 state text string
287log_archive_dest_state_291TRUEFALSEenablearchival destination #29 state text string
288log_archive_dest_state_31TRUEFALSEenablearchival destination #3 state text string
289log_archive_dest_state_301TRUEFALSEenablearchival destination #30 state text string
290log_archive_dest_state_311TRUEFALSEenablearchival destination #31 state text string
291log_archive_dest_state_41TRUEFALSEenablearchival destination #4 state text string
292log_archive_dest_state_51TRUEFALSEenablearchival destination #5 state text string
293log_archive_dest_state_61TRUEFALSEenablearchival destination #6 state text string
294log_archive_dest_state_71TRUEFALSEenablearchival destination #7 state text string
295log_archive_dest_state_81TRUEFALSEenablearchival destination #8 state text string
296log_archive_dest_state_91TRUEFALSEenablearchival destination #9 state text string
297log_archive_duplex_dest1TRUEFALSEduplex archival destination text string
298log_archive_format1FALSEFALSE%t_%s_%r.dbfarchival destination format
299log_archive_max_processes1TRUEFALSE4maximum number of active ARCH processes
300log_archive_min_succeed_dest1TRUEFALSE1minimum number of archive destinations that must succeed
301log_archive_trace1TRUEFALSE0Establish archive operation tracing level
302log_buffer1FALSEFALSE134217728128Mredo circular buffer size
303log_checkpoint_interval1TRUEFALSE0# redo blocks checkpoint threshold
304log_checkpoint_timeout1TRUEFALSE1800Maximum time interval between checkpoints in seconds
305log_checkpoints_to_alert1TRUEFALSEFALSElog checkpoint begin/end to alert file
306log_file_name_convert0TRUEFALSElogfile name convert patterns and strings for standby/clone db
307long_module_action1TRUEFALSETRUEUse longer module and action
308main_workload_type1TRUEFALSEOLTPMain workload type
309mandatory_user_profile1TRUEFALSEEnforce Mandatory Password Profile for multitenant database
310max_auth_servers1TRUEFALSE25Maximum size of auth pool
311max_columns1TRUEFALSESTANDARDmaximum number of columns allowed in table or view
312max_datapump_jobs_per_pdb1TRUEFALSEAUTOmaximum number of concurrent Data Pump Jobs per PDB
313max_datapump_parallel_per_job1TRUEFALSEAUTOmaximum number of parallel processes per Data Pump Job
314max_dispatchers0TRUEFALSEmax number of dispatchers
315max_dump_file_size1TRUEFALSE32MMaximum size (in bytes) of dump file
316max_idle_blocker_time1TRUEFALSE0maximum idle time for a blocking session in minutes
317max_idle_time1TRUEFALSE0maximum session idle time in minutes
318max_iops1TRUEFALSE0MAX IO per second
319max_mbps1TRUEFALSE0MAX MB per second
320max_pdbs1TRUEFALSE4098max number of pdbs allowed in CDB or Application ROOT
321max_saga_duration1TRUEFALSE86400default value for max saga duration
322max_shared_servers0TRUEFALSEmax number of shared servers
323max_string_size1TRUEFALSESTANDARDcontrols maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL
324memoptimize_pool_size1TRUEFALSE0Size of cache for imoltp buffers
325memoptimize_write_area_size1TRUEFALSE0changes memoptimize write area size
326memoptimize_writes1TRUEFALSEHINTwrite data to IGA without memoptimize_write hint
327memory_max_size1TRUEFALSE0Maximum memory size
328memory_max_target1TRUEFALSE0Max size for Memory Target
329memory_size1TRUEFALSE0Target memory size
330memory_target1TRUEFALSE0Target size of Oracle SGA and PGA memory
331min_auth_servers1TRUEFALSE1Minimum size of auth pool
332mle_prog_languages1TRUEFALSEallEnable Multilingual Engine
333mle_regexp_accelerator1TRUEFALSESQLAccelerate regular expression evaluation using MLE
334multishard_query_data_consistency1TRUEFALSEstrongconsistency setting for multishard queries
335multishard_query_partial_results1TRUEFALSEnot allowedenable partial results for multishard queries
336native_blockchain_features1TRUEFALSENative block chain enable/disable
337nls_calendar1TRUEFALSENLS calendar system name
338nls_comp1TRUEFALSEBINARYNLS comparison
339nls_currency1TRUEFALSENLS local currency symbol
340nls_date_format1TRUEFALSENLS Oracle date format
341nls_date_language1TRUEFALSENLS date language name
342nls_dual_currency1TRUEFALSEDual currency symbol
343nls_iso_currency1TRUEFALSENLS ISO currency territory name
344nls_language1FALSEFALSEAMERICANNLS language name
345nls_length_semantics1TRUEFALSEBYTEcreate columns using byte or char semantics by default
346nls_nchar_conv_excp1TRUEFALSEFALSENLS raise an exception instead of allowing implicit conversion
347nls_numeric_characters1TRUEFALSENLS numeric characters
348nls_sort1TRUEFALSENLS linguistic definition name
349nls_territory1FALSEFALSEAMERICANLS territory name
350nls_time_format1TRUEFALSEtime format
351nls_time_tz_format1TRUEFALSEtime with timezone format
352nls_timestamp_format1TRUEFALSEtime stamp format
353nls_timestamp_tz_format1TRUEFALSEtimestamp with timezone format
354noncdb_compatible1TRUEFALSEFALSENon-CDB Compatible
355object_cache_max_size_percent1TRUEFALSE10percentage of maximum size over optimal of the user session's object cache
356object_cache_optimal_size1TRUEFALSE51200000optimal size of the user session's object cache in bytes
357ofs_threads1TRUEFALSE4Number of OFS threads
358olap_page_pool_size1TRUEFALSE0size of the olap page pool in bytes
359one_step_plugin_for_pdb_with_tde1TRUEFALSEFALSEFacilitate one-step plugin for PDB with TDE encrypted data
360open_cursors1FALSEFALSE1000max # cursors per session
361open_links1TRUEFALSE4max # open links per session
362open_links_per_instance1TRUEFALSE4max # open links per instance
363optimizer_adaptive_plans1TRUEFALSETRUEcontrols all types of adaptive plans
364optimizer_adaptive_reporting_only1TRUEFALSEFALSEuse reporting-only mode for adaptive optimizations
365optimizer_adaptive_statistics1TRUEFALSEFALSEcontrols all types of adaptive statistics
366optimizer_capture_sql_plan_baselines1TRUEFALSEFALSEautomatic capture of SQL plan baselines for repeatable statements
367optimizer_capture_sql_quarantine1TRUEFALSEFALSEenable automatic creation/update of sql quarantine configuration
368optimizer_cross_shard_resiliency1TRUEFALSEFALSEenables resilient execution of cross shard queries
369optimizer_dynamic_sampling1TRUEFALSE2optimizer dynamic sampling
370optimizer_features_enable1TRUEFALSE23.1.0optimizer plan compatibility parameter
371optimizer_ignore_hints1TRUEFALSEFALSEenables the embedded hints to be ignored
372optimizer_ignore_parallel_hints1TRUEFALSEFALSEenables embedded parallel hints to be ignored
373optimizer_index_caching1TRUEFALSE0optimizer percent index caching
374optimizer_index_cost_adj1TRUEFALSE100optimizer index cost adjustment
375optimizer_inmemory_aware1TRUEFALSETRUEoptimizer in-memory columnar awareness
376optimizer_mode1TRUEFALSEALL_ROWSoptimizer mode
377optimizer_real_time_statistics1TRUEFALSEFALSEoptimizer real time statistics on conventional DML
378optimizer_secure_view_merging1TRUEFALSETRUEoptimizer secure view merging and predicate pushdown/movearound
379optimizer_session_type1TRUEFALSENORMALControls Auto Index
380optimizer_use_invisible_indexes1TRUEFALSEFALSEUsage of invisible indexes (TRUE/FALSE)
381optimizer_use_pending_statistics1TRUEFALSEFALSEControl whether to use optimizer pending statistics
382optimizer_use_sql_plan_baselines1TRUEFALSETRUEuse of SQL plan baselines for captured sql statements
383optimizer_use_sql_quarantine1TRUEFALSETRUEenable use of sql quarantine
384os_authent_prefix1FALSEFALSEops$prefix for auto-logon accounts
385os_roles1TRUEFALSEFALSEretrieve roles from the operating system
386outbound_dblink_protocols1TRUEFALSEALLOutbound DBLINK Protocols allowed
387parallel_adaptive_multi_user1TRUEFALSEFALSEenable adaptive setting of degree for multiple user streams
388parallel_degree_limit1TRUEFALSECPUlimit placed on degree of parallelism
389parallel_degree_policy1TRUEFALSEMANUALpolicy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO/ADAPTIVE)
390parallel_execution_message_size1FALSEFALSE16384message buffer size for parallel execution
391parallel_force_local1TRUEFALSEFALSEforce single instance execution
392parallel_instance_group1TRUEFALSEinstance group to use for all parallel operations
393parallel_max_servers1TRUEFALSE320maximum parallel query servers per instance
394parallel_min_degree1TRUEFALSE1controls the minimum DOP computed by Auto DOP
395parallel_min_percent1TRUEFALSE0minimum percent of threads required for parallel query
396parallel_min_servers1TRUEFALSE32minimum parallel query servers per instance
397parallel_min_time_threshold1TRUEFALSEAUTOthreshold above which a plan is a candidate for parallelization (in seconds)
398parallel_servers_target1TRUEFALSE128instance target in terms of number of parallel servers
399parallel_threads_per_cpu1FALSEFALSE2number of parallel execution threads per CPU
400paranoid_concurrency_mode1TRUEFALSEFALSEEnable strictly durable query data gets
401pdb_file_name_convert0TRUEFALSEPDB file name convert patterns and strings for create cdb/pdb
402pdb_lockdown0TRUEFALSEpluggable database lockdown profile
403pdb_os_credential0TRUEFALSEpluggable database OS credential to bind
404pdb_template0TRUEFALSEPDB template
405pdc_file_size1TRUEFALSE83927048196Ksize (in bytes) of the pmem direct commit file
406permit_92_wrap_format1TRUEFALSEFALSEallow 9.2 or older wrap format in PL/SQL
407pga_aggregate_limit1FALSEFALSE1637456281615616Mlimit of aggregate PGA memory for the instance or PDB
408pga_aggregate_target1FALSEFALSE81872814087808MTarget size for the aggregate PGA memory consumed by the instance
409pkcs11_library_location1TRUEFALSEPKCS#11 library location for Transparent Data Encryption
410plscope_settings1TRUEFALSEIDENTIFIERS:NONEplscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier and SQL statement data
411plsql_ccflags1TRUEFALSEPL/SQL ccflags
412plsql_code_type1TRUEFALSEINTERPRETEDPL/SQL code-type
413plsql_debug1TRUEFALSEFALSEPL/SQL debug
414plsql_implicit_conversion_bool1TRUEFALSEFALSEPL/SQL: Implicit conversion for boolean
415plsql_optimize_level1TRUEFALSE2PL/SQL optimize level
416plsql_v2_compatibility1TRUEFALSEFALSEPL/SQL version 2.x compatibility flag
417plsql_warnings1TRUEFALSEDISABLE:ALLPL/SQL compiler warnings settings
418pmem_filestore0TRUEFALSEPersistent Memory Filestore list
419pre_page_sga1TRUEFALSETRUEpre-page sga for process
420private_temp_table_prefix1TRUEFALSEORA$PTT_Private temporary table prefix
421processes1FALSEFALSE800user processes
422processor_group_name0TRUEFALSEName of the processor group that this instance should run in.
423query_rewrite_enabled1TRUEFALSETRUEallow rewrite of queries using materialized views if enabled
424query_rewrite_integrity1TRUEFALSEenforcedperform rewrite using materialized views with desired integrity
425rdbms_server_dn1TRUEFALSERDBMS's Distinguished Name
426read_only1TRUEFALSEFALSERestrict WRITE operations in user session
427read_only_open_delayed1TRUEFALSEFALSEif TRUE delay opening of read only files until first access
428recovery_parallelism1TRUEFALSE0number of server processes to use for parallel recovery
429recyclebin1TRUEFALSEonrecyclebin processing
430redo_transport_user1TRUEFALSEData Guard transport user when using password file
431remote_dependencies_mode1TRUEFALSETIMESTAMPremote-procedure-call dependencies mode parameter
432remote_listener0TRUEFALSEremote listener
433remote_login_passwordfile1FALSEFALSEEXCLUSIVEpassword file usage parameter
434remote_os_roles1TRUEFALSEFALSEallow non-secure remote clients to use os roles
435remote_recovery_file_dest1TRUEFALSEdefault remote database recovery file location for refresh/relocate
436replication_dependency_tracking1TRUEFALSETRUEtracking dependency for Replication parallel propagation
437resource_limit1TRUEFALSETRUEmaster switch for resource limit
438resource_manage_goldengate1TRUEFALSEFALSEgoldengate resource manager enabled
439resource_manager_cpu_allocation1TRUEFALSE0Resource Manager CPU allocation
440resource_manager_cpu_scope1TRUEFALSEINSTANCE_ONLYscope of CPU resource management
441resource_manager_plan1TRUEFALSESCHEDULER:DEFAULT_MAINTENANCE_PLANresource mgr top plan
442result_cache_auto_blocklist1TRUEFALSEONwhether to run the auto blocklisting algorithm
443result_cache_execution_threshold1TRUEFALSE2minimum executions before a PL/SQL function is cached
444result_cache_integrity1TRUEFALSETRUSTEDresult cache deterministic PLSQL functions
445result_cache_max_result1TRUEFALSE5maximum result size as percent of cache size
446result_cache_max_size1TRUEFALSE164626432157Mmaximum amount of memory to be used by the cache
447result_cache_max_temp_result1TRUEFALSE5maximum temp per result as percent of total temp for result cache
448result_cache_max_temp_size1TRUEFALSE1637456280maximum amount of temp space to be used
449result_cache_mode1TRUEFALSEMANUALresult cache operator usage mode
450result_cache_remote_expiration1TRUEFALSE0maximum life time (min) for any result using a remote object
451resumable_timeout1TRUEFALSE0set resumable_timeout
452rollback_segments0TRUEFALSEundo segment list
453run_addm_for_awr_report1TRUEFALSENONEtypes of AWR snapshots for which ADDM can be run inside AWR report
454saga_hist_retention1TRUEFALSE43200default value for retention of completed sagas
455scheduler_follow_pdbtz1TRUEFALSEFALSEMake scheduler objects follow PDB TZ
456sec_max_failed_login_attempts1TRUEFALSE3maximum number of failed login attempts on a connection
457sec_protocol_error_further_action1TRUEFALSE(DROP,3)TTC protocol error continue action
458sec_protocol_error_trace_action1TRUEFALSETRACETTC protocol error action
459sec_return_server_release_banner1TRUEFALSEFALSEwhether the server retruns the complete version information
460serial_reuse1TRUEFALSEdisablereuse the frame segments
461service_names1TRUEFALSEcdb23c_zgh_kix.sub01030811150.dbvcn.oraclevcn.comservice names supported by the instance
462session_cached_cursors1FALSEFALSE100Number of cursors to cache in a session.
463session_exit_on_package_state_error1TRUEFALSEFALSERequest client to exit when PL/SQL package state is discarded
464session_max_open_files1TRUEFALSE10maximum number of open files allowed per session
465sessions1TRUEFALSE1224user and system sessions
466sga_max_size1TRUEFALSE3274912563231232Mmax total SGA size
467sga_min_size1TRUEFALSE0Minimum, guaranteed size of PDB's SGA
468sga_target1FALSEFALSE0Target size of SGA
469shadow_core_dump1TRUEFALSEpartialCore Size for Shadow Processes
470shard_enable_raft_follower_read1TRUEFALSETRUEenable read from follower replications units in a shard
471shard_queries_restricted_by_key1TRUEFALSEFALSEadd shard key predicates to the query
472shared_memory_address1TRUEFALSE0SGA starting address (low order 32-bits on 64-bit platforms)
473shared_pool_reserved_size1TRUEFALSE248973885size in bytes of reserved area of shared pool
474shared_pool_size1TRUEFALSE0size in bytes of shared pool
475shared_server_sessions0TRUEFALSEmax number of shared server sessions
476shared_servers1TRUEFALSE1number of shared servers to start up
477shrd_dupl_table_refresh_rate1TRUEFALSE60duplicated table refresh rate (in seconds)
478skip_unusable_indexes1TRUEFALSETRUEskip unusable indexes if set to TRUE
479smtp_out_server0TRUEFALSEutl_smtp server and port configuration parameter
480soda_behavior_flags1TRUEFALSEcontrol soda behaviors
481sort_area_retained_size1TRUEFALSE0size of in-memory sort work area retained between fetch calls
482sort_area_size1TRUEFALSE65536size of in-memory sort work area
483spatial_vector_acceleration1FALSEFALSETRUEenable spatial vector acceleration
484spfile1TRUEFALSE+DATA/CDB23C_ZGH_KIX/PARAMETERFILE/spfile.262.1149786293server parameter file
485sql92_security1FALSEFALSETRUErequire select privilege for searched update/delete
486sql_error_mitigation1TRUEFALSEoffenables automatic error mitigation
487sql_history_enabled1TRUEFALSEFALSESQL Query History is enabled when TRUE
488sql_trace1TRUEFALSEFALSEenable SQL trace
489sql_transpiler1TRUEFALSEOFFEnable SQL transpiler
490sqltune_category1TRUEFALSEDEFAULTCategory qualifier for applying hintsets
491ssl_wallet0TRUEFALSEssl_wallet
492standby_db_preserve_states1TRUEFALSENONEPreserve state cross standby role transition
493standby_file_management1TRUEFALSEMANUALif auto then files are created/dropped automatically on standby
494standby_pdb_source_file_dblink0TRUEFALSEdatabase link to standby source files
495standby_pdb_source_file_directory0TRUEFALSEstandby source file directory location
496star_transformation_enabled1TRUEFALSEFALSEenable the use of star transformation
497statement_redirect_service1TRUEFALSEstatement redirect service
498statistics_level1TRUEFALSETYPICALstatistics level
499streams_pool_size1TRUEFALSE0size in bytes of the streams pool
500sysdate_at_dbtimezone1TRUEFALSEFALSEuse DB timezone while computing sysdate and systimestamp value
501tablespace_encryption1TRUEFALSEAUTO_ENABLETablepsace encryption in hybrid ADG
502tablespace_encryption_default_algorithm1TRUEFALSEAES256default tablespace encryption block cipher mode
503tape_asynch_io1TRUEFALSETRUEUse asynch I/O requests for tape devices
504target_pdbs1TRUEFALSE61Parameter is a hint to adjust certain attributes of the CDB
505tde_configuration1FALSEFALSEPer-PDB configuration for Transparent Data Encryption
506tde_key_cache1TRUEFALSEFALSEEnable caching of TDE intermediate key
507temp_undo_enabled1TRUEFALSEFALSEis temporary undo enabled
508thread1TRUEFALSE0Redo thread to mount
509threaded_execution1TRUEFALSEFALSEThreaded Execution Mode
510time_at_dbtimezone1TRUEFALSEoffuse DB timezone when computing current time
511timed_os_statistics1TRUEFALSE0internal os statistic gathering interval in seconds
512timed_statistics1TRUEFALSETRUEmaintain internal timing statistics
513timezone_version_upgrade_integrity1TRUEFALSEenforcedperform DST upgrade leveraging constraints with desired integrity
514timezone_version_upgrade_online1TRUEFALSEFALSEenable/disable time zone version upgrade online
515trace_enabled1TRUEFALSETRUEenable in memory tracing
516tracefile_content_classification1TRUEFALSEDEFAULTenable output of trace record security label prefix
517tracefile_identifier0TRUEFALSEtrace file custom identifier
518transactions1TRUEFALSE1346max. number of concurrent active transactions
519transactions_per_rollback_segment1TRUEFALSE5number of active transactions per rollback segment
520true_cache1TRUEFALSEFALSEEnable True Cache
521txn_auto_rollback_high_priority_wait_target1TRUEFALSE2147483647Auto abort wait for high pri txns
522txn_auto_rollback_medium_priority_wait_target1TRUEFALSE2147483647Auto abort wait for medium pri txns
523txn_auto_rollback_mode1TRUEFALSEROLLBACKModes for Auto Transaction Rollback feature
524txn_priority1TRUEFALSEHIGHPriority of a transaction in a session
525undo_management1TRUEFALSEAUTOinstance runs in SMU mode if TRUE, else in RBU mode
526undo_retention1FALSEFALSE900undo retention in seconds
527undo_tablespace1FALSEFALSEUNDOTBS1use/switch undo tablespace
528unified_audit_common_systemlog0TRUEFALSESyslog facility and level for only common unified audit records
529unified_audit_systemlog1TRUEFALSESyslog facility and level for Unified Audit
530uniform_log_timestamp_format1TRUEFALSETRUEuse uniform timestamp formats vs pre-12.2 formats
531use_dedicated_broker1TRUEFALSENONEUse dedicated connection broker
532use_large_pages1FALSEFALSEonlyUse large pages if available (TRUE/FALSE/ONLY)
533user_dump_dest1TRUEFALSE/u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/logUser process dump directory
534wallet_root1FALSEFALSE/opt/oracle/dcs/commonstore/wallets/cdb23c_zgh_kixwallet root instance initialization parameter
535workarea_size_policy1TRUEFALSEAUTOpolicy used to size SQL working areas (MANUAL/AUTO)
536xml_client_side_decoding1TRUEFALSEtrueenable/disable xml client-side decoding
537xml_db_events1TRUEFALSEenableare XML DB events enabled
538xml_handling_of_invalid_chars1TRUEFALSEraise_errorHandle invalid chars during xmlelement
539xml_params1TRUEFALSEParameters to alter xml behavior

Go To Main Menu



ASH by Plan Active Session History by execution plan

No data was found for this section



Go To Main Menu



ASH by Plan Line Active Session History by plan line

No data was found for this section



Go To Main Menu



ASH by Plan (in Memory) Active Session History Information related to the query

No data was found for this section



Go To Main Menu



ASH by Plan Line (in Memory) Active Session History by execution plan line

No data was found for this section



Go To Main Menu



Peeked vs Monitored Bind Values - In Memory In memory information about the Peeked Binds

No data was found for this section



Go To Main Menu



Peeked vs Captured Bind Values - In Memory In memory information about Captured Binds

No data was found for this section



Go To Main Menu



Peeked vs Captured Bind Values - AWR AWR information about Peeked and Captured Binds

No data was found for this section



Go To Main Menu