应用集 | 监控项说明 | 监控项 | 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] |
|