给大家介绍[一套oracle数据库监控管理脚本](https://github.com/denglt/oracleMonitor) 该脚本对oracle的监控还是比较全面的，使用也很方便，自己也可以在脚本的基础上扩展自己的功能。 # [目录](https://github.com/denglt/oracleMonitor/blob/master/catalog.md) ## [安装监控脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/config.md) - [配置数据库连接信息](https://github.com/denglt/oracleMonitor/blob/master/docs/config.md#connection) - [window操作系统](https://github.com/denglt/oracleMonitor/blob/master/docs/config.md#conn-win) - [linux|mac操作系统](https://github.com/denglt/oracleMonitor/blob/master/docs/config.md#conn-mac) - [连接数据库事例](https://github.com/denglt/oracleMonitor/blob/master/docs/config.md#conn-example) - [配置运行时参数](https://github.com/denglt/oracleMonitor/blob/master/docs/config.md#runtime) ## [session监控](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md) - [Lock监控](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#lock) - [阻塞Lock](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_blocklock) - [长时间未释放的Lock](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_longlock) - [正在运行的慢SQL信息](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_longops) - [session使用PGA内存大小](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_pga) - [session占用undo空间大小](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_undo) - [session使用cpu时间](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_cpu) - [session占用临时表空间大小](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_tempseg) - [session占用临时表空间详细信息](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_tempseg_detail) - [session使用cursor](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_cursor) - [session整体情况](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#sess_info) - [当前等待事件](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#wait_event) - [当前非空闲等待事件](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#se_noidle) - [当前热点块等待事件](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#se_hot_block) - [当前Hight Water等待事件](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#se_hw) - [当前指定的等待事件](https://github.com/denglt/oracleMonitor/blob/master/docs/session.md#se_wait) ## [SQL监控和调优](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md) - [分析SQL的执行计划](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#explain) - [分析SQL运行信息](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#sql_info) - [sql profile 固化outline](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#sql_profile) - [固化v$sql_plan中的outline](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#create_sql_profile) - [固化自定义的outline](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#create_sql_profile_sqlid) - [固化自定义的outline2](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#create_sql_profile_sqltext) - [查看sql profile 信息](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#sql_profile_info) - [SQL调优](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#sql_tuning) - [调优sql文本](/docs/sql.md#sql_tuning_sqltext) - [调优v$sql_plan中执行计划](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#sqltune_sqlid) - [SQL ACCESS 优化](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#sqlAccess) - [11g SQL监控](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#11g) - [SQL监控列表](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#rpt_sml) - [SQL监控报告](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#rpt_sm) - [SQL监控详细信息](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#rpt_sd) - [自动sql调优报告](https://github.com/denglt/oracleMonitor/blob/master/docs/sql.md#rat_astt) ## [跟踪事件](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md) - [10064](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#10046) - [trace 10046 event](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#trace_10046) - [获取跟踪文件](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#trace_getfile) - [tkprof分析跟踪文件](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#tkprof) - [10053](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#trace_10053) - [10500](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#trace_10500) - [10237取消正在运行的SQL](https://github.com/denglt/oracleMonitor/blob/master/docs/event.md#cancle_sql) ## [空间和文件监控](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md) - [表空间使用情况](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_tablespace) - [临时表空间使用情况](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_temptablespace) - [undo表空间使用情况](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_undo) - [数据文件使用情况](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_datafile) - [临时表空间文件使用情况](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_tempdatafile) - [联机日志文件信息](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_onlinelog) - [Table占用空间信息](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_table_size) - [segment对象占用空间情况](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_segemnt) - [segment对象空间分析顾问](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#seg_advisor) - [数据文件IO信息统计](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_datafile_io) - [segment对象IO统计](https://github.com/denglt/oracleMonitor/blob/master/docs/space.md#ss_segment_io) - [ASM信息](/docs/space.md#ss_asm) target=)contentFrame) ## [内存监控](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md) - [SGA](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md#sm_sga) - [PGA](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md#sm_pga) - [数据库缓冲区(db_buffer)](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md#sm_db_buffer) - [共享池(share_pool)](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md#sm_share_pool) - [object在buffer中的大](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md#sm_buffer_obj) - [查询结果缓存(11g)](https://github.com/denglt/oracleMonitor/blob/master/docs/memory.md#sm_result_cache) ## [工具脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md) - [获取DDL脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#ddl) - [获取全文索引创建脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#ddl_domain_idx) - [获取Object创建脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#ddl_object) - [获取特定type对象的创建脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#ddl_type) - [获取schema中所有对象的创建脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#ddl_schema) - [检查index](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#check_index) - [包装系统脚](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#wrapper) - [解密加密包](https://github.com/denglt/oracleMonitor/blob/master/docs/tool.md#unwrap) ## [怎样获取以上脚本](https://github.com/denglt/oracleMonitor/blob/master/docs/buy.md)