Properties are grouped below by topic.
| Name |
Description |
Typical values |
| _priv_enable_java |
Checks whether Java is enabled |
|
|
| _priv_read_all_indexes |
Checks whether all indexes can be read |
|
|
| _priv_read_all_users |
Checks whether all users can be read |
|
|
| _priv_read_dba_data_files |
Checks whether DBA_DATA_FILES can be read |
|
|
| _priv_read_dba_db_links |
Checks whether DBA_DB_LINKS can be read |
|
|
| _priv_read_dba_directories |
Checks whether DBA_DIRECTORIES can be read |
|
|
| _priv_read_dba_free_space |
Checks whether DBA_FREE_SPACE can be read |
|
|
| _priv_read_dba_jobs |
Checks whether DBA_JOBS can be read |
|
|
| _priv_read_dba_objects |
Checks whether DBA_OBJECTS can be read |
|
|
| _priv_read_dba_segments |
Checks whether DBA_SEGMENTS can be read |
|
|
| _priv_read_dba_tablespace_usage_metrics |
Checks whether DBA_TABLESPACE_USAGE_METRICS can be read |
|
|
| _priv_read_dba_tablespaces |
Checks whether DBA_TABLESPACES can be read |
|
|
| _priv_read_dba_temp_files |
Checks whether DBA_TEMP_FILES can be read |
|
|
| _priv_read_dba_temp_free_space |
Checks whether DBA_TEMP_FREE_SPACE can be read |
|
|
| _priv_read_dba_users |
Checks whether DBA_USERS can be read |
|
|
| _priv_read_gv_lock |
Checks whether GV$LOCK can be read |
|
|
| _priv_read_gv_session |
Checks whether GV$SESSION can be read |
|
|
| _priv_read_gv_sqlarea |
Checks whether GV$SQLAREA can be read |
|
|
| _priv_read_gv_sysstat |
Checks whether GV$SYSSTAT can be read |
|
|
| _priv_read_sys_aud |
Checks whether SYS.AUD$ can be read |
|
|
| _priv_read_sys_gv_instance |
Checks whether SYS.GV_$INSTANCE can be read |
|
|
| _priv_read_sys_x_dbgalertext |
Checks whether SYS.X$DBGALERTEXT can be read |
|
|
| _priv_read_v_archive_dest_status |
Checks whether V$ARCHIVE_DEST_STATUS can be read |
|
|
| _priv_read_v_archived_log |
Checks whether V$ARCHIVED_LOG can be read |
|
|
| _priv_read_v_asm_disk_stat |
Checks whether V$ASM_DISK_STAT can be read |
|
|
| _priv_read_v_asm_diskgroup |
Checks whether V$ASM_DISKGROUP can be read |
|
|
| _priv_read_v_controlfile_record_section |
Checks whether V$CONTROLFILE_RECORD_SECTION can be read |
|
|
| _priv_read_v_database |
Checks whether V$DATABASE can be read |
|
|
| _priv_read_v_datafile |
Checks whether V$DATAFILE can be read |
|
|
| _priv_read_v_flash_recovery_area_usage |
Checks whether V$FLASH_RECOVERY_AREA_USAGE can be read |
|
|
| _priv_read_v_instance |
Checks whether V$INSTANCE can be read |
|
|
| _priv_read_v_log |
Checks whether V$LOG can be read |
|
|
| _priv_read_v_parameter |
Checks whether V$PARAMETER can be read |
|
|
| _priv_read_v_rman_backup_job_details |
Checks whether V$RMAN_BACKUP_JOB_DETAILS can be read |
|
|
| _priv_read_v_session |
Checks whether V$SESSION can be read |
|
|
| _priv_read_v_sqlarea |
Checks whether V$SQLAREA can be read |
|
|
| _priv_read_v_tempfile |
Checks whether V$TEMPFILE can be read |
|
|
| can_get_grant_create_any_directory |
Whether CREATE ANY DIRECTORY can be granted |
|
|
| can_get_grant_execute_sys_dbms_lock |
Whether EXECUTE on SYS.DBMS_LOCK can be granted |
|
|
| enable_adv_hpux |
Whether advanced HP-UX checks are enabled |
|
|
| enable_adv_linux |
Whether advanced Linux checks are enabled |
|
|
| enable_adv_solaris |
Whether advanced Solaris checks are enabled |
|
|
| enable_adv_windows |
Whether advanced Windows checks are enabled |
|
|
| enable_java |
Whether Java support is enabled |
|
|
| has_cdb_support |
Whether the instance supports a CDB |
|
|
| has_flash_recovery |
Whether flash recovery is enabled |
|
|
| has_x_dbgalertext |
Whether X$DBGALERTEXT is available |
|
|
| has_x_ksppsv |
Whether X$KSPPSV is available |
|
|
| reset_password_for_dbwatch_user |
Reset the dbWatch user password |
|
|
| useasm |
Whether ASM is used |
|
|
| useomf |
Whether Oracle Managed Files are used |
|
|
| Name |
Description |
Typical values |
| active_session_count |
Active session count |
|
|
| active_session_pct |
Active session percentage |
|
|
| activity |
Overall activity score |
|
|
| activity_active_sessions_score |
Activity score derived from active sessions |
|
|
| activity_disk_reads |
Disk reads per second |
|
|
| activity_disk_reads_counter |
Current disk read counter |
|
|
| activity_disk_reads_lasttime |
Last disk read sample time in milliseconds since 1970 |
|
|
| activity_disk_reads_score |
Score derived from disk reads |
|
|
| activity_disk_writes |
Disk writes per second |
|
|
| activity_disk_writes_counter |
Current disk write counter |
|
|
| activity_disk_writes_lasttime |
Last disk write sample time in milliseconds since 1970 |
|
|
| activity_disk_writes_score |
Score derived from disk writes |
|
|
| activity_logical_reads |
Logical reads per second |
|
|
| activity_logical_reads_counter |
Current logical reads counter |
|
|
| activity_logical_reads_lasttime |
Last logical read sample time in milliseconds since 1970 |
|
|
| activity_logical_reads_score |
Score derived from logical reads |
|
|
| activity_redo_writes |
Redo writes per second |
|
|
| activity_redo_writes_counter |
Current redo write counter |
|
|
| activity_redo_writes_lasttime |
Last redo write sample time in milliseconds since 1970 |
|
|
| activity_redo_writes_score |
Score derived from redo writes |
|
|
| activity_total_sessions |
Total session count |
|
|
| activity_transaction_writes |
Transaction writes per second |
|
|
| activity_transaction_writes_counter |
Current transaction write counter |
|
|
| cpu_usage_before_pnd |
|
|
| cpu_usage_before_py |
|
|
| cpu_usage_eh_before_pnd |
|
|
| cpu_usage_eh_before_py |
|
|
| cpu_usage_eh_now_pnd |
|
|
| cpu_usage_eh_now_py |
|
|
| cpu_usage_eh_variation_pnd |
|
|
| cpu_usage_eh_variation_py |
|
|
| cpu_usage_nh_before_pnd |
|
|
| cpu_usage_nh_before_py |
|
|
| cpu_usage_nh_now_pnd |
|
|
| cpu_usage_nh_now_py |
|
|
| cpu_usage_nh_variation_pnd |
|
|
| cpu_usage_nh_variation_py |
|
|
| cpu_usage_now_pnd |
|
|
| cpu_usage_now_py |
|
|
| cpu_usage_variation_d_pnd |
|
|
| cpu_usage_variation_d_py |
|
|
| cpu_usage_variation_pnd |
|
|
| cpu_usage_variation_py |
|
|
| cpu_usage_wh_before_pnd |
|
|
| cpu_usage_wh_before_py |
|
|
| cpu_usage_wh_now_pnd |
|
|
| cpu_usage_wh_now_py |
|
|
| cpu_usage_wh_variation_pnd |
|
|
| cpu_usage_wh_variation_py |
|
|
| curr_pga |
|
|
| curr_pga_GB |
|
|
| curr_pga_MB |
|
|
| curr_sga |
|
|
| curr_sga_GB |
|
|
| curr_sga_MB |
|
|
| current_month_seconds_down |
Seconds down in the current month |
|
|
| current_month_uptime_pct |
Current month uptime percentage |
|
|
| current_month_value |
Current month uptime value |
|
|
| current_uptime |
Current uptime |
|
|
| current_uptime_days |
Current uptime in days |
|
|
| current_uptime_hours |
Current uptime in hours |
|
|
| current_uptime_minutes |
Current uptime in minutes |
|
|
| data_cache_exec_counter |
Data cache execution counter |
|
|
| data_cache_exec_counter/buffer_gets |
Buffer gets |
|
|
| data_cache_exec_counter/histr_date |
History date |
|
|
| data_cache_exec_counter/hit_ratio |
Hit ratio |
|
|
| data_cache_exec_counter/period_sec |
Period in seconds |
|
|
| delete_avg |
Average delete performance |
|
|
| disk_usage |
The approximate disk usage (in GB) for the instance |
45.3 |
| disk_usage_data |
Data file disk usage |
|
|
| disk_usage_tmp |
Temporary file disk usage |
|
|
| dml_perf_avg |
Average DML performance |
|
|
| dml_perf_var |
DML performance variation |
|
|
| dml_platform_comp |
DML platform comparison |
|
|
| dml_test_count |
Number of DML tests |
|
|
| insert_avg |
Average insert performance |
|
|
| inst_data_cache |
Current data cache usage |
|
|
| inst_data_cache_GB |
Current data cache usage in GB |
|
|
| inst_data_cache_MB |
Current data cache usage in MB |
|
|
| inst_mem_curr |
Current instance memory usage |
|
|
| inst_mem_curr_GB |
Current instance memory usage in GB |
|
|
| inst_mem_curr_MB |
Current instance memory usage in MB |
|
|
| inst_mem_usage_variation_d_pnd |
Days used for the 90-day memory variation check |
|
|
| inst_mem_usage_variation_d_py |
Days used for the 365-day memory variation check |
|
|
| inst_mem_usage_variation_GB_pnd |
Memory usage variation over 90 days in GB |
|
|
| inst_mem_usage_variation_GB_py |
Memory usage variation over 365 days in GB |
|
|
| inst_mem_usage_variation_MB_pnd |
Memory usage variation over 90 days in MB |
|
|
| inst_mem_usage_variation_MB_py |
Memory usage variation over 365 days in MB |
|
|
| last_month_seconds_down |
Seconds down in the last month |
|
|
| last_month_uptime_pct |
Last month uptime percentage |
|
|
| last_month_value |
Last month uptime value |
|
|
| logical_reads_avg |
Average logical reads |
|
|
| logical_reads_avg_eh |
Average logical reads for EH |
|
|
| logical_reads_avg_increase_days_last |
Days in the last logical read increase period |
|
|
| logical_reads_avg_increase_end_last |
End of the last logical read increase period |
|
|
| logical_reads_avg_increase_last |
Last logical read increase |
|
|
| logical_reads_avg_increase_max |
Maximum logical read increase |
|
|
| logical_reads_avg_increase_max_period |
Maximum logical read increase period |
|
|
| logical_reads_avg_increase_pct_last |
Last logical read increase percentage |
|
|
| logical_reads_avg_increase_periods |
Number of logical read increase periods |
|
|
| logical_reads_avg_increase_start_last |
Start of the last logical read increase period |
|
|
| logical_reads_avg_increase_status |
Logical read increase status |
|
|
| logical_reads_avg_nh |
Average logical reads for NH |
|
|
| logical_reads_avg_wh |
Average logical reads for WH |
|
|
| logical_reads_current |
Current logical reads |
|
|
| logical_reads_max |
Maximum logical reads |
|
|
| logical_reads_max_eh |
Maximum logical reads for EH |
|
|
| logical_reads_max_nh |
Maximum logical reads for NH |
|
|
| logical_reads_max_wh |
Maximum logical reads for WH |
|
|
| operations_uptime_pct |
Operational uptime percentage |
|
|
| operations_uptime_sec_down |
Operational downtime in seconds |
|
|
| operations_uptime_sql |
SQL used to calculate operational uptime |
|
|
| osload_pct |
OS load percentage |
|
|
| osstat_busy_time |
Busy CPU time |
|
|
| osstat_global_receive_size_max |
|
|
| osstat_global_send_size_max |
|
|
| osstat_idle_time |
Idle CPU time |
|
|
| osstat_iowait_time |
I/O wait time |
|
|
| osstat_load |
OS load average |
|
|
| osstat_nice_time |
|
|
| osstat_num_cpu_cores |
Number of CPU cores |
|
|
| osstat_num_cpu_sockets |
Number of CPU sockets |
|
|
| osstat_num_cpus |
Number of CPUs |
|
|
| osstat_physical_memory_bytes |
Physical memory in bytes |
|
|
| osstat_rsrc_mgr_cpu_wait_time |
|
|
| osstat_sys_time |
System CPU time |
|
|
| osstat_tcp_receive_size_default |
|
|
| osstat_tcp_receive_size_max |
|
|
| osstat_tcp_receive_size_min |
|
|
| osstat_tcp_send_size_default |
|
|
| osstat_tcp_send_size_max |
|
|
| osstat_tcp_send_size_min |
|
|
| osstat_user_time |
User CPU time |
|
|
| osstat_vm_in_bytes |
|
|
| osstat_vm_out_bytes |
|
|
| ratio_avg |
Average data hit ratio |
|
|
| ratio_avg_eh |
Average data hit ratio for EH |
|
|
| ratio_avg_nh |
Average data hit ratio for NH |
|
|
| ratio_avg_wh |
Average data hit ratio for WH |
|
|
| sec_after_1970 |
Seconds since 1970 |
|
|
| select_avg |
Average select performance |
|
|
| strength |
Overall strength score |
|
|
| strength_cpu |
CPU strength score |
|
|
| strength_disk_io |
Disk I/O strength score |
|
|
| strength_disk_space |
Disk space strength score |
|
|
| strength_memory |
Memory strength score |
|
|
| time |
Current time |
|
|
| total_logical_reads |
Total logical reads |
|
|
| total_session_count |
The total number of sessions on the instance |
12, 432 |
| update_avg |
Average update performance |
|
|
| utc_diff_h |
UTC difference in hours |
|
|
| utc_diff_s |
UTC difference in seconds |
|
|
| utc_sec_diff |
UTC offset in seconds |
|
|
| utilization |
Utilization score |
|
|
| utilization_active_sessions_core |
Active sessions utilization core score |
|
|
| utilization_disk_used_free |
Disk used/free utilization |
|
|
| utilization_disk_used_free_OLD_R |
Legacy disk used/free utilization |
|
|
| utilization_mem_used_free |
Memory used/free utilization |
|
|
| Name |
Description |
Typical values |
| alert_err |
Alert error |
|
|
| alert_err/details |
Alert error details |
|
|
| alert_err/histr_date |
Alert history date |
|
|
| alerts_history_sec |
Alert history in seconds since 1970 |
|
|
| alerts_history_sec/job_name |
Job name |
|
|
| alerts_history_sec/status |
Alert status |
|
|
| alerts_history_sec/time_stamp_txt |
Alert timestamp text |
|
|
| alerts_per_day_histr_sec |
Alerts per day history |
|
|
| alerts_per_day_histr_sec/alarm_count |
Alarm count |
|
|
| alerts_per_day_histr_sec/alert_count |
Alert count |
|
|
| alerts_per_day_histr_sec/last_alert_txt |
Last alert text |
|
|
| alerts_per_day_histr_sec/warning_count |
Warning count |
|
|
| dbw_engine_alert |
|
|
| dbw_engine_alert/alert_count |
|
|
| dbw_engine_alert/frequency |
|
|
| dbw_engine_alert/frequency_days |
|
|
| dbw_engine_alert/frequency_hours |
|
|
| dbw_engine_alert/frequency_minutes |
|
|
| dbw_engine_alert/frequency_months |
|
|
| dbw_engine_alert/frequency_weeks |
|
|
| dbw_engine_alert/last_date |
|
|
| dbw_engine_alert/last_date_in_days |
|
|
| dbw_engine_alert/oldes_date |
|
|
| health_demanding_sql |
|
|
| health_err |
|
|
| health_err_in_dbwatch |
|
|
| health_err_mem_config |
|
|
| health_free_space |
|
|
| health_hitratio |
|
|
| health_large_tempspace |
|
|
| health_redo_switchrate |
|
|
| health_sql_responsetime |
|
|
| inst_err_log_alerting_status |
|
|
| inst_err_log_avg_max_records_read_aggr_last_7d |
|
|
| inst_err_log_avg_records_read_last_24h |
|
|
| inst_err_log_avg_time_read_last_24h |
|
|
| inst_err_log_avg_tot_records_read_aggr_last_7d |
|
|
| inst_err_log_avg_tot_time_read_aggr_last_7d |
|
|
| inst_err_log_details_count |
|
|
| inst_err_log_error_count_ignored_last_24h |
|
|
| inst_err_log_error_count_last_24h |
|
|
| inst_err_log_error_count_last_7d |
|
|
| inst_err_log_last_error_date |
|
|
| inst_err_log_last_executed |
|
|
| inst_err_log_max_max_records_read_aggr_last_7d |
|
|
| inst_err_log_max_records_read_last_24h |
|
|
| inst_err_log_max_time_read_last_24h |
|
|
| inst_err_log_max_tot_records_read_aggr_last_7d |
|
|
| inst_err_log_max_tot_time_read_aggr_last_7d |
|
|
| Name |
Description |
Typical values |
| backup_history_rman |
RMAN backup history |
|
|
| backup_history_rman/backup_ended |
Backup ended time |
|
|
| backup_history_rman/device |
Backup device |
|
|
| backup_history_rman/elaps_time |
Backup elapsed time |
|
|
| backup_history_rman/input_gb |
Input size in GB |
|
|
| backup_history_rman/input_type |
Input type |
|
|
| backup_history_rman/output_gb |
Output size in GB |
|
|
| backup_history_rman/start_time |
Backup start time |
|
|
| backup_history_rman/status |
Backup status |
|
|
| backup_set_details_last_archivelog |
Last archivelog backup details |
|
|
| backup_set_details_last_archivelog/backup_type |
|
|
| backup_set_details_last_archivelog/device_type |
|
|
| backup_set_details_last_archivelog/incremental_level |
|
|
| backup_set_details_last_archivelog/output_bytes_display |
|
|
| backup_set_details_last_archivelog/start_time |
|
|
| backup_set_details_last_archivelog/time_taken_display |
|
|
| backup_set_details_last_full |
Last full backup details |
|
|
| backup_set_details_last_full/backup_type |
|
|
| backup_set_details_last_full/device_type |
|
|
| backup_set_details_last_full/incremental_level |
|
|
| backup_set_details_last_full/output_bytes_display |
|
|
| backup_set_details_last_full/start_time |
|
|
| backup_set_details_last_full/time_taken_display |
|
|
| backup_set_details_last_incremental |
Last incremental backup details |
|
|
| backup_set_details_last_incremental/backup_type |
|
|
| backup_set_details_last_incremental/device_type |
|
|
| backup_set_details_last_incremental/incremental_level |
|
|
| backup_set_details_last_incremental/output_bytes_display |
|
|
| backup_set_details_last_incremental/start_time |
|
|
| backup_set_details_last_incremental/time_taken_display |
|
|
| flash_recovery_file_type |
|
|
| flash_recovery_file_type/number_of_files |
|
|
| flash_recovery_file_type/percent_space_free |
|
|
| flash_recovery_file_type/percent_space_reclaimable |
|
|
| flash_recovery_file_type/percent_space_used |
|
|
| flash_recovery_mb_free |
|
|
| flash_recovery_mb_reclaimable |
|
|
| flash_recovery_mb_total |
|
|
| flash_recovery_mb_used |
|
|
| flash_recovery_mb_used_not_reclaimable |
|
|
| flash_recovery_name |
|
|
| flash_recovery_pct_free |
|
|
| flash_recovery_pct_used |
|
|
| flash_recovery_pct_used_not_reclaimable |
|
|
| Name |
Description |
Typical values |
| archiver |
|
|
| asm |
|
|
| audit_table_last_record |
|
|
| audit_table_oldest_record |
|
|
| audit_table_records |
|
|
| audit_table_rowid |
|
|
| audit_table_rowid/date_char |
|
|
| audit_table_rowid/ddl |
|
|
| audit_table_rowid/histr_sec |
|
|
| audit_table_rowid/object |
|
|
| audit_table_rowid/schema |
|
|
| audit_table_rowid/who |
|
|
| background_session_count |
|
|
| created |
|
|
| database_role |
Database role |
|
|
| db_count |
The number of databases on the instance |
23 |
| db_count_two |
|
|
| db_has_dbwtasks |
|
|
| db_name |
|
|
| db_unique_name |
Database unique name |
|
|
| dbhost |
|
|
| dbid |
|
|
| dbname |
|
|
| dbw_db_maintenance_period_count |
|
|
| dbw_db_maintenance_period_id |
|
|
| dbw_db_maintenance_period_id/comment |
|
|
| dbw_db_maintenance_period_id/created_char |
|
|
| dbw_db_maintenance_period_id/created_sec_1970 |
|
|
| dbw_db_maintenance_period_id/end_char |
|
|
| dbw_db_maintenance_period_id/end_sec_1970 |
|
|
| dbw_db_maintenance_period_id/name |
|
|
| dbw_db_maintenance_period_id/start_char |
|
|
| dbw_db_maintenance_period_id/start_sec_1970 |
|
|
| dbw_db_maintenance_period_last_id |
|
|
| dbw_db_maintenance_period_last_id/duration_hours |
|
|
| dbw_db_maintenance_period_last_id/end_char |
|
|
| dbw_db_maintenance_period_last_id/end_sec_1970 |
|
|
| dbw_db_maintenance_period_last_id/name |
|
|
| dbw_db_maintenance_period_last_id/start_char |
|
|
| dbw_db_maintenance_period_last_id/start_sec_1970 |
|
|
| dbw_db_maintenance_period_next_id |
|
|
| dbw_db_maintenance_period_next_id/duration_hours |
|
|
| dbw_db_maintenance_period_next_id/end_char |
|
|
| dbw_db_maintenance_period_next_id/end_sec_1970 |
|
|
| dbw_db_maintenance_period_next_id/name |
|
|
| dbw_db_maintenance_period_next_id/start_char |
|
|
| dbw_db_maintenance_period_next_id/start_sec_1970 |
|
|
| dbw_engine_tables |
|
|
| dbw_engine_tables/analyzed |
|
|
| dbw_engine_tables/created |
|
|
| dbw_engine_tables/location |
|
|
| dbw_engine_tables/modified |
|
|
| dbw_engine_tables/rows |
|
|
| dbw_engine_tables/size_mb |
|
|
| dbw_engine_tables/table_type |
|
|
| edition |
The edition of the instance |
Standard Edition, Enterprise Edition |
| engine_created |
|
|
| engine_data_file_name |
|
|
| engine_data_file_name/autoextend_on |
|
|
| engine_data_file_name/free_mb |
|
|
| engine_data_file_name/max_size_mb |
|
|
| engine_data_file_name/size_mb |
|
|
| engine_data_file_name/tablespace |
|
|
| engine_data_file_name/used_mb |
|
|
| engine_data_file_name/used_pct |
|
|
| engine_edition |
Oracle engine edition |
|
|
| engine_exists |
Whether the Oracle engine exists |
|
|
| framework_exists |
|
|
| hosttype |
|
|
| instance_agent_job |
|
|
| instance_agent_job/broken |
|
|
| instance_agent_job/failures |
|
|
| instance_agent_job/interval |
|
|
| instance_agent_job/job |
|
|
| instance_agent_job/last_date |
|
|
| instance_agent_job/log_user |
|
|
| instance_agent_job/name |
|
|
| instance_agent_job/next_date |
|
|
| instance_agent_job/priv_user |
|
|
| instance_agent_job/schema_user |
|
|
| instance_agent_job/status |
|
|
| instance_agent_job/total_time |
|
|
| instance_agent_job/what |
|
|
| instance_agent_job_count |
|
|
| instance_class |
|
|
| instance_id |
Instance ID |
|
|
| instance_id/db_unique_name |
Database unique name |
|
|
| instance_id/hostname |
Host name |
|
|
| instance_id/instance_name |
Instance name |
|
|
| instance_name |
Instance name |
|
|
| instance_number |
Instance number |
|
|
| instance_started_sec_1970 |
Instance start time in seconds since 1970 |
|
|
| instance_started_sec_1971 |
Instance start time in seconds since 1971 |
|
|
| instance_status |
Instance status |
|
|
| is_ora_solaris |
|
|
| login_exists |
Whether the login exists |
|
|
| maj_min_version |
Major and minor version |
|
|
| maj_version |
Major Oracle version |
|
|
| memory_usage |
The approximate memory usage (in MB) for the instance |
2450 |
| name |
Instance name |
|
|
| one |
Constant value one |
|
|
| one_int_engine |
Constant value one for the engine |
|
|
| ostype_db |
Operating system type for the database |
|
|
| patch_action_time |
|
|
| patch_action_time/action |
|
|
| patch_action_time/comments |
|
|
| patch_action_time/namespace |
|
|
| patch_action_time/patch_id |
|
|
| patch_action_time/version |
|
|
| platform_id |
Platform ID |
|
|
| platform_info |
Platform and version info |
Oracle 23.2.0.0.0 |
| platform_is_linux |
Whether the platform is Linux |
|
|
| platform_is_solaris |
Whether the platform is Solaris |
|
|
| platform_is_windows |
Whether the platform is Windows |
|
|
| program_name |
Program name |
|
|
| prop_user |
Property user |
|
|
| protection_level |
Protection level |
|
|
| protection_mode |
Protection mode |
|
|
| started |
A text representation of the start time for the instance |
21.10.2020 11:39:16, 11.10.2023 11:47:08 |
| version |
Oracle version |
|
|
| zero |
Constant value zero |
|
|
| Name |
Description |
Typical values |
| buffer_miss_pct |
|
|
| session_load_histr_sec |
|
|
| session_load_histr_sec/active |
|
|
| session_load_histr_sec/date_val |
|
|
| session_load_histr_sec/total |
|
|
| session_load_type_histr_sec |
|
|
| session_load_type_histr_sec/sec1970 |
|
|
| session_load_type_histr_sec/sessions |
|
|
| session_load_type_histr_sec/sessiontype |
|
|
| sql_repository_size_mb |
|
|
| sql_statistics_avg_exec_time_ms |
|
|
| sql_statistics_exec_time_ms |
|
|
| sql_statistics_max_exec_time_ms |
|
|
| sysmetric_active_parallel_sessions |
|
|
| sysmetric_active_serial_sessions |
|
|
| sysmetric_average_active_sessions |
|
|
| sysmetric_average_synchronous_single-block_read_latency |
|
|
| sysmetric_background_checkpoints_per_sec |
|
|
| sysmetric_background_cpu_usage_per_sec |
|
|
| sysmetric_background_time_per_sec |
|
|
| sysmetric_branch_node_splits_per_sec |
|
|
| sysmetric_branch_node_splits_per_txn |
|
|
| sysmetric_buffer_cache_hit_ratio |
|
|
| sysmetric_captured_user_calls |
|
|
| sysmetric_cell_physical_io_interconnect_bytes |
|
|
| sysmetric_consistent_read_changes_per_sec |
|
|
| sysmetric_consistent_read_changes_per_txn |
|
|
| sysmetric_consistent_read_gets_per_sec |
|
|
| sysmetric_consistent_read_gets_per_txn |
|
|
| sysmetric_cpu_usage_per_sec |
|
|
| sysmetric_cpu_usage_per_txn |
|
|
| sysmetric_cr_blocks_created_per_sec |
|
|
| sysmetric_cr_blocks_created_per_txn |
|
|
| sysmetric_cr_undo_records_applied_per_sec |
|
|
| sysmetric_cr_undo_records_applied_per_txn |
|
|
| sysmetric_current_logons_count |
|
|
| sysmetric_current_open_cursors_count |
|
|
| sysmetric_current_os_load |
|
|
| sysmetric_cursor_cache_hit_ratio |
|
|
| sysmetric_database_cpu_time_ratio |
|
|
| sysmetric_database_time_per_sec |
|
|
| sysmetric_database_wait_time_ratio |
|
|
| sysmetric_db_block_changes_per_sec |
|
|
| sysmetric_db_block_changes_per_txn |
|
|
| sysmetric_db_block_changes_per_user_call |
|
|
| sysmetric_db_block_gets_per_sec |
|
|
| sysmetric_db_block_gets_per_txn |
|
|
| sysmetric_db_block_gets_per_user_call |
|
|
| sysmetric_dbwr_checkpoints_per_sec |
|
|
| sysmetric_ddl_statements_parallelized_per_sec |
|
|
| sysmetric_disk_sort_per_sec |
|
|
| sysmetric_disk_sort_per_txn |
|
|
| sysmetric_dml_statements_parallelized_per_sec |
|
|
| sysmetric_enqueue_deadlocks_per_sec |
|
|
| sysmetric_enqueue_deadlocks_per_txn |
|
|
| sysmetric_enqueue_requests_per_sec |
|
|
| sysmetric_enqueue_requests_per_txn |
|
|
| sysmetric_enqueue_timeouts_per_sec |
|
|
| sysmetric_enqueue_timeouts_per_txn |
|
|
| sysmetric_enqueue_waits_per_sec |
|
|
| sysmetric_enqueue_waits_per_txn |
|
|
| sysmetric_execute_without_parse_ratio |
|
|
| sysmetric_executions_per_sec |
|
|
| sysmetric_executions_per_txn |
|
|
| sysmetric_executions_per_user_call |
|
|
| sysmetric_full_index_scans_per_sec |
|
|
| sysmetric_full_index_scans_per_txn |
|
|
| sysmetric_gc_cr_block_received_per_second |
|
|
| sysmetric_gc_cr_block_received_per_txn |
|
|
| sysmetric_gc_current_block_received_per_second |
|
|
| sysmetric_gc_current_block_received_per_txn |
|
|
| sysmetric_global_cache_average_cr_get_time |
|
|
| sysmetric_global_cache_average_current_get_time |
|
|
| sysmetric_global_cache_blocks_corrupted |
|
|
| sysmetric_global_cache_blocks_lost |
|
|
| sysmetric_hard_parse_count_per_sec |
|
|
| sysmetric_hard_parse_count_per_txn |
|
|
| sysmetric_host_cpu_usage_per_sec |
|
|
| sysmetric_host_cpu_utilization_pct |
|
|
| sysmetric_i_o_megabytes_per_second |
|
|
| sysmetric_i_o_requests_per_second |
|
|
| sysmetric_leaf_node_splits_per_sec |
|
|
| sysmetric_leaf_node_splits_per_txn |
|
|
| sysmetric_library_cache_hit_ratio |
|
|
| sysmetric_library_cache_miss_ratio |
|
|
| sysmetric_logical_reads_per_sec |
|
|
| sysmetric_logical_reads_per_txn |
|
|
| sysmetric_logical_reads_per_user_call |
|
|
| sysmetric_logons_per_sec |
|
|
| sysmetric_logons_per_txn |
|
|
| sysmetric_long_table_scans_per_sec |
|
|
| sysmetric_long_table_scans_per_txn |
|
|
| sysmetric_memory_sorts_ratio |
|
|
| sysmetric_network_traffic_volume_mb_per_sec |
|
|
| sysmetric_network_traffic_volume_per_sec |
|
|
| sysmetric_open_cursors_per_sec |
|
|
| sysmetric_open_cursors_per_txn |
|
|
| sysmetric_parse_failure_count_per_sec |
|
|
| sysmetric_parse_failure_count_per_txn |
|
|
| sysmetric_pga_cache_hit_pct |
|
|
| sysmetric_physical_read_bytes_per_sec |
|
|
| sysmetric_physical_read_io_requests_per_sec |
|
|
| sysmetric_physical_read_total_bytes_per_sec |
|
|
| sysmetric_physical_read_total_io_requests_per_sec |
|
|
| sysmetric_physical_reads_direct_lobs_per_sec |
|
|
| sysmetric_physical_reads_direct_lobs_per_txn |
|
|
| sysmetric_physical_reads_direct_per_sec |
|
|
| sysmetric_physical_reads_direct_per_txn |
|
|
| sysmetric_physical_reads_per_sec |
|
|
| sysmetric_physical_reads_per_txn |
|
|
| sysmetric_physical_write_bytes_per_sec |
|
|
| sysmetric_physical_write_io_requests_per_sec |
|
|
| sysmetric_physical_write_total_bytes_per_sec |
|
|
| sysmetric_physical_write_total_io_requests_per_sec |
|
|
| sysmetric_physical_writes_direct_lobs_per_sec |
|
|
| sysmetric_physical_writes_direct_lobs_per_txn |
|
|
| sysmetric_physical_writes_direct_per_sec |
|
|
| sysmetric_physical_writes_direct_per_txn |
|
|
| sysmetric_physical_writes_per_sec |
|
|
| sysmetric_physical_writes_per_txn |
|
|
| sysmetric_pq_qc_session_count |
|
|
| sysmetric_pq_slave_session_count |
|
|
| sysmetric_process_limit_pct |
|
|
| sysmetric_px_downgraded_1_to_25pct_per_sec |
|
|
| sysmetric_px_downgraded_25_to_50pct_per_sec |
|
|
| sysmetric_px_downgraded_50_to_75pct_per_sec |
|
|
| sysmetric_px_downgraded_75_to_99pct_per_sec |
|
|
| sysmetric_px_downgraded_to_serial_per_sec |
|
|
| sysmetric_px_operations_not_downgraded_per_sec |
|
|
| sysmetric_queries_parallelized_per_sec |
|
|
| sysmetric_recursive_calls_per_sec |
|
|
| sysmetric_recursive_calls_per_txn |
|
|
| sysmetric_redo_allocation_hit_ratio |
|
|
| sysmetric_redo_generated_per_sec |
|
|
| sysmetric_redo_generated_per_txn |
|
|
| sysmetric_redo_writes_per_sec |
|
|
| sysmetric_redo_writes_per_txn |
|
|
| sysmetric_replayed_user_calls |
|
|
| sysmetric_response_time_per_txn |
|
|
| sysmetric_row_cache_hit_ratio |
|
|
| sysmetric_row_cache_miss_ratio |
|
|
| sysmetric_rows_per_sort |
|
|
| sysmetric_session_count |
|
|
| sysmetric_session_limit_pct |
|
|
| sysmetric_shared_pool_free_pct |
|
|
| sysmetric_soft_parse_ratio |
|
|
| sysmetric_sql_service_response_time |
|
|
| sysmetric_streams_pool_usage_percentage |
|
|
| sysmetric_temp_space_used |
|
|
| sysmetric_total_index_scans_per_sec |
|
|
| sysmetric_total_index_scans_per_txn |
|
|
| sysmetric_total_parse_count_per_sec |
|
|
| sysmetric_total_parse_count_per_txn |
|
|
| sysmetric_total_pga_allocated |
|
|
| sysmetric_total_pga_used_by_sql_workareas |
|
|
| sysmetric_total_sorts_per_user_call |
|
|
| sysmetric_total_table_scans_per_sec |
|
|
| sysmetric_total_table_scans_per_txn |
|
|
| sysmetric_total_table_scans_per_user_call |
|
|
| sysmetric_txns_per_logon |
|
|
| sysmetric_user_calls_per_sec |
|
|
| sysmetric_user_calls_per_txn |
|
|
| sysmetric_user_calls_ratio |
|
|
| sysmetric_user_commits_per_sec |
|
|
| sysmetric_user_commits_percentage |
|
|
| sysmetric_user_limit_pct |
|
|
| sysmetric_user_rollback_undo_records_applied_per_txn |
|
|
| sysmetric_user_rollback_undorec_applied_per_sec |
|
|
| sysmetric_user_rollbacks_per_sec |
|
|
| sysmetric_user_rollbacks_percentage |
|
|
| sysmetric_user_transaction_per_sec |
|
|
| sysmetric_workload_capture_and_replay_status |
|
|
| wait_rank |
|
|
| wait_rank/wait_name |
|
|
| wait_rank/wait_time_pct |
|
|
| waits_aggr_eh |
|
|
| waits_aggr_nh |
|
|
| waits_aggr_wh |
|
|
| waits_current |
|
|
| waits_deviation_eh |
|
|
| waits_deviation_nh |
|
|
| waits_deviation_wh |
|
|
| waits_param_ignore_types |
|
|
| Name |
Description |
Typical values |
| _cdb_v_rman_backup_job_details |
|
|
| complexity |
|
|
| complexity_numsessions |
|
|
| complexity_partitioning |
|
|
| complexity_replication |
|
|
| complexity_size |
|
|
| complexity_size_OLD |
|
|
| cpu |
|
|
| dba_free_space_time_high |
|
|
| down_period |
|
|
| down_period/day_of_week |
|
|
| down_period/days_down |
|
|
| down_period/host_name |
|
|
| down_period/last_conn_sec_1970 |
|
|
| down_period/last_dbwatch_connection |
|
|
| down_period/minutes_down |
|
|
| down_period/period_txt |
|
|
| down_period/seconds_down |
|
|
| down_period/started |
|
|
| down_period/started_sec_1970 |
|
|
| eight |
|
|
| eighteen_and_above |
|
|
| eleven_and_above |
|
|
| five |
|
|
| four |
|
|
| health |
|
|
| inactive_users_session_count |
|
|
| last_redo_seq_thread_eight |
|
|
| last_redo_seq_thread_five |
|
|
| last_redo_seq_thread_four |
|
|
| last_redo_seq_thread_nine |
|
|
| last_redo_seq_thread_one |
|
|
| last_redo_seq_thread_seven |
|
|
| last_redo_seq_thread_six |
|
|
| last_redo_seq_thread_ten |
|
|
| last_redo_seq_thread_three |
|
|
| last_redo_seq_thread_two |
|
|
| last_redo_sequence |
|
|
| log_mode |
|
|
| log_switchrate_hour |
|
|
| mem_param_name |
|
|
| mem_param_name/value |
|
|
| mem_param_name/value_GB |
|
|
| mem_param_name/value_MB |
|
|
| nine_and_above |
|
|
| nineteen_and_above |
|
|
| parameter_name |
|
|
| parameter_name/description |
|
|
| parameter_name/display_value |
|
|
| parameter_name/isadjusted |
|
|
| parameter_name/isbasic |
|
|
| parameter_name/isdefault |
|
|
| parameter_name/isdeprecated |
|
|
| parameter_name/isinstance_modifiable |
|
|
| parameter_name/ismodified |
|
|
| parameter_name/isses_modifiable |
|
|
| parameter_name/issys_modifiable |
|
|
| parameter_name/num |
|
|
| parameter_name/type |
|
|
| parameter_name/value |
|
|
| pdb_state_collector_trace_info |
|
|
| pluggdb_count |
|
|
| pluggdb_count_migrate |
|
|
| pluggdb_count_mounted |
|
|
| pluggdb_count_read_onnly |
|
|
| pluggdb_count_read_write |
|
|
| recyclebin_cnt |
|
|
| recyclebin_cnt_high |
|
|
| sec_after_1971 |
|
|
| seven |
|
|
| six |
|
|
| sum_session_wait_class_administrative |
|
|
| sum_session_wait_class_application |
|
|
| sum_session_wait_class_commit |
|
|
| sum_session_wait_class_concurrency |
|
|
| sum_session_wait_class_configuration |
|
|
| sum_session_wait_class_network |
|
|
| sum_session_wait_class_other |
|
|
| sum_session_wait_class_system_io |
|
|
| sum_session_wait_class_user_io |
|
|
| sum_system_wait_class_administrative |
|
|
| sum_system_wait_class_application |
|
|
| sum_system_wait_class_commit |
|
|
| sum_system_wait_class_concurrency |
|
|
| sum_system_wait_class_configuration |
|
|
| sum_system_wait_class_network |
|
|
| sum_system_wait_class_other |
|
|
| sum_system_wait_class_scheduler |
|
|
| sum_system_wait_class_system_io |
|
|
| sum_system_wait_class_user_io |
|
|
| ten_and_above |
|
|
| test_interval |
|
|
| three |
|
|
| twelve_and_above |
|
|
| two |
|
|
| uptime_period |
|
|
| uptime_period/first_conn_sec_1970 |
|
|
| uptime_period/first_dbwatch_connection |
|
|
| uptime_period/host_name |
|
|
| uptime_period/instance_id |
|
|
| uptime_period/instance_name |
|
|
| uptime_period/last_conn_sec_1970 |
|
|
| uptime_period/last_dbwatch_connection |
|
|
| uptime_period/started |
|
|
| uptime_period/started_sec_1970 |
|
|
| uptime_period/uptime |
|
|