Oracle(通用版)监控项

应用集	监控项说明	监控项
ASM卷	大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},asm_diskname_total,{#ASMVOLUME}]
	使用大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},asm_diskname_used,{#ASMVOLUME}]
	使用百分比	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},asm_volume_use,{#ASMVOLUME}]
表空间	自动扩展使用率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},autousage,{#TABLESPACE}]
	自动扩展开启情况	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},anto_extensible,{#TABLESPACE}]
	自动扩展最大空间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},anto_extensible_max,{#TABLESPACE}]
	目前总空间大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},tab_cur_total_space,{#TABLESPACE}]
	的使用百分比	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},tablespace,{#TABLESPACE}]
	的使用大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},tablespace_user_size,{#TABLESPACE}]
常规	活跃用户数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},activeusercount]
	事件的总等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},bufbusywaits]
	检查活跃和开放状态	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},check_active]
	检查活跃和开放状态	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},check_active]
	归档日志空间使用率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},check_archive,{$ARCHIVE}]
	每秒事务提交数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},commits]
	连接审计	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},connect_audit]
	所有数据文件大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dbfilesize]
	数据库文件并行写等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dbprllwrite]
	数据库文件分散读取等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dbscattread]
	数据库文件顺序读取等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dbseqread]
	用户数据的大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dbsize]
	更新数据文件头信息等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dbsnglwrite]
	死锁数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},deadlocks]
	事件等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},directread]
	磁盘排序比值	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},dsksortratio]
	队列等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},enqueue]
	快速恢复区域使用情况	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},fra_use]
	快速恢复区域使用情况	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},fra_use]
	空闲缓冲区等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},freebufwaits]
	硬解析比值	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},hparsratio]
	快速索引全扫描每秒数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},indexffs]
	已经应用的最新归档日志序号	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},lastapplarclog]
	查询归档日志是否存在	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},lastarclog]
	锁存器空闲等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},latchfree]
	日志文件同步等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},logfilesync]
	连接当前实例的Sessions数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},logonscurrent]
	日志文件并行写入等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},logprllwrite]
	日志文件切换完成等待时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},logswcompletion]
	每秒从客户端接收到的字节数	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},netresv]
	从客户端发送和接收消息的总数	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},netroundtrips]
	发送到客户端的字节数	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},netsent]
	进程最大数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},process_max_number]
	进程最大数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},process_max_number]
	进程数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},process_number]
	查询锁数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_lock]
	查询重做日志数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_redologs]
	查询执行回滚操作时使用的存储空间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_rollbacks]
	查询Sessions数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_sessions]
	session最大数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},session_max]
	数据库CPU时间比	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_sysmetrics,Database_CPU_Time_Ratio]
	数据库等待时间比	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_sysmetrics,Database_Wait_Time_Ratio]
	每秒事务数	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_sysmetrics,User_Transaction_Per_Sec]
	查询TEMP表空间的大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},query_temp]
	缓存读取命中率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},rcachehit]
	每秒redo writes操作数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},redowrites]
	每秒表扫描读取的行数	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},tblrowsscans]
	每秒大表的全表扫描次数	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},tblscans]
	实例运行时间	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},uptime]
	数据库版本	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},version]
	latch命中率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},latch]
	library cache 的命中率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},library_cache]
	sga大小	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},sga_total]
	会话TOP10	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},session_top10]
	慢SQL	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},slow_sql]
	阻塞锁	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},deal_lock]
	实例名	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},instance_name]
	当前游标数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},open_cursor]
	游标最大数量	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},total_cursor]
	日志刷新频率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},log_fresh]
	日志组别	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},log_groups]
	数据文件状态	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},data_file_status]
临时表	临时表使用情况	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},tablespace_temp,{#TABLESPACE_TEMP}]
用户列表	用户状态	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},user_status,{#DBUSER}]
集群状态	Oracle/共享SQL区的使用率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},library_used_ratio]
	Oracle/SGA 命中率	pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},sga_hit_ratio]