Oracle Database 18c

The optimization pack for Oracle Database 18c.

Metrics

Memory

Metric	Unit	Description
oracle_sga_total_size	bytes	The current memory size of the SGA.
oracle_sga_free_size	bytes	The amount of SGA currently available.
oracle_sga_max_size	bytes	The configured maximum memory size for the SGA.
oracle_pga_target_size	bytes	The configured target memory size for the PGA.
oracle_redo_buffers_size	bytes	The memory size of the redo buffers.
oracle_default_buffer_cache_size	bytes	The memory size for the DEFAULT buffer cache component.
oracle_default_2k_buffer_cache_size	bytes	The memory size for the DEFAULT 2k buffer cache component.
oracle_default_4k_buffer_cache_size	bytes	The memory size for the DEFAULT 4k buffer cache component.
oracle_default_8k_buffer_cache_size	bytes	The memory size for the DEFAULT 8k buffer cache component.
oracle_default_16k_buffer_cache_size	bytes	The memory size for the DEFAULT 16k buffer cache component.
oracle_default_32k_buffer_cache_size	bytes	The memory size for the DEFAULT 32k buffer cache component.
oracle_keep_buffer_cache_size	bytes	The memory size for the KEEP buffer cache component.
oracle_recycle_buffer_cache_size	bytes	The memory size for the RECYCLE buffer cache component.
oracle_asm_buffer_cache_size	bytes	The memory size for the ASM buffer cache component.
oracle_shared_io_pool_size	bytes	The memory size for the IO pool component.
oracle_java_pool_size	bytes	The memory size for the Java pool component.
oracle_large_pool_size	bytes	The memory size for the large pool component.
oracle_shared_pool_size	bytes	The memory size for the shared pool component.
oracle_streams_pool_size	bytes	The memory size for the streams pool component.
oracle_buffer_cache_hit_ratio	percent	How often a requested block has been found in the buffer cache without requiring disk access.

Event waits

Metric	Unit	Description
oracle_wait_class_commit	percent	The percentage of time spent waiting on the events of class 'Commit'.
oracle_wait_class_concurrency	percent	The percentage of time spent waiting on the events of class 'Concurrency'.
oracle_wait_class_system_io	percent	The percentage of time spent waiting on the events of class 'System I/O'.
oracle_wait_class_user_io	percent	The percentage of time spent waiting on the events of class 'User I/O'.
oracle_wait_class_other	percent	The percentage of time spent waiting on the events of class 'Other'.
oracle_wait_class_scheduler	percent	The percentage of time spent waiting on the events of class 'Scheduler'.
oracle_wait_class_idle	percent	The percentage of time spent waiting on the events of class 'Idle'.
oracle_wait_class_application	percent	The percentage of time spent waiting on the events of class 'Application'.
oracle_wait_class_network	percent	The percentage of time spent waiting on the events of class 'Network'.
oracle_wait_class_configuration	percent	The percentage of time spent waiting on the events of class 'Configuration'.
oracle_wait_event_log_file_sync	percent	The percentage of time spent waiting on the 'log file sync' event.
oracle_wait_event_log_file_parallel_write	percent	The percentage of time spent waiting on the 'log file parallel write' event.
oracle_wait_event_log_file_sequential_read	percent	The percentage of time spent waiting on the 'log file sequential read' event.
oracle_wait_event_enq_tx_contention	percent	The percentage of time spent waiting on the 'enq: TX - contention' event.
oracle_wait_event_enq_tx_row_lock_contention	percent	The percentage of time spent waiting on the 'enq: TX - row lock contention' event.
oracle_wait_event_latch_row_cache_objects	percent	The percentage of time spent waiting on the 'latch: row cache objects' event.
oracle_wait_event_latch_shared_pool	percent	The percentage of time spent waiting on the 'latch: shared pool' event.
oracle_wait_event_resmgr_cpu_quantum	percent	The percentage of time spent waiting on the 'resmgr:cpu quantum' event.
oracle_wait_event_sql_net_message_from_client	percent	The percentage of time spent waiting on the 'SQL*Net message from client' event.
oracle_wait_event_rdbms_ipc_message	percent	The percentage of time spent waiting on the 'rdbms ipc message' event.
oracle_wait_event_db_file_sequential_read	percent	The percentage of time spent waiting on the 'db file sequential read' event.
oracle_wait_event_log_file_switch_checkpoint_incomplete	percent	The percentage of time spent waiting on the 'log file switch (checkpoint incomplete)' event.
oracle_wait_event_row_cache_lock	percent	The percentage of time spent waiting on the 'row cache lock' event.
oracle_wait_event_buffer_busy_waits	percent	The percentage of time spent waiting on the 'buffer busy waits' event.
oracle_wait_event_db_file_async_io_submit	percent	The percentage of time spent waiting on the 'db file async I/O submit' event.

Sessions

Metric	Unit	Description
oracle_sessions_active_user	sessions	The number of active user sessions.
oracle_sessions_inactive_user	sessions	The number of inactive user sessions.
oracle_sessions_active_background	sessions	The number of active background sessions.
oracle_sessions_inactive_background	sessions	The number of inactive background sessions.

Other metrics

Metric	Unit	Description
oracle_calls_execute_count	calls	Total number of calls (user and recursive) that executed SQL statements.
oracle_tuned_undoretention	seconds	The amount of time for which undo will not be recycled from the time it was committed.
oracle_max_query_length	seconds	The length of the longest query executed.
oracle_transaction_count	transactions	The total number of transactions executed within the period.
oracle_sso_errors	errors/s	The number of ORA-01555 (snapshot too old) errors raised per second.
oracle_redo_log_space_requests	requests	The number of times a user process waits for space in the redo log file, usually caused by checkpointing or log switching.

Parameters

Memory

Redo

Undo

Optimizer

Approximate execution

Parallel processing

Resources

Other parameters

Values and domain suggestions

The following parameters require their ranges or default values to be updated according to the described rules:

Memory

Resources

Constraints

The following tables show a list of constraints that may be required in the definition of the study, depending on the tuned parameters.

Memory

Other constraints