Oracle(通用版)监控项

[复制链接]
lewei 发表于 2020-7-31 16:41:23 | 显示全部楼层 |阅读模式 打印 上一主题 下一主题
应用集监控项说明监控项
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]
会话TOP10pyora[{$USERNAME},{$PASSWORD},{$ADDRESS},{$DATABASE},session_top10]
慢SQLpyora[{$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]

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关注0

粉丝0

帖子110

发布主题

乐维社区

微信公众号

版权所有 © 2016-2021 九一乐维丨粤ICP备17007026号