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;