zabbix监控oracle补充

What can it monitor?

Below are some examples of what Orabbix is capable of monitoring:

  • DB Version (i.e. Validity of package)            //数据库版本
  • Archiving (Archive log production with trend analysis)     //归档
  • Event Waits (Files I/O, single block read, multi-block read, direct path read, SQLNet Messages, Control file I/O, Log Write)   //等待事件
  • Hit Ratio (Hit Ratio on Triggers, Tables/Procedures, SQL Area, Body)     //命中率
  • Logical I/O (Server performance on Logical I/O of: Current Read, Consistent Read, Block Change)    //逻辑I/O
  • Physical I/O (Redo Writes, Datafile Writes, Datafile Reads)     //物理I/O
  • PGA
  • SGA (In particular; Fixed Buffer, Java Pool, Large Pool, Log Buffer, Shared Poolm Buffer Cache)
  • Shared Pool (Pool Dictionary Cache, Pool Free Memory, Library Chache, SQL Area, MISC.)     //共享池
  • Pin Hit Ratio (Oracle library cache pin are caused by contention with the library cache, the area used to store SQL executables for re-use)      //pin命中率
  • Sessions / Processes     //会话/过程
  • Sessions (Active Sessions, Inactive Sessions, System Sessions)    //会话
  • DBSize/DBFileSize (DBSize size of database really used space and of Filesize)     //数据库大小/文件大小

11g还需要执行下面2个plsql

 exec dbms_network_acl_admin.create_acl(acl => 'resolve.xml',description => 'resolve acl', principal =>'ZABBIX', is_grant => true, privilege => 'resolve');
 exec dbms_network_acl_admin.assign_acl(acl => 'resolve.xml', host =>'*');
 commit;
posted @ 2017-10-23 21:26  独家小K  阅读(292)  评论(0编辑  收藏  举报