zabbix监控oracle补充

515439429

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>
  

　　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;