ORACLE数据库监控内容

时间:2025-03-12 07:04:57
NUM NAME TYPE VALUE ISDEFAULT
38 lock_name_space 2   TRUE
39 processes 3 1500 FALSE
40 sessions 3 2272 FALSE
41 timed_statistics 1 TRUE TRUE
42 timed_os_statistics 3 0 TRUE
43 resource_limit 1 FALSE TRUE
44 license_max_sessions 3 0 TRUE
45 license_sessions_warning 3 0 TRUE
88 cpu_count 3 4 TRUE
93 instance_groups 2   TRUE
97 event 2   TRUE
110 sga_max_size 6 1593835520 TRUE
117 use_large_pages 2 TRUE TRUE
122 pre_page_sga 1 FALSE TRUE
123 shared_memory_address 3 0 TRUE
124 hi_shared_memory_address 3 0 TRUE
125 use_indirect_data_buffers 1 FALSE TRUE
127 lock_sga 1 FALSE TRUE
168 processor_group_name 2   TRUE
173 shared_pool_size 6 0 TRUE
175 large_pool_size 6 0 TRUE
177 java_pool_size 6 0 TRUE
179 streams_pool_size 6 0 TRUE
181 shared_pool_reserved_size 6 7549747 TRUE
184 java_soft_sessionspace_limit 3 0 TRUE
185 java_max_sessionspace_size 3 0 TRUE
194 spfile 2 /data/oracle/product/11.2.0/dbhome_1/dbs/ TRUE
195 instance_type 2 RDBMS TRUE
232 nls_language 2 AMERICAN TRUE
233 nls_territory 2 AMERICA TRUE
234 nls_sort 2   TRUE
235 nls_date_language 2   TRUE
236 nls_date_format 2   TRUE
237 nls_currency 2   TRUE
238 nls_numeric_characters 2   TRUE
239 nls_iso_currency 2   TRUE
240 nls_calendar 2   TRUE
241 nls_time_format 2   TRUE
242 nls_timestamp_format 2   TRUE
243 nls_time_tz_format 2   TRUE
244 nls_timestamp_tz_format 2   TRUE
245 nls_dual_currency 2   TRUE
246 nls_comp 2 BINARY TRUE
247 nls_length_semantics 2 BYTE TRUE
248 nls_nchar_conv_excp 2 FALSE TRUE
255 fileio_network_adapters 2   TRUE
257 filesystemio_options 2 none TRUE
258 dnfs_batch_size 3 4096 TRUE
270 clonedb 1 FALSE TRUE
271 instant_restore 1 FALSE TRUE
279 disk_asynch_io 1 TRUE TRUE
280 tape_asynch_io 1 TRUE TRUE
282 dbwr_io_slaves 3 0 TRUE
286 backup_tape_io_slaves 1 FALSE TRUE
294 resource_manager_cpu_allocation 3 4 TRUE
296 resource_manager_plan 2   TRUE
374 cluster_interconnects 2   TRUE
441 file_mapping 1 FALSE TRUE
538 gcs_server_processes 3 0 TRUE
550 active_instance_count 3   TRUE
779 sga_target 6 0 TRUE
781 memory_target 6 1593835520 FALSE
782 memory_max_target 6 1593835520 TRUE
809 control_files 2 /data/oracle/oradata/orcl/, /data/oracle/oradata/orcl/ FALSE
818 db_file_name_convert 2   TRUE
819 log_file_name_convert 2   TRUE
820 control_file_record_keep_time 3 7 TRUE
824 db_block_buffers 3 0 TRUE
828 db_block_checksum 2 TYPICAL TRUE
829 db_ultra_safe 2 OFF TRUE
830 db_block_size 3 8192 FALSE
846 db_cache_size 6 0 TRUE
848 db_2k_cache_size 6 0 TRUE
849 db_4k_cache_size 6 0 TRUE
850 db_8k_cache_size 6 0 TRUE
851 db_16k_cache_size 6 0 TRUE
852 db_32k_cache_size 6 0 TRUE
853 db_keep_cache_size 6 0 TRUE
854 db_recycle_cache_size 6 0 TRUE
867 db_writer_processes 3 1 TRUE
889 buffer_pool_keep 2   TRUE
890 buffer_pool_recycle 2   TRUE
943 db_flash_cache_file 2   TRUE
944 db_flash_cache_size 6 0 TRUE
966 db_cache_advice 2 ON TRUE
982 compatible 2 11.2.0.4.0 FALSE
993 log_archive_dest_1 2   TRUE
994 log_archive_dest_2 2   TRUE
995 log_archive_dest_3 2   TRUE
996 log_archive_dest_4 2   TRUE
997 log_archive_dest_5 2   TRUE
998 log_archive_dest_6 2   TRUE
999 log_archive_dest_7 2   TRUE
1000 log_archive_dest_8 2   TRUE
1001 log_archive_dest_9 2   TRUE
1002 log_archive_dest_10 2   TRUE
1003 log_archive_dest_11 2   TRUE
1004 log_archive_dest_12 2   TRUE
1005 log_archive_dest_13 2   TRUE
1006 log_archive_dest_14 2   TRUE
1007 log_archive_dest_15 2   TRUE
1008 log_archive_dest_16 2   TRUE
1009 log_archive_dest_17 2   TRUE
1010 log_archive_dest_18 2   TRUE
1011 log_archive_dest_19 2   TRUE
1012 log_archive_dest_20 2   TRUE
1013 log_archive_dest_21 2   TRUE
1014 log_archive_dest_22 2   TRUE
1015 log_archive_dest_23 2   TRUE
1016 log_archive_dest_24 2   TRUE
1017 log_archive_dest_25 2   TRUE
1018 log_archive_dest_26 2   TRUE
1019 log_archive_dest_27 2   TRUE
1020 log_archive_dest_28 2   TRUE
1021 log_archive_dest_29 2   TRUE
1022 log_archive_dest_30 2   TRUE
1023 log_archive_dest_31 2   TRUE
1024 log_archive_dest_state_1 2 enable TRUE
1025 log_archive_dest_state_2 2 enable TRUE
1026 log_archive_dest_state_3 2 enable TRUE
1027 log_archive_dest_state_4 2 enable TRUE
1028 log_archive_dest_state_5 2 enable TRUE
1029 log_archive_dest_state_6 2 enable TRUE
1030 log_archive_dest_state_7 2 enable TRUE
1031 log_archive_dest_state_8 2 enable TRUE
1032 log_archive_dest_state_9 2 enable TRUE
1033 log_archive_dest_state_10 2 enable TRUE
1034 log_archive_dest_state_11 2 enable TRUE
1035 log_archive_dest_state_12 2 enable TRUE
1036 log_archive_dest_state_13 2 enable TRUE
1037 log_archive_dest_state_14 2 enable TRUE
1038 log_archive_dest_state_15 2 enable TRUE
1039 log_archive_dest_state_16 2 enable TRUE
1040 log_archive_dest_state_17 2 enable TRUE
1041 log_archive_dest_state_18 2 enable TRUE
1042 log_archive_dest_state_19 2 enable TRUE
1043 log_archive_dest_state_20 2 enable TRUE
1044 log_archive_dest_state_21 2 enable TRUE
1045 log_archive_dest_state_22 2 enable TRUE
1046 log_archive_dest_state_23 2 enable TRUE
1047 log_archive_dest_state_24 2 enable TRUE
1048 log_archive_dest_state_25 2 enable TRUE
1049 log_archive_dest_state_26 2 enable TRUE
1050 log_archive_dest_state_27 2 enable TRUE
1051 log_archive_dest_state_28 2 enable TRUE
1052 log_archive_dest_state_29 2 enable TRUE
1053 log_archive_dest_state_30 2 enable TRUE
1054 log_archive_dest_state_31 2 enable TRUE
1055 log_archive_start 1 FALSE TRUE
1056 log_archive_dest 2   TRUE
1057 log_archive_duplex_dest 2   TRUE
1058 log_archive_min_succeed_dest 3 1 TRUE
1059 standby_archive_dest 2 ?/dbs/arch TRUE
1064 fal_client 2   TRUE
1065 fal_server 2   TRUE
1068 log_archive_trace 3 0 TRUE
1085 log_archive_config 2   TRUE
1090 log_archive_local_first 1 TRUE TRUE
1092 log_archive_format 2 %t_%s_% TRUE
1097 redo_transport_user 2   TRUE
1102 log_archive_max_processes 3 4 TRUE
1116 log_buffer 3 7069696 TRUE
1119 log_checkpoint_interval 3 0 TRUE
1120 log_checkpoint_timeout 3 1800 TRUE
1122 archive_lag_target 3 0 TRUE
1154 db_files 3 200 TRUE
1155 db_file_multiblock_read_count 3 15 TRUE
1159 read_only_open_delayed 1 FALSE TRUE
1160 cluster_database 1 FALSE TRUE
1161 parallel_server 1 FALSE TRUE
1162 parallel_server_instances 3 1 TRUE
1163 cluster_database_instances 3 1 TRUE
1164 db_create_file_dest 2   TRUE
1165 db_create_online_log_dest_1 2   TRUE
1166 db_create_online_log_dest_2 2   TRUE
1167 db_create_online_log_dest_3 2   TRUE
1168 db_create_online_log_dest_4 2   TRUE
1169 db_create_online_log_dest_5 2   TRUE
1170 db_recovery_file_dest 2   TRUE
1171 db_recovery_file_dest_size 6 0 TRUE
1173 standby_file_management 2 MANUAL TRUE
1251 db_unrecoverable_scn_tracking 1 TRUE TRUE
1255 thread 3 0 TRUE
1262 fast_start_io_target 3 0 TRUE
1263 fast_start_mttr_target 3 0 TRUE
1269 log_checkpoints_to_alert 1 FALSE TRUE
1270 db_lost_write_protect 2 NONE TRUE
1274 recovery_parallelism 3 0 TRUE
1336 enable_goldengate_replication 1 FALSE TRUE
1378 db_flashback_retention_target 3 1440 TRUE
1476 dml_locks 3 9996 TRUE
1481 replication_dependency_tracking 1 TRUE TRUE
1489 transactions 3 2499 TRUE
1490 transactions_per_rollback_segment 3 5 TRUE
1492 rollback_segments 2   TRUE
1500 undo_management 2 AUTO TRUE
1501 undo_tablespace 2 UNDOTBS1 FALSE
1518 undo_retention 3 900 TRUE
1521 fast_start_parallel_rollback 2 LOW TRUE
1523 resumable_timeout 3 0 TRUE
1544 instance_number 3 0 TRUE
1597 db_block_checking 2 FALSE TRUE
1600 recyclebin 2 on TRUE
1724 db_securefile 2 PERMITTED TRUE
1769 create_stored_outlines 2   TRUE
1772 serial_reuse 2 disable TRUE
1780 ldap_directory_access 2 NONE TRUE
1781 ldap_directory_sysauth 2 no TRUE
1782 os_roles 1 FALSE TRUE
1783 rdbms_server_dn 2   TRUE
1784 max_enabled_roles 3 150 TRUE
1785 remote_os_authent 1 FALSE TRUE
1786 remote_os_roles 1 FALSE TRUE
1788 sec_case_sensitive_logon 1 TRUE TRUE
1789 O7_DICTIONARY_ACCESSIBILITY 1 FALSE TRUE
1791 remote_login_passwordfile 2 EXCLUSIVE FALSE
1792 license_max_users 3 0 TRUE
1796 audit_sys_operations 1 FALSE TRUE
1799 global_context_pool_size 2   TRUE
1804 db_domain 2   FALSE
1805 global_names 1 FALSE TRUE
1806 distributed_lock_timeout 3 60 TRUE
1808 commit_point_strength 3 1 TRUE
1811 global_txn_processes 3 1 TRUE
1819 instance_name 2 orcl TRUE
1820 service_names 2 orcl TRUE
1822 dispatchers 2 (PROTOCOL=TCP) (SERVICE=orclXDB) FALSE
1823 shared_servers 3 1 TRUE
1824 max_shared_servers 3   TRUE
1825 max_dispatchers 3   TRUE
1826 circuits 3   TRUE
1827 shared_server_sessions 3   TRUE
1828 local_listener 2   TRUE
1829 remote_listener 2   TRUE
1830 listener_networks 2   TRUE
1844 cursor_space_for_time 1 FALSE TRUE
1845 session_cached_cursors 3 50 TRUE
1852 remote_dependencies_mode 2 TIMESTAMP TRUE
1853 utl_file_dir 2   TRUE
1854 smtp_out_server 2   TRUE
1856 plsql_v2_compatibility 1 FALSE TRUE
1858 plsql_warnings 2 DISABLE:ALL TRUE
1859 plsql_code_type 2 INTERPRETED TRUE
1861 plsql_debug 1 FALSE TRUE
1862 plsql_optimize_level 3 2 TRUE
1863 plsql_ccflags 2   TRUE
1865 plscope_settings 2 IDENTIFIERS:NONE TRUE
1869 permit_92_wrap_format 1 TRUE TRUE
1870 java_jit_enabled 1 TRUE TRUE
1871 java_restrict 2 none TRUE
1872 job_queue_processes 3 1000 TRUE
1875 parallel_min_percent 3 0 TRUE
1878 create_bitmap_area_size 3 8388608 TRUE
1879 bitmap_merge_area_size 3 1048576 TRUE
1882 cursor_sharing 2 EXACT TRUE
1885 result_cache_mode 2 MANUAL TRUE
1900 parallel_min_servers 3 0 TRUE
1901 parallel_max_servers 3 160 TRUE
1906 parallel_instance_group 2   TRUE
1910 parallel_execution_message_size 3 16384 TRUE
1921 hash_area_size 3 131072 TRUE
1941 result_cache_max_size 6 3997696 TRUE
1942 result_cache_max_result 3 5 TRUE
1943 result_cache_remote_expiration 3 0 TRUE
1955 shadow_core_dump 2 partial TRUE
1956 background_core_dump 2 partial TRUE
1957 background_dump_dest 2 /data/oracle/diag/rdbms/orcl/orcl/trace TRUE
1958 user_dump_dest 2 /data/oracle/diag/rdbms/orcl/orcl/trace TRUE
1959 core_dump_dest 2 /data/oracle/diag/rdbms/orcl/orcl/cdump TRUE
1968 audit_file_dest 2 /data/oracle/admin/orcl/adump FALSE
1969 audit_syslog_level 2   TRUE
1975 object_cache_optimal_size 3 102400 TRUE
1976 object_cache_max_size_percent 3 10 TRUE
1980 session_max_open_files 3 10 TRUE
1986 open_links 3 4 TRUE
1987 open_links_per_instance 3 4 TRUE
1991 commit_write 2   TRUE
1992 commit_wait 2   TRUE
1993 commit_logging 2   TRUE
1995 optimizer_features_enable 2 11.2.0.4 TRUE
1996 fixed_date 2   TRUE
1997 audit_trail 2 DB FALSE
1998 sort_area_size 3 65536 TRUE
1999 sort_area_retained_size 3 0 TRUE
2013 cell_offload_processing 1 TRUE TRUE
2014 cell_offload_decryption 1 TRUE TRUE
2015 cell_offload_parameters 2   TRUE
2016 cell_offload_compaction 2 ADAPTIVE TRUE
2017 cell_offload_plan_display 2 AUTO TRUE
2020 db_name 2 orcl FALSE
2021 db_unique_name 2 orcl TRUE
2022 open_cursors 3 300 FALSE
2023 ifile 4   TRUE
2024 sql_trace 1 FALSE TRUE
2025 os_authent_prefix 2 ops$ TRUE
2027 optimizer_mode 2 ALL_ROWS TRUE
2032 sql92_security 1 FALSE TRUE
2035 blank_trimming 1 FALSE TRUE
2041 star_transformation_enabled 2 FALSE TRUE
2083 parallel_degree_policy 2 MANUAL TRUE
2091 parallel_adaptive_multi_user 1 TRUE TRUE
2092 parallel_threads_per_cpu 3 2 TRUE
2093 parallel_automatic_tuning 1 FALSE TRUE
2099 parallel_io_cap_enabled 1 FALSE TRUE
2120 optimizer_index_cost_adj 3 100 TRUE
2121 optimizer_index_caching 3 0 TRUE
2133 query_rewrite_enabled 2 TRUE TRUE
2134 query_rewrite_integrity 2 enforced TRUE
2192 pga_aggregate_target 6 0 TRUE
2195 workarea_size_policy 2 AUTO TRUE
2220 optimizer_dynamic_sampling 3 2 TRUE
2250 statistics_level 2 TYPICAL TRUE
2275 cursor_bind_capture_destination 2 memory+disk TRUE
2294 skip_unusable_indexes 1 TRUE TRUE
2376 optimizer_secure_view_merging 1 TRUE TRUE
2420 ddl_lock_timeout 3 0 TRUE
2422 deferred_segment_creation 1 TRUE TRUE
2430 optimizer_use_pending_statistics 1 FALSE TRUE
2435 optimizer_capture_sql_plan_baselines 1 FALSE TRUE
2436 optimizer_use_sql_plan_baselines 1 TRUE TRUE
2457 parallel_min_time_threshold 2 AUTO TRUE
2459 parallel_degree_limit 2 CPU TRUE
2460 parallel_force_local 1 FALSE TRUE
2469 optimizer_use_invisible_indexes 1 FALSE TRUE
2493 dst_upgrade_insert_conv 1 TRUE TRUE
2498 parallel_servers_target 3 64 TRUE
2557 sec_protocol_error_trace_action 2 TRACE TRUE
2558 sec_protocol_error_further_action 2 CONTINUE TRUE
2559 sec_max_failed_login_attempts 3 10 TRUE
2560 sec_return_server_release_banner 1 FALSE TRUE
2563 enable_ddl_logging 1 FALSE TRUE
2566 client_result_cache_size 6 0 TRUE
2567 client_result_cache_lag 6 3000 TRUE
2592 aq_tm_processes 3 1 TRUE
2608 hs_autoregister 1 TRUE TRUE
2609 xml_db_events 2 enable TRUE
2610 dg_broker_start 1 FALSE TRUE
2611 dg_broker_config_file1 2 /data/oracle/product/11.2.0/dbhome_1/dbs/ TRUE
2612 dg_broker_config_file2 2 /data/oracle/product/11.2.0/dbhome_1/dbs/ TRUE
2624 olap_page_pool_size 6 0 TRUE
2721 asm_diskstring 2   TRUE
2723 asm_preferred_read_failure_groups 2   TRUE
2734 asm_diskgroups 2   TRUE
2735 asm_power_limit 3 1 TRUE
2811 control_management_pack_access 2 DIAGNOSTIC+TUNING TRUE
2833 awr_snapshot_time_offset 3 0 TRUE
2838 sqltune_category 2 DEFAULT TRUE
2874 diagnostic_dest 2 /data/oracle FALSE
2898 tracefile_identifier 2   TRUE
2900 max_dump_file_size 2 unlimited TRUE
2903 trace_enabled 1 TRUE TRUE
2914 cell_offloadgroup_name 2   TRUE