oracle数据库资源池如何监控,我的一套较全面的oracle数据库监控管理脚本

给大家介绍[一套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)