ORACLE数据库监控系统

最新推荐文章于 2023-12-23 00:44:14 发布
最新推荐文章于 2023-12-23 00:44:14 发布
阅读量1.4k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/allway2/article/details/95661915
版权

ORACLE数据库监控

 

<<上一快照                              服务器配置运行监控                              下一快照>>

snap datetime: 2019-07-13 09:45:01
versions

snap_iddevice_idproductversion
793NLSRTL11.2.0.4.0
793Oracle Database 11g Enterprise Edition11.2.0.4.0
793PL/SQL11.2.0.4.0
793TNS for Linux:11.2.0.4.0

total 4 rows

instances

snap_iddevice_idinstance_namehost_namestartup_timestatusloginsshutdown_pendingdatabase_status
793orcljdbcoraclemon2019-07-13 07:25:23OPENALLOWEDNOACTIVE

total 1 rows

databases

snap_iddevice_iddbidnamecreatedlog_modeopen_mode
7931540710443ORCL2019-07-06 17:21:47ARCHIVELOGREAD WRITE

total 1 rows

tablespaces

snap_iddevice_idtablespace_namemaxallocusedpct_used_allocpct_used_maxstatusloggingforce_loggingextent_managementallocation_type
793SYSTEM3435972198478643200078210662499.452.28ONLINELOGGINGNOLOCALSYSTEM
793SYSAUX3435972198460817408057855180895.131.68ONLINELOGGINGNOLOCALSYSTEM
793UNDOTBS134359721984943718402365849625.07.07ONLINELOGGINGNOLOCALSYSTEM
793USERS343597219845242880249036847.5.01ONLINELOGGINGNOLOCALSYSTEM
793TESTTBS13743888793620992819221790721.040ONLINELOGGINGNOLOCALSYSTEM
793TEMP343597219841342177280000ONLINENOLOGGINGNOLOCALUNIFORM
793TESTTBS234359721984104857600104857610ONLINELOGGINGNOLOCALSYSTEM

total 7 rows

datafiles

snap_iddevice_idfile_namefile_idtablespace_namebytesstatusautoextensiblemaxbytesincrement_by
793/data/oracle/oradata/orcl/users01.dbf4USERS5242880AVAILABLEYES34359721984160
793/data/oracle/oradata/orcl/undotbs01.dbf3UNDOTBS194371840AVAILABLEYES34359721984640
793/data/oracle/oradata/orcl/sysaux01.dbf2SYSAUX608174080AVAILABLEYES343597219841280
793/data/oracle/oradata/orcl/system01.dbf1SYSTEM786432000AVAILABLEYES343597219841280
793/data/oracle/oradata/orcl/test01.dbf5TESTTBS104857600AVAILABLEYES3435972198413
793/data/oracle/oradata/orcl/test02.dbf6TESTTBS104857600AVAILABLEYES3435972198413
793/data/oracle/oradata/orcl/test03.dbf7TESTTBS106496AVAILABLEYES3435972198413
793/data/oracle/oradata/orcl/test04.dbf8TESTTBS106496AVAILABLEYES3435972198413
793/data/oracle/product/11.2.0/dbhome_1/dbs/TESTTBS29TESTTBS2104857600AVAILABLEYES3435972198412800

total 9 rows

datafilermanbackups

snap_iddevice_idfile#namecompletion_timemax_scn
7939/data/oracle/product/11.2.0/dbhome_1/dbs/TESTTBS22019-07-12 21:39:251185143
7936/data/oracle/oradata/orcl/test02.dbf2019-07-12 21:39:251185143
7933/data/oracle/oradata/orcl/undotbs01.dbf2019-07-12 21:39:251185143
7935/data/oracle/oradata/orcl/test01.dbf2019-07-12 21:39:251185143
7934/data/oracle/oradata/orcl/users01.dbf2019-07-12 21:39:251185143
7938/data/oracle/oradata/orcl/test04.dbf2019-07-12 21:39:251185143
7937/data/oracle/oradata/orcl/test03.dbf2019-07-12 21:39:251185143
7932/data/oracle/oradata/orcl/sysaux01.dbf2019-07-12 21:39:311185143
7931/data/oracle/oradata/orcl/system01.dbf2019-07-12 21:39:321185143

total 9 rows

controlfilermanbackups

snap_iddevice_idcompletion_time
7932019-07-12 21:39:41

total 1 rows

spfilermanbackups

snap_iddevice_idcompletion_time
7932019-07-12 21:39:41

total 1 rows

redologrmanbackups

snap_iddevice_idthread#sequence#next_change#next_time
79311511998072019-07-13 08:53:00

total 1 rows

tempfiles

snap_iddevice_idfile_namefile_idtablespace_namebytesstatusautoextensiblemaxbytesincrement_by
793/data/oracle/oradata/orcl/temp01.dbf1TEMP1342177280ONLINEYES3435972198480

total 1 rows

logfiles

snap_iddevice_idgroup#statustypemember
7933 ONLINE/data/oracle/oradata/orcl/redo03.log
7932 ONLINE/data/oracle/oradata/orcl/redo02.log
7931 ONLINE/data/oracle/oradata/orcl/redo01.log

total 3 rows

users

snap_iddevice_idusernamedefault_tablespacetemporary_tablespaceaccount_statuslock_datecreated
793TESTORACLEUSERSTEMPOPEN 2019-07-08 21:04:20
793testUSERSTEMPOPEN 2019-07-08 20:58:50
793SCOTTUSERSTEMPEXPIRED & LOCKED2019-07-06 17:23:262013-08-24 12:04:21
793OWBSYS_AUDITSYSAUXTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 12:03:41
793OWBSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 12:03:40
793FLOWS_FILESSYSAUXTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 11:58:27
793APEX_PUBLIC_USERUSERSTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 11:58:27
793APEX_030200SYSAUXTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 11:58:27
793MGMT_VIEWSYSTEMTEMPOPEN 2013-08-24 11:57:53
793SYSMANSYSAUXTEMPOPEN 2013-08-24 11:56:19
793SPATIAL_CSW_ADMIN_USRUSERSTEMPEXPIRED & LOCKED2013-08-24 11:56:112013-08-24 11:56:11
793SPATIAL_WFS_ADMIN_USRUSERSTEMPEXPIRED & LOCKED2013-08-24 11:56:082013-08-24 11:56:08
793MDDATAUSERSTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 11:53:28
793OLAPSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:52:402013-08-24 11:52:40
793MDSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:49:402013-08-24 11:49:40
793ORDSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:49:402013-08-24 11:49:40
793SI_INFORMTN_SCHEMASYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:49:402013-08-24 11:49:40
793ORDDATASYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:49:402013-08-24 11:49:40
793ORDPLUGINSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:49:402013-08-24 11:49:40
793XS$NULLUSERSTEMPEXPIRED & LOCKED2013-08-24 11:49:292013-08-24 11:49:29
793XDBSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:47:552013-08-24 11:47:55
793ANONYMOUSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 11:47:55
793CTXSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 12:03:432013-08-24 11:47:37
793EXFSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:47:272013-08-24 11:47:27
793WMSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:43:262013-08-24 11:43:26
793APPQOSSYSSYSAUXTEMPEXPIRED & LOCKED2013-08-24 11:43:002013-08-24 11:43:00
793DBSNMPSYSAUXTEMPOPEN 2013-08-24 11:42:59
793ORACLE_OCMUSERSTEMPEXPIRED & LOCKED2013-08-24 11:39:342013-08-24 11:39:34
793DIPUSERSTEMPEXPIRED & LOCKED2013-08-24 11:38:582013-08-24 11:38:58
793OUTLNSYSTEMTEMPEXPIRED & LOCKED2013-08-24 11:37:432013-08-24 11:37:43
793SYSSYSTEMTEMPOPEN 2013-08-24 11:37:40
793SYSTEMSYSTEMTEMPOPEN 2013-08-24 11:37:40

total 32 rows

sessions

snap_iddevice_idsidserial#usernamemachineosuserprogramprocesstypelogon_timestatus
79311 jdbcoraclemonoracleoracle@jdbcoraclemon (VKTM)7905BACKGROUND2019-07-13 07:25:26ACTIVE
79321 jdbcoraclemonoracleoracle@jdbcoraclemon (DIA0)7915BACKGROUND2019-07-13 07:25:26ACTIVE
79331 jdbcoraclemonoracleoracle@jdbcoraclemon (CKPT)7923BACKGROUND2019-07-13 07:25:26ACTIVE
79341 jdbcoraclemonoracleoracle@jdbcoraclemon (MMNL)7931BACKGROUND2019-07-13 07:25:26ACTIVE
79353 jdbcoraclemonoracleoracle@jdbcoraclemon (ARC0)7947BACKGROUND2019-07-13 07:25:31ACTIVE
79361 jdbcoraclemonoracleoracle@jdbcoraclemon (QMNC)7957BACKGROUND2019-07-13 07:25:33ACTIVE
79387SYSTEMx220win10AdministratorDBeaver 6.1.2 - Main1234USER2019-07-13 07:26:27INACTIVE
793941 jdbcoraclemonoracleoracle@jdbcoraclemon (SMCO)8029BACKGROUND2019-07-13 07:26:09ACTIVE
79310365 jdbcoraclemonoracleoracle@jdbcoraclemon (J000)17786USER2019-07-13 09:44:57ACTIVE
7935691 jdbcoraclemonoracleoracle@jdbcoraclemon (GEN0)7909BACKGROUND2019-07-13 07:25:26ACTIVE
7935701 jdbcoraclemonoracleoracle@jdbcoraclemon (MMAN)7917BACKGROUND2019-07-13 07:25:26ACTIVE
7935711 jdbcoraclemonoracleoracle@jdbcoraclemon (SMON)7925BACKGROUND2019-07-13 07:25:26ACTIVE
7935723 jdbcoraclemonoracleoracle@jdbcoraclemon (ARC1)7950BACKGROUND2019-07-13 07:25:32ACTIVE
79357317 jdbcoraclemonoracleoracle@jdbcoraclemon (VKRM)7975BACKGROUND2019-07-13 07:25:38ACTIVE
79357447 jdbcoraclemonoracleoracle@jdbcoraclemon (W006)9132BACKGROUND2019-07-13 07:41:33ACTIVE
793575233 jdbcoraclemonoracleoracle@jdbcoraclemon (J001)17788USER2019-07-13 09:44:57ACTIVE
7935783SYSjdbcoraclemonoraclerman@jdbcoraclemon (TNS V1-V3)12681USER2019-07-13 08:33:14INACTIVE
79311371 jdbcoraclemonoracleoracle@jdbcoraclemon (PMON)7900BACKGROUND2019-07-13 07:25:25ACTIVE
79311381 jdbcoraclemonoracleoracle@jdbcoraclemon (DIAG)7911BACKGROUND2019-07-13 07:25:26ACTIVE
79311391 jdbcoraclemonoracleoracle@jdbcoraclemon (DBW0)7919BACKGROUND2019-07-13 07:25:26ACTIVE
79311401 jdbcoraclemonoracleoracle@jdbcoraclemon (RECO)7927BACKGROUND2019-07-13 07:25:26ACTIVE
79311411 jdbcoraclemonoracleoracle@jdbcoraclemon (ARC2)7952BACKGROUND2019-07-13 07:25:32ACTIVE
79311433 jdbcoraclemonoracleoracle@jdbcoraclemon (CJQ0)7970BACKGROUND2019-07-13 07:25:35ACTIVE
79311457SYSTEMx220win10AdministratorDBeaver 6.1.2 - Metadata1234USER2019-07-13 07:26:28INACTIVE
79311465 jdbcoraclemonoracleoracle@jdbcoraclemon (Q000)7997BACKGROUND2019-07-13 07:25:43ACTIVE
793114885SYSTEMphporaclerootphp@phporacle (TNS V1-V3)9926USER2019-07-13 09:45:01ACTIVE
7931705179 jdbcoraclemonoracleoracle@jdbcoraclemon (W003)15069BACKGROUND2019-07-13 09:05:37ACTIVE
79317061 jdbcoraclemonoracleoracle@jdbcoraclemon (PSP0)7902BACKGROUND2019-07-13 07:25:25ACTIVE
79317071 jdbcoraclemonoracleoracle@jdbcoraclemon (DBRM)7913BACKGROUND2019-07-13 07:25:26ACTIVE
79317081 jdbcoraclemonoracleoracle@jdbcoraclemon (LGWR)7921BACKGROUND2019-07-13 07:25:26ACTIVE
79317091 jdbcoraclemonoracleoracle@jdbcoraclemon (MMON)7929BACKGROUND2019-07-13 07:25:26ACTIVE
793171115 jdbcoraclemonoracleoracle@jdbcoraclemon (Q001)7999BACKGROUND2019-07-13 07:25:43ACTIVE
79317121 jdbcoraclemonoracleoracle@jdbcoraclemon (ARC3)7954BACKGROUND2019-07-13 07:25:32ACTIVE
7931714233SYSjdbcoraclemonoraclerman@jdbcoraclemon (TNS V1-V3)12681USER2019-07-13 08:31:24INACTIVE
7931718253SYSjdbcoraclemonoraclerman@jdbcoraclemon (TNS V1-V3)12681USER2019-07-13 08:33:14INACTIVE

total 35 rows

controlfiles

snap_iddevice_idstatusname
793 /data/oracle/oradata/orcl/control01.ctl
793 /data/oracle/oradata/orcl/control02.ctl

total 2 rows

sgas

snap_iddevice_idnamevalue
793Fixed Size2253624
793Variable Size922750152
793Database Buffers654311424
793Redo Buffers7393280

total 4 rows

parameters

snap_iddevice_idnumnametypevalueisdefault
79338lock_name_space2 TRUE
79339processes31500FALSE
79340sessions32272FALSE
79341timed_statistics1TRUETRUE
79342timed_os_statistics30TRUE
79343resource_limit1FALSETRUE
79344license_max_sessions30TRUE
79345license_sessions_warning30TRUE
79388cpu_count34TRUE
79393instance_groups2 TRUE
79397event2 TRUE
793110sga_max_size61593835520TRUE
793117use_large_pages2TRUETRUE
793122pre_page_sga1FALSETRUE
793123shared_memory_address30TRUE
793124hi_shared_memory_address30TRUE
793125use_indirect_data_buffers1FALSETRUE
793127lock_sga1FALSETRUE
793168processor_group_name2 TRUE
793173shared_pool_size60TRUE
793175large_pool_size60TRUE
793177java_pool_size60TRUE
793179streams_pool_size60TRUE
793181shared_pool_reserved_size67549747TRUE
793184java_soft_sessionspace_limit30TRUE
793185java_max_sessionspace_size30TRUE
793194spfile2/data/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.oraTRUE
793195instance_type2RDBMSTRUE
793232nls_language2AMERICANTRUE
793233nls_territory2AMERICATRUE
793234nls_sort2 TRUE
793235nls_date_language2AMERICANTRUE
793236nls_date_format2YYYY-MM-DD HH24:MI:SSTRUE
793237nls_currency2 TRUE
793238nls_numeric_characters2 TRUE
793239nls_iso_currency2 TRUE
793240nls_calendar2 TRUE
793241nls_time_format2 TRUE
793242nls_timestamp_format2 TRUE
793243nls_time_tz_format2 TRUE
793244nls_timestamp_tz_format2 TRUE
793245nls_dual_currency2 TRUE
793246nls_comp2BINARYTRUE
793247nls_length_semantics2BYTETRUE
793248nls_nchar_conv_excp2FALSETRUE
793255fileio_network_adapters2 TRUE
793257filesystemio_options2noneTRUE
793258dnfs_batch_size34096TRUE
793270clonedb1FALSETRUE
793271instant_restore1FALSETRUE
793279disk_asynch_io1TRUETRUE
793280tape_asynch_io1TRUETRUE
793282dbwr_io_slaves30TRUE
793286backup_tape_io_slaves1FALSETRUE
793294resource_manager_cpu_allocation34TRUE
793296resource_manager_plan2SCHEDULER[0x32DE]:DEFAULT_MAINTENANCE_PLANTRUE
793374cluster_interconnects2 TRUE
793441file_mapping1FALSETRUE
793538gcs_server_processes30TRUE
793550active_instance_count3 TRUE
793779sga_target60TRUE
793781memory_target61593835520FALSE
793782memory_max_target61593835520TRUE
793809control_files2/data/oracle/oradata/orcl/control01.ctl, /data/oracle/oradata/orcl/control02.ctlFALSE
793818db_file_name_convert2 TRUE
793819log_file_name_convert2 TRUE
793820control_file_record_keep_time37TRUE
793824db_block_buffers30TRUE
793828db_block_checksum2TYPICALTRUE
793829db_ultra_safe2OFFTRUE
793830db_block_size38192FALSE
793846db_cache_size60TRUE
793848db_2k_cache_size60TRUE
793849db_4k_cache_size60TRUE
793850db_8k_cache_size60TRUE
793851db_16k_cache_size60TRUE
793852db_32k_cache_size60TRUE
793853db_keep_cache_size60TRUE
793854db_recycle_cache_size60TRUE
793867db_writer_processes31TRUE
793889buffer_pool_keep2 TRUE
793890buffer_pool_recycle2 TRUE
793943db_flash_cache_file2 TRUE
793944db_flash_cache_size60TRUE
793966db_cache_advice2ONTRUE
793982compatible211.2.0.4.0FALSE
793993log_archive_dest_12location=/data/oracle/archive/orclFALSE
793994log_archive_dest_22 TRUE
793995log_archive_dest_32 TRUE
793996log_archive_dest_42 TRUE
793997log_archive_dest_52 TRUE
793998log_archive_dest_62 TRUE
793999log_archive_dest_72 TRUE
7931000log_archive_dest_82 TRUE
7931001log_archive_dest_92 TRUE
7931002log_archive_dest_102 TRUE
7931003log_archive_dest_112 TRUE
7931004log_archive_dest_122 TRUE
7931005log_archive_dest_132 TRUE
7931006log_archive_dest_142 TRUE
7931007log_archive_dest_152 TRUE
7931008log_archive_dest_162 TRUE
7931009log_archive_dest_172 TRUE
7931010log_archive_dest_182 TRUE
7931011log_archive_dest_192 TRUE
7931012log_archive_dest_202 TRUE
7931013log_archive_dest_212 TRUE
7931014log_archive_dest_222 TRUE
7931015log_archive_dest_232 TRUE
7931016log_archive_dest_242 TRUE
7931017log_archive_dest_252 TRUE
7931018log_archive_dest_262 TRUE
7931019log_archive_dest_272 TRUE
7931020log_archive_dest_282 TRUE
7931021log_archive_dest_292 TRUE
7931022log_archive_dest_302 TRUE
7931023log_archive_dest_312 TRUE
7931024log_archive_dest_state_12enableTRUE
7931025log_archive_dest_state_22enableTRUE
7931026log_archive_dest_state_32enableTRUE
7931027log_archive_dest_state_42enableTRUE
7931028log_archive_dest_state_52enableTRUE
7931029log_archive_dest_state_62enableTRUE
7931030log_archive_dest_state_72enableTRUE
7931031log_archive_dest_state_82enableTRUE
7931032log_archive_dest_state_92enableTRUE
7931033log_archive_dest_state_102enableTRUE
7931034log_archive_dest_state_112enableTRUE
7931035log_archive_dest_state_122enableTRUE
7931036log_archive_dest_state_132enableTRUE
7931037log_archive_dest_state_142enableTRUE
7931038log_archive_dest_state_152enableTRUE
7931039log_archive_dest_state_162enableTRUE
7931040log_archive_dest_state_172enableTRUE
7931041log_archive_dest_state_182enableTRUE
7931042log_archive_dest_state_192enableTRUE
7931043log_archive_dest_state_202enableTRUE
7931044log_archive_dest_state_212enableTRUE
7931045log_archive_dest_state_222enableTRUE
7931046log_archive_dest_state_232enableTRUE
7931047log_archive_dest_state_242enableTRUE
7931048log_archive_dest_state_252enableTRUE
7931049log_archive_dest_state_262enableTRUE
7931050log_archive_dest_state_272enableTRUE
7931051log_archive_dest_state_282enableTRUE
7931052log_archive_dest_state_292enableTRUE
7931053log_archive_dest_state_302enableTRUE
7931054log_archive_dest_state_312enableTRUE
7931055log_archive_start1FALSETRUE
7931056log_archive_dest2 TRUE
7931057log_archive_duplex_dest2 TRUE
7931058log_archive_min_succeed_dest31TRUE
7931059standby_archive_dest2?/dbs/archTRUE
7931064fal_client2 TRUE
7931065fal_server2 TRUE
7931068log_archive_trace30TRUE
7931085log_archive_config2 TRUE
7931090log_archive_local_first1TRUETRUE
7931092log_archive_format2%t_%s_%r.dbfTRUE
7931097redo_transport_user2 TRUE
7931102log_archive_max_processes34TRUE
7931116log_buffer37069696TRUE
7931119log_checkpoint_interval30TRUE
7931120log_checkpoint_timeout31800TRUE
7931122archive_lag_target30TRUE
7931154db_files3200TRUE
7931155db_file_multiblock_read_count315TRUE
7931159read_only_open_delayed1FALSETRUE
7931160cluster_database1FALSETRUE
7931161parallel_server1FALSETRUE
7931162parallel_server_instances31TRUE
7931163cluster_database_instances31TRUE
7931164db_create_file_dest2 TRUE
7931165db_create_online_log_dest_12 TRUE
7931166db_create_online_log_dest_22 TRUE
7931167db_create_online_log_dest_32 TRUE
7931168db_create_online_log_dest_42 TRUE
7931169db_create_online_log_dest_52 TRUE
7931170db_recovery_file_dest2 TRUE
7931171db_recovery_file_dest_size60TRUE
7931173standby_file_management2MANUALTRUE
7931251db_unrecoverable_scn_tracking1TRUETRUE
7931255thread30TRUE
7931262fast_start_io_target30TRUE
7931263fast_start_mttr_target30TRUE
7931269log_checkpoints_to_alert1FALSETRUE
7931270db_lost_write_protect2NONETRUE
7931274recovery_parallelism30TRUE
7931336enable_goldengate_replication1FALSETRUE
7931378db_flashback_retention_target31440TRUE
7931476dml_locks39996TRUE
7931481replication_dependency_tracking1TRUETRUE
7931489transactions32499TRUE
7931490transactions_per_rollback_segment35TRUE
7931492rollback_segments2 TRUE
7931500undo_management2AUTOTRUE
7931501undo_tablespace2UNDOTBS1FALSE
7931518undo_retention3900TRUE
7931521fast_start_parallel_rollback2LOWTRUE
7931523resumable_timeout30TRUE
7931544instance_number30TRUE
7931597db_block_checking2FALSETRUE
7931600recyclebin2onTRUE
7931724db_securefile2PERMITTEDTRUE
7931769create_stored_outlines2 TRUE
7931772serial_reuse2disableTRUE
7931780ldap_directory_access2NONETRUE
7931781ldap_directory_sysauth2noTRUE
7931782os_roles1FALSETRUE
7931783rdbms_server_dn2 TRUE
7931784max_enabled_roles3150TRUE
7931785remote_os_authent1FALSETRUE
7931786remote_os_roles1FALSETRUE
7931788sec_case_sensitive_logon1TRUETRUE
7931789O7_DICTIONARY_ACCESSIBILITY1FALSETRUE
7931791remote_login_passwordfile2EXCLUSIVEFALSE
7931792license_max_users30TRUE
7931796audit_sys_operations1FALSETRUE
7931799global_context_pool_size2 TRUE
7931804db_domain2 FALSE
7931805global_names1FALSETRUE
7931806distributed_lock_timeout360TRUE
7931808commit_point_strength31TRUE
7931811global_txn_processes31TRUE
7931819instance_name2orclTRUE
7931820service_names2orclTRUE
7931822dispatchers2(PROTOCOL=TCP) (SERVICE=orclXDB)FALSE
7931823shared_servers31TRUE
7931824max_shared_servers3 TRUE
7931825max_dispatchers3 TRUE
7931826circuits3 TRUE
7931827shared_server_sessions3 TRUE
7931828local_listener2 TRUE
7931829remote_listener2 TRUE
7931830listener_networks2 TRUE
7931844cursor_space_for_time1FALSETRUE
7931845session_cached_cursors350TRUE
7931852remote_dependencies_mode2TIMESTAMPTRUE
7931853utl_file_dir2 TRUE
7931854smtp_out_server2 TRUE
7931856plsql_v2_compatibility1FALSETRUE
7931858plsql_warnings2DISABLE:ALLTRUE
7931859plsql_code_type2INTERPRETEDTRUE
7931861plsql_debug1FALSETRUE
7931862plsql_optimize_level32TRUE
7931863plsql_ccflags2 TRUE
7931865plscope_settings2IDENTIFIERS:NONETRUE
7931869permit_92_wrap_format1TRUETRUE
7931870java_jit_enabled1TRUETRUE
7931871java_restrict2noneTRUE
7931872job_queue_processes31000TRUE
7931875parallel_min_percent30TRUE
7931878create_bitmap_area_size38388608TRUE
7931879bitmap_merge_area_size31048576TRUE
7931882cursor_sharing2EXACTTRUE
7931885result_cache_mode2MANUALTRUE
7931900parallel_min_servers30TRUE
7931901parallel_max_servers3160TRUE
7931906parallel_instance_group2 TRUE
7931910parallel_execution_message_size316384TRUE
7931921hash_area_size3131072TRUE
7931941result_cache_max_size63997696TRUE
7931942result_cache_max_result35TRUE
7931943result_cache_remote_expiration30TRUE
7931955shadow_core_dump2partialTRUE
7931956background_core_dump2partialTRUE
7931957background_dump_dest2/data/oracle/diag/rdbms/orcl/orcl/traceTRUE
7931958user_dump_dest2/data/oracle/diag/rdbms/orcl/orcl/traceTRUE
7931959core_dump_dest2/data/oracle/diag/rdbms/orcl/orcl/cdumpTRUE
7931968audit_file_dest2/data/oracle/admin/orcl/adumpFALSE
7931969audit_syslog_level2 TRUE
7931975object_cache_optimal_size3102400TRUE
7931976object_cache_max_size_percent310TRUE
7931980session_max_open_files310TRUE
7931986open_links34TRUE
7931987open_links_per_instance34TRUE
7931991commit_write2 TRUE
7931992commit_wait2 TRUE
7931993commit_logging2 TRUE
7931995optimizer_features_enable211.2.0.4TRUE
7931996fixed_date2 TRUE
7931997audit_trail2DBFALSE
7931998sort_area_size365536TRUE
7931999sort_area_retained_size30TRUE
7932013cell_offload_processing1TRUETRUE
7932014cell_offload_decryption1TRUETRUE
7932015cell_offload_parameters2 TRUE
7932016cell_offload_compaction2ADAPTIVETRUE
7932017cell_offload_plan_display2AUTOTRUE
7932020db_name2orclFALSE
7932021db_unique_name2orclTRUE
7932022open_cursors3300FALSE
7932023ifile4 TRUE
7932024sql_trace1FALSETRUE
7932025os_authent_prefix2ops$TRUE
7932027optimizer_mode2ALL_ROWSTRUE
7932032sql92_security1FALSETRUE
7932035blank_trimming1FALSETRUE
7932041star_transformation_enabled2FALSETRUE
7932083parallel_degree_policy2MANUALTRUE
7932091parallel_adaptive_multi_user1TRUETRUE
7932092parallel_threads_per_cpu32TRUE
7932093parallel_automatic_tuning1FALSETRUE
7932099parallel_io_cap_enabled1FALSETRUE
7932120optimizer_index_cost_adj3100TRUE
7932121optimizer_index_caching30TRUE
7932133query_rewrite_enabled2TRUETRUE
7932134query_rewrite_integrity2enforcedTRUE
7932192pga_aggregate_target60TRUE
7932195workarea_size_policy2AUTOTRUE
7932220optimizer_dynamic_sampling32TRUE
7932250statistics_level2TYPICALTRUE
7932275cursor_bind_capture_destination2memory+diskTRUE
7932294skip_unusable_indexes1TRUETRUE
7932376optimizer_secure_view_merging1TRUETRUE
7932420ddl_lock_timeout30TRUE
7932422deferred_segment_creation1TRUETRUE
7932430optimizer_use_pending_statistics1FALSETRUE
7932435optimizer_capture_sql_plan_baselines1FALSETRUE
7932436optimizer_use_sql_plan_baselines1TRUETRUE
7932457parallel_min_time_threshold2AUTOTRUE
7932459parallel_degree_limit2CPUTRUE
7932460parallel_force_local1FALSETRUE
7932469optimizer_use_invisible_indexes1FALSETRUE
7932493dst_upgrade_insert_conv1TRUETRUE
7932498parallel_servers_target364TRUE
7932557sec_protocol_error_trace_action2TRACETRUE
7932558sec_protocol_error_further_action2CONTINUETRUE
7932559sec_max_failed_login_attempts310TRUE
7932560sec_return_server_release_banner1FALSETRUE
7932563enable_ddl_logging1FALSETRUE
7932566client_result_cache_size60TRUE
7932567client_result_cache_lag63000TRUE
7932592aq_tm_processes31TRUE
7932608hs_autoregister1TRUETRUE
7932609xml_db_events2enableTRUE
7932610dg_broker_start1FALSETRUE
7932611dg_broker_config_file12/data/oracle/product/11.2.0/dbhome_1/dbs/dr1orcl.datTRUE
7932612dg_broker_config_file22/data/oracle/product/11.2.0/dbhome_1/dbs/dr2orcl.datTRUE
7932624olap_page_pool_size60TRUE
7932721asm_diskstring2 TRUE
7932723asm_preferred_read_failure_groups2 TRUE
7932734asm_diskgroups2 TRUE
7932735asm_power_limit31TRUE
7932811control_management_pack_access2DIAGNOSTIC+TUNINGTRUE
7932833awr_snapshot_time_offset30TRUE
7932838sqltune_category2DEFAULTTRUE
7932874diagnostic_dest2/data/oracleFALSE
7932898tracefile_identifier2 TRUE
7932900max_dump_file_size2unlimitedTRUE
7932903trace_enabled1TRUETRUE
7932914cell_offloadgroup_name2 TRUE

total 352 rows

nls_parameters

snap_iddevice_idparametervalue
793NLS_LANGUAGEAMERICAN
793NLS_TERRITORYAMERICA
793NLS_CURRENCY$
793NLS_ISO_CURRENCYAMERICA
793NLS_NUMERIC_CHARACTERS.,
793NLS_CALENDARGREGORIAN
793NLS_DATE_FORMATYYYY-MM-DD HH24:MI:SS
793NLS_DATE_LANGUAGEAMERICAN
793NLS_CHARACTERSETZHS16GBK
793NLS_SORTBINARY
793NLS_TIME_FORMATHH.MI.SSXFF AM
793NLS_TIMESTAMP_FORMATDD-MON-RR HH.MI.SSXFF AM
793NLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZR
793NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZR
793NLS_DUAL_CURRENCY$
793NLS_NCHAR_CHARACTERSETAL16UTF16
793NLS_COMPBINARY
793NLS_LENGTH_SEMANTICSBYTE
793NLS_NCHAR_CONV_EXCPFALSE

total 19 rows

options

snap_iddevice_idparametervalue
793Active Data GuardTRUE
793Advanced CompressionTRUE
793Advanced replicationTRUE
793Application RoleTRUE
793Automatic Storage ManagementFALSE
793Backup EncryptionTRUE
793Basic CompressionTRUE
793Bit-mapped indexesTRUE
793Block Change TrackingTRUE
793Block Media RecoveryTRUE
793Change Data CaptureTRUE
793Coalesce IndexTRUE
793Connection multiplexingTRUE
793Connection poolingTRUE
793DICOMTRUE
793Data MiningTRUE
793Data RedactionTRUE
793Database queuingTRUE
793Database resource managerTRUE
793Deferred Segment CreationTRUE
793Duplexed backupsTRUE
793Enterprise User SecurityTRUE
793Export transportable tablespacesTRUE
793Fast-Start Fault RecoveryTRUE
793File MappingTRUE
793Fine-grained AuditingTRUE
793Fine-grained access controlTRUE
793Flashback Data ArchiveTRUE
793Flashback DatabaseTRUE
793Flashback TableTRUE
793Incremental backup and recoveryTRUE
793Instead-of triggersTRUE
793JavaTRUE
793Join indexTRUE
793Managed StandbyTRUE
793Materialized view rewriteTRUE
793OLAPTRUE
793OLAP Window FunctionsTRUE
793ObjectsTRUE
793Online Index BuildTRUE
793Online RedefinitionTRUE
793Oracle Data GuardTRUE
793Oracle Database VaultFALSE
793Oracle Label SecurityFALSE
793Parallel backup and recoveryTRUE
793Parallel executionTRUE
793Parallel loadTRUE
793PartitioningTRUE
793Plan StabilityTRUE
793Point-in-time tablespace recoveryTRUE
793Proxy authentication/authorizationTRUE
793Real Application ClustersFALSE
793Real Application TestingTRUE
793Result CacheTRUE
793SQL Plan ManagementTRUE
793Sample ScanTRUE
793SecureFiles EncryptionTRUE
793Server Flash CacheTRUE
793SpatialTRUE
793Streams CaptureTRUE
793Transparent Application FailoverTRUE
793Transparent Data EncryptionTRUE
793Trial RecoveryTRUE
793Unused Block CompressionTRUE
793XStreamTRUE

total 65 rows

registrys

snap_iddevice_idcomp_idcomp_nameversionstatusmodifiedschema
793OWBOWB11.2.0.4.0VALID24-AUG-2013 12:04:20OWBSYS
793APEXOracle Application Express3.2.1.00.12VALID24-AUG-2013 12:04:20APEX_030200
793EMOracle Enterprise Manager11.2.0.4.0VALID24-AUG-2013 11:58:27SYSMAN
793SDOSpatial11.2.0.4.0VALID24-AUG-2013 12:04:20MDSYS
793AMDOLAP Catalog11.2.0.4.0VALID24-AUG-2013 12:04:20OLAPSYS
793XOQOracle OLAP API11.2.0.4.0VALID24-AUG-2013 12:04:20SYS
793APSOLAP Analytic Workspace11.2.0.4.0VALID24-AUG-2013 12:04:20SYS
793ORDIMOracle Multimedia11.2.0.4.0VALID24-AUG-2013 12:04:20ORDSYS
793RULOracle Rules Manager11.2.0.4.0VALID24-AUG-2013 12:04:19EXFSYS
793XDBOracle XML Database11.2.0.4.0VALID24-AUG-2013 12:04:19XDB
793CONTEXTOracle Text11.2.0.4.0VALID24-AUG-2013 12:04:18CTXSYS
793EXFOracle Expression Filter11.2.0.4.0VALID24-AUG-2013 12:04:18EXFSYS
793CATJAVAOracle Database Java Packages11.2.0.4.0VALID24-AUG-2013 12:04:18SYS
793XMLOracle XDK11.2.0.4.0VALID24-AUG-2013 12:04:18SYS
793JAVAVMJServer JAVA Virtual Machine11.2.0.4.0VALID24-AUG-2013 12:04:18SYS
793OWMOracle Workspace Manager11.2.0.4.0VALID24-AUG-2013 12:04:18WMSYS
793CATPROCOracle Database Packages and Types11.2.0.4.0VALID24-AUG-2013 12:04:18SYS
793CATALOGOracle Database Catalog Views11.2.0.4.0VALID24-AUG-2013 12:04:18SYS

total 18 rows

licenses

snap_iddevice_idsessions_maxsessions_warningsessions_currentsessions_highwaterusers_max
79300880

total 1 rows

allway2
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
监控oracle数据io,Prometheus监控Oracle数据库
weixin_28807463的博客
04-14 582
背景本文简单介绍下，Prometheus如何通过exporters监控Oracle数据库，以及应该注意哪些指标。oracledb_exporteroracledb_exporter是一个连接到Oracle数据库并生成Prometheus metrics的应用程序，设置展示下如何安装和设置oracledb_exporter，以使用Prometheus来监控Oracle数据库。oracledb_exp...
oracle监控系统
11-22
程序版本为1.0.2 采用qt4开发，面向DBA的监控工具
Oracle数据库进程监控及介绍
运维监控系统PIGOSS
03-22 1711
一、DBWn DBWn（Database writer）是数据库写进程，"n"意味着一个实例是可以有多个数据库写入器的。 1、DBWn的作用 数据库写入器将修改后的数据块从数据库缓冲区高速缓存写入数据文件。 Oracle数据库最多允许36个数据库写入器进程（DBW0-DBW9和DBWa-DBWj）。 DB_WRITER_PROCESSES初始化参数指定DBWn进程的数量。数据库为该初始化参数选择适当的默认设置，或根据CPU数量和处理器组数量调整用户指定的设置。 2、DBWn触发条件 1）每隔3秒钟
oracle数据执行监控工具（sqldbmon.exe）.rar
07-10
oracle数据执行监控工具,可以跟踪当前oracle客户端数据执行走向,语句跟踪,执行SQL语句查看等等非常方便,不懂技术没关系.能看到数据走向.值得下载
oracle+io延时+监控,[Oracle数据库监控] Oracle 10g DATAGUARD 同步延时监控脚本
weixin_36125755的博客
04-09 213
1、监控脚本(注：这里没用Sendmail工具发送邮件，如果用的话需要修改)$cat check_oracle_dg_delay.sh#!/bin/shsource~/.bash_profile#定义变量v_datetime=`date+"%Y-%m-%d%H:%M:%S"`v_username='oracle'v_hostname=`hostname`#获取IP地址v_ip=`/sbin/...
企业内部ORACLE数据库监控系统技术体系.pdf
10-09
然而，数据库服务中断对企业业务的影响也越来越大，因此，建立一套有效的Oracle数据库监控系统至关重要。传统的数据库管理依赖于数据库管理员（DBA）的人工检查和维护，这种方法存在诸多局限，例如：对数据库性能...
oracle数据库监控
01-11
本文将详细介绍有关Oracle数据库监控和日常运维的知识点。 首先，Oracle数据库监控涵盖多个层面，包括但不限于性能监控、空间监控、会话监控以及SQL语句监控等。 1. 性能监控：性能监控关注的是数据库的响应时间和...
Oracle数据库监控检测的相关脚本
05-10
"Oracle数据库监控检测的相关脚本"是一个集合，包含了用于监测Oracle数据库状态、性能指标以及潜在问题的SQL查询和脚本。 在Oracle数据库的监控中，主要关注以下几个方面： 1. **系统资源使用情况**：包括CPU利用...
oracle数据库系统调优方法
09-12
Oracle数据库系统调优是提升整体性能的关键步骤，尤其是在Client/Server模式下，随着数据量的增长，性能下降的问题尤为突出。为了优化系统性能，我们需要从多个层面进行调整。 首先，优化数据库服务器性能至关重要...
oracle 监控io,oracle 监控磁盘IO的脚本
weixin_28867991的博客
04-05 232
之前一直怀疑在数据库忙时会出现磁盘瓶颈，但是一直不能有效收集磁盘IO的历史数据以方便制作报表，所以今天粗略了制作了统计磁盘IO的脚本，将数据写入到scott下的表内，定期查询出数据在EXEL中制作报表(生成EXEL的脚本以后奉上)。OS：solaris 8DB：oracle 9206创建表：create table diskio(time date,rs varchar2(20),ws varch...
外国大佬oracle监控工具
04-24
oracle性能监控器，数据库会话活动信息，系统等待，top5sql，top10 sql，表空间，会话信息，系统事件等待！
ORACLE数据库常用监控sql脚本
01-29
关于最耗资源、表空间使用情况、查看锁等监控脚本整理。
开源oracle监控平台,lepus数据库实时开源监控系统
weixin_39581099的博客
04-10 455
安装lepus软件(中文又称天兔)，先去官网下载，放到/root/lepus目录下[root@***lepus]#unzipLepus数据库企业监控系统3.7版本官方下载.zip然后在去创建数据库，并授权[root@***lepus]#mysqlmysql>createdatabaselepusdefaultcharactersetutf8;mysql>gra...
Oracle监控项目
weixin_41579911的博客
06-16 825
1.实例是否online的监控 2.监控shared pool共享池的情况 ■library cache内存大小是否达到阈值 ■library cache命中率 ■data dictionary cache命中率 3.监控database buffer cache ■database buffer cache的内存大小是否达到阈值 ■database buffer cache命中率 ■databa...
Oracle数据库性能监控常用Sql
z69183787的专栏
01-28 4913
监控sga内存分配信息 select * from v$sgainfo; 监控每个用户的磁盘io及io命中率 select v$sess_io.*,(block_gets+consistent_gets) reads, ((block_gets+consistent_gets-physical_reads)/(block_gets+consistent_gets)) rati
数据库监控工具QMonitor
热门推荐
itcomputer12的专栏
07-22 1万+
Q：QMonitor是什么？ A：QMonitor是一款针对Oracle和MySQL的专业数据库监控平台软件。根据用户设置及时有效地将数据库的异常进行报警，方便用户查看各种实时状态曲线指标，并且对监控、性能数据进行统计分析，从运维者到决策者多个层面的视角生成相关报表。 QMonitor由杭州沃趣网络科技有限公司（简称“沃趣科技”）自主开发。沃趣科技成立于2012年6月，是由原阿里巴巴D
oracle数据库增加表空间数据文件
杨咩咩
10-16 841
oracle增加表空间数据文件
Oracle—运维监控
蓝魔的博客
05-30 1427
Oracle库 告警日志分析
数据库性能监控与优化: Oracle NoSQL Database 的实践
最新发布
禅与计算机程序设计艺术
12-23 925
1.背景介绍 数据库性能监控与优化是数据库管理员和开发人员必须掌握的技能之一。随着数据量的增加，数据库性能的下降也会影响整个系统的性能。因此，了解如何监控和优化数据库性能至关重要。 在本文中，我们将讨论如何监控和优化Oracle NoSQL Database的性能。Oracle NoSQL Database是一种高性能、分布式、非关系型数据库，适用于大规模数据存储和处理场景。它具有高可扩展性、...
Oracle数据库监控系统开发与实践
"Oracle的监控系统是一套由Python和Django构建的，用于辅助数据库运维、统一管理和性能瓶颈预测的工具。系统旨在提供快速了解数据库配置、定位性能问题、统一多套数据库管理的功能，并作为练习Python技能的项目。" ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值