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>
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;
页:
[1]