Github repo: https://github.com/HellScre4m/zabbix-monitoring-templates
Min Zabbix version is prone to change at higher versions. Always check template description before getting new version.
Current supporting Oracle is 11gr2
Feel free to fork/edit/pull request.
1.0 / 4.2+
SuNova
Name | Description | Default | Type |
---|---|---|---|
{$ASM_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
{$BACKUP_DSN} | <p>-</p> | {$DSN} |
Text macro |
{$BLOCK_THRESHOLD} | <p>-</p> | 20 |
Text macro |
{$DB_PASSWORD} | <p>-</p> | zabbix |
Text macro |
{$DB_USERNAME} | <p>-</p> | zabbix |
Text macro |
{$DSN} | <p>-</p> | `` | Text macro |
{$FRA_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
{$MIN_READ_BPS} | <p>-</p> | 10485760 |
Text macro |
{$MIN_WRITE_BPS} | <p>-</p> | 1048576 |
Text macro |
{$ORACLE_BACKUP_HOUR} | <p>-</p> | 0 |
Text macro |
{$TB_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
There are no template links in this template.
Name | Description | Type | Key and additional info |
---|---|---|---|
Blocking session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[blocking sessions discovery,{$DSN}]<p>Update: 5m</p> |
ASM disk discovery | <p>-</p> | Database monitor |
db.odbc.discovery[ASM Disk Discovery,{$DSN}]<p>Update: 1m</p> |
Active session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[active session discovery,{$DSN}]<p>Update: 5m</p> |
Archive destination discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Archive destination discovery,{$DSN}]<p>Update: 1h</p> |
Top lasting SQLs discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Top lasting SQLs discovery,{$DSN}]<p>Update: 5m</p> |
Waiting session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[waiting session discovery,{$DSN}]<p>Update: 5m</p> |
Flash Recovery Area Discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Flash Recovery Area Discovery,{$DSN}]<p>Update: 5m</p> |
Tablespace discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Tablespace Discovery,{$DSN}]<p>Update: 1h</p> |
Schema discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Schema Discovery,{$DSN}]<p>Update: 6h</p> |
Scheduler jobs discovery | <p>-</p> | Database monitor |
db.odbc.discovery[job discovery,{$DSN}]<p>Update: 5m</p> |
Name | Description | Type | Key and additional info |
---|---|---|---|
Cursor Cache Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Cursor Cache Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Physical Writes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Writes Per Sec,{$DSN}]<p>Update: 5m</p> |
PGA Cache Hit % | <p>-</p> | Database monitor |
db.odbc.select[PGA Cache Hit Percentage,{$DSN}]<p>Update: 5m</p> |
Database CPU Time Ratio | <p>-</p> | Database monitor |
db.odbc.select[Database CPU Time Ratio,{$DSN}]<p>Update: 5m</p> |
Database lock count | <p>-</p> | Database monitor |
db.odbc.select[Database lock count,{$DSN}]<p>Update: 5m</p> |
Database session count | <p>-</p> | Database monitor |
db.odbc.select[db session count,{$DSN}]<p>Update: 5m</p> |
Instance CPU count | <p>-</p> | Database monitor |
db.odbc.select[Instance CPU count,{$DSN}]<p>Update: 1h</p> |
Waiting sessions count | <p>-</p> | Database monitor |
db.odbc.select[Waiting sessions count,{$DSN}]<p>Update: 5m</p> |
Buffer Cache Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Buffer Cache Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Session blockers count | <p>-</p> | Database monitor |
db.odbc.select[session blockers count,{$DSN}]<p>Update: 5m</p> |
Soft Parse Ratio | <p>-</p> | Database monitor |
db.odbc.select[Soft Parse Ratio,{$DSN}]<p>Update: 5m</p> |
Physical reads direct per sec | <p>-</p> | Database monitor |
db.odbc.select[Physical reads direct per sec,{$DSN}]<p>Update: 5m</p> |
Archived log Primary-Standby gap | <p>-</p> | Database monitor |
db.odbc.select[archive log gap,{$DSN}]<p>Update: 10m</p> |
Maximum sessions | <p>-</p> | Database monitor |
db.odbc.select[max number of sessions,{$DSN}]<p>Update: 1h</p> |
Shared Pool Free % | <p>-</p> | Database monitor |
db.odbc.select[Shared Pool Free %,{$DSN}]<p>Update: 5m</p> |
Blocked sessions count | <p>-</p> | Database monitor |
db.odbc.select[Blocked sessions count,{$DSN}]<p>Update: 5m</p> |
Redo Allocation Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Redo Allocation Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Physical Write Bytes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Write Bytes Per Sec,{$DSN}]<p>Update: 2m</p> |
Instance status | <p>-</p> | Database monitor |
db.odbc.select[Instance Status,{$DSN}]<p>Update: 60</p> |
Global DB name | <p>-</p> | Database monitor |
db.odbc.select[global_db_name,{$DSN}]<p>Update: 1d</p> |
Last 24h backup details | <p>when status = ‘COMPLETED’ then 1 when status = ‘FAILED’ then -1 when status like ‘WITH WARNINGS’ then 2 when status like ‘WITH ERRORS’ then 3 else 0</p> | Database monitor |
db.odbc.select[backup status,{$BACKUP_DSN}]<p>Update: 1h</p> |
Instance name | <p>-</p> | Database monitor |
db.odbc.select[instance_name,{$DSN}]<p>Update: 1d</p> |
Long table scans per sec | <p>-</p> | Database monitor |
db.odbc.select[Long Table Scans Per Sec,{$DSN}]<p>Update: 5m</p> |
Physical writes direct per sec | <p>-</p> | Database monitor |
db.odbc.select[Physical writes direct per sec,{$DSN}]<p>Update: 5m</p> |
Max applied archived log | <p>-</p> | Database monitor |
db.odbc.select[max applied archived log,{$DSN}]<p>Update: 5m</p> |
Physical Reads Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Reads Per Sec,{$DSN}]<p>Update: 5m</p> |
Max archived log | <p>-</p> | Database monitor |
db.odbc.select[max archived log,{$DSN}]<p>Update: 5m</p> |
Physical reads direct temporary tablespace per sec | <p>-</p> | Database monitor |
db.odbc.select[physical reads direct temporary tablespace per sec,{$DSN}]<p>Update: 5m</p> |
Physical Read Bytes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Read Bytes Per Sec,{$DSN}]<p>Update: 2m</p> |
Maximum processes | <p>-</p> | Database monitor |
db.odbc.select[max number of processes,{$DSN}]<p>Update: 1h</p> |
Host CPU Utilization % | <p>-</p> | Database monitor |
db.odbc.select[Host CPU Utilization,{$DSN}]<p>Update: 5m</p> |
Total wait time on Blocking session: {#SID} | <p>-</p> | Database monitor |
db.odbc.select[waiting time - {#SID},{$DSN}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: mode status | <p>when ‘OFFLINE’ then 0 when ‘ONLINE’ then 1</p> | Calculated |
oracle.asm.disk.mode_status[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: mount status | <p>when ‘MISSING’ then -3 when ‘CLOSED’ then -2 when ‘CLOSING’ then -1 when ‘IGNORED’ then 0 when ‘OPENED’ then 1 when ‘CACHED’ then 2</p> | Calculated |
oracle.asm.disk.mount_status[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: state | <p>when ‘NORMAL’ then 1 when ‘UNKNOWN’ then 0 when ‘ADDING’ then 2 when ‘DROPPING’ then 3 when ‘HUNG’ then -1 when ‘FORCING’ then -2</p> | Calculated |
oracle.asm.disk.state[{#DISK_NAME}]<p>Update: 1m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: total space | <p>-</p> | Calculated |
oracle.asm.disk.total_space[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: free space | <p>-</p> | Calculated |
oracle.db.disk.free_space[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: pct free | <p>-</p> | Calculated |
oracle.db.disk.pct_free[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} CPU used in seconds | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} CPU time,{$DSN}]<p>Update: 2m</p><p>LLD</p> |
Session {#SID} SQL ID | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} SQL ID,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} username | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} username,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} change in CPU time per sec | <p>-</p> | Dependent item |
oracle.db.session.cpu_time_change[{#SID}]<p>Update: 0</p><p>LLD</p> |
Destination {#DEST_ID} status | <p>‘VALID’ 1 ‘INACTIVE’ 2 ‘DEFERRED’ 3 ‘ERROR’ 4 ‘DISABLED’ 5 ‘BAD PARAM’ 6 ‘ALTERNATE’ 7 ‘FULL’ 8 else -1</p> | Database monitor |
db.odbc.select[Dest {#DEST_ID} status. {#DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} bind variables | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} bind variables,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} CPU time | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} CPU time,{$DSN}]<p>Update: 2m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} parsing schema | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} parsing schema,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical read bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical read bytes,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical write bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical write bytes,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} plan | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} plan,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} text | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} text,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID} total CPU time | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total CPU time,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Top SQL {#SQL_ID} total physical read bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total physical read bytes,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Top SQL {#SQL_ID} total physical write bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total physical write bytes,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Session {#SID} total wait time in seconds | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} wait time,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
FRA: {#NAME}: pct_used | <p>-</p> | Calculated |
db.oracle.fra.pct_used[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
FRA: {#NAME}: size | <p>-</p> | Calculated |
db.oracle.fra.size[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
FRA: {#NAME}: space_used | <p>-</p> | Calculated |
db.oracle.fra.space_used[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: bigfile | <p>-</p> | Calculated |
db.oracle.tablespace.bigfile[{#TABLESPACE_NAME}]<p>Update: 1h</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: contents | <p>-</p> | Calculated |
db.oracle.tablespace.contents[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: max_size | <p>-</p> | Calculated |
db.oracle.tablespace.max_size[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: pct_used | <p>-</p> | Calculated |
db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: size | <p>-</p> | Calculated |
db.oracle.tablespace.size[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Schema {#OWNER}: size | <p>SIze of the schema.</p> | Database monitor |
db.odbc.select[Schema {#OWNER} size,{$DSN}]<p>Update: 1h</p><p>LLD</p> |
Name | Description | Expression | Priority |
---|---|---|---|
Session {#SID} is devouring CPU! | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[Host CPU Utilization,].last()}>=60 and {Oracle DB:db.odbc.select[session {#SID} CPU time,].last()}>=0.7</p><p>Recovery expression: </p> | high |
Session {#SID} is eating CPU! | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[Host CPU Utilization,].last()}>=60 and {Oracle DB:db.odbc.select[session {#SID} CPU time,].last()}>=0.6</p><p>Recovery expression: </p> | average |
Session {#SID} is hogging CPU! | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[Host CPU Utilization,].last()}>=50 and {Oracle DB:db.odbc.select[session {#SID} CPU time,].last()}>=0.5</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * 1.0 <=5</p><p>Recovery expression: </p> | high |
ASM disk {#DISK_NAME} is => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:oracle.asm.disk.state[{#DISK_NAME}].last()}<>1</p><p>Recovery expression: </p> | disaster |
ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * 1.0 <=15</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * 1.0 <=10</p><p>Recovery expression: </p> | average |
ASM disk {#DISK_NAME} zero free space | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} <=0.01</p><p>Recovery expression: </p> | disaster |
Session {#SID} is an intensive blocker | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[waiting time - {#SID},].last()}>20</p><p>Recovery expression: </p> | warning |
FRA is almost full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * 1.0 >= 95</p><p>Recovery expression: </p> | high |
FRA is full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()}=100</p><p>Recovery expression: </p> | disaster |
FRA space usage is high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * 1.0 >=85</p><p>Recovery expression: </p> | warning |
FRA space usage is very high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * 1.0 >=90</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 95 * 1.0 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | high |
Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()}=100 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} space usage is high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 85 * 1.0 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | warning |
Tablespace {#TABLESPACE_NAME} space usage is very high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 90 * 1.0 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | average |
Long waiting session: {#SID} => {ITEM.LASTVALUE} seconds | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[session {#SID} wait time,].last()}>300</p><p>Recovery expression: </p> | warning |
Session {#SID} is an intensive blocker (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[waiting time - {#SID},].last()}>20</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * 1.0 <=5</p><p>Recovery expression: </p> | high |
ASM disk {#DISK_NAME} is => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:oracle.asm.disk.state[{#DISK_NAME}].last()}<>1</p><p>Recovery expression: </p> | disaster |
ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * 1.0 <=15</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * 1.0 <=10</p><p>Recovery expression: </p> | average |
ASM disk {#DISK_NAME} zero free space (LLD) | <p>-</p> | <p>Expression: {Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} <=0.01</p><p>Recovery expression: </p> | disaster |
Session {#SID} is devouring CPU! (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[Host CPU Utilization,].last()}>=60 and {Oracle DB:db.odbc.select[session {#SID} CPU time,].last()}>=0.7</p><p>Recovery expression: </p> | high |
Session {#SID} is eating CPU! (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[Host CPU Utilization,].last()}>=60 and {Oracle DB:db.odbc.select[session {#SID} CPU time,].last()}>=0.6</p><p>Recovery expression: </p> | average |
Session {#SID} is hogging CPU! (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[Host CPU Utilization,].last()}>=50 and {Oracle DB:db.odbc.select[session {#SID} CPU time,].last()}>=0.5</p><p>Recovery expression: </p> | warning |
Long waiting session: {#SID} => {ITEM.LASTVALUE} seconds (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.odbc.select[session {#SID} wait time,].last()}>300</p><p>Recovery expression: </p> | warning |
FRA is almost full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * 1.0 >= 95</p><p>Recovery expression: </p> | high |
FRA is full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()}=100</p><p>Recovery expression: </p> | disaster |
FRA space usage is high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * 1.0 >=85</p><p>Recovery expression: </p> | warning |
FRA space usage is very high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * 1.0 >=90</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 95 * 1.0 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | high |
Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()}=100 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} space usage is high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 85 * 1.0 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | warning |
Tablespace {#TABLESPACE_NAME} space usage is very high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: {Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 90 * 1.0 and {Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</p><p>Recovery expression: </p> | average |
Github repo: https://github.com/HellScre4m/zabbix-monitoring-templates
Min Zabbix version is prone to change at higher versions. Always check template description before getting new version.
Current supporting Oracle is 11gr2
Feel free to fork/edit/pull request.
1.0 / 4.2+
SuNova
Name | Description | Default | Type |
---|---|---|---|
{$ASM_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
{$BACKUP_DSN} | <p>-</p> | {$DSN} |
Text macro |
{$BLOCK_THRESHOLD} | <p>-</p> | 20 |
Text macro |
{$DB_PASSWORD} | <p>-</p> | zabbix |
Text macro |
{$DB_USERNAME} | <p>-</p> | zabbix |
Text macro |
{$DSN} | <p>-</p> | `` | Text macro |
{$FRA_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
{$MIN_READ_BPS} | <p>-</p> | 10485760 |
Text macro |
{$MIN_WRITE_BPS} | <p>-</p> | 1048576 |
Text macro |
{$ORACLE_BACKUP_HOUR} | <p>-</p> | 0 |
Text macro |
{$TB_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
There are no template links in this template.
Name | Description | Type | Key and additional info |
---|---|---|---|
Scheduler jobs discovery | <p>-</p> | Database monitor |
db.odbc.discovery[job discovery,{$DSN}]<p>Update: 5m</p> |
Blocking session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[blocking sessions discovery,{$DSN}]<p>Update: 5m</p> |
Active session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[active session discovery,{$DSN}]<p>Update: 5m</p> |
ASM disk discovery | <p>-</p> | Database monitor |
db.odbc.discovery[ASM Disk Discovery,{$DSN}]<p>Update: 1m</p> |
Tablespace discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Tablespace Discovery,{$DSN}]<p>Update: 1h</p> |
Schema discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Schema Discovery,{$DSN}]<p>Update: 6h</p> |
Flash Recovery Area Discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Flash Recovery Area Discovery,{$DSN}]<p>Update: 5m</p> |
Waiting session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[waiting session discovery,{$DSN}]<p>Update: 5m</p> |
Archive destination discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Archive destination discovery,{$DSN}]<p>Update: 1h</p> |
Top lasting SQLs discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Top lasting SQLs discovery,{$DSN}]<p>Update: 5m</p> |
Name | Description | Type | Key and additional info |
---|---|---|---|
Physical Writes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Writes Per Sec,{$DSN}]<p>Update: 5m</p> |
Cursor Cache Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Cursor Cache Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Redo Allocation Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Redo Allocation Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Max archived log | <p>-</p> | Database monitor |
db.odbc.select[max archived log,{$DSN}]<p>Update: 5m</p> |
Max applied archived log | <p>-</p> | Database monitor |
db.odbc.select[max applied archived log,{$DSN}]<p>Update: 5m</p> |
Global DB name | <p>-</p> | Database monitor |
db.odbc.select[global_db_name,{$DSN}]<p>Update: 1d</p> |
PGA Cache Hit % | <p>-</p> | Database monitor |
db.odbc.select[PGA Cache Hit Percentage,{$DSN}]<p>Update: 5m</p> |
Physical reads direct temporary tablespace per sec | <p>-</p> | Database monitor |
db.odbc.select[physical reads direct temporary tablespace per sec,{$DSN}]<p>Update: 5m</p> |
Long table scans per sec | <p>-</p> | Database monitor |
db.odbc.select[Long Table Scans Per Sec,{$DSN}]<p>Update: 5m</p> |
Maximum sessions | <p>-</p> | Database monitor |
db.odbc.select[max number of sessions,{$DSN}]<p>Update: 1h</p> |
Maximum processes | <p>-</p> | Database monitor |
db.odbc.select[max number of processes,{$DSN}]<p>Update: 1h</p> |
Last 24h backup details | <p>when status = ‘COMPLETED’ then 1 when status = ‘FAILED’ then -1 when status like ‘WITH WARNINGS’ then 2 when status like ‘WITH ERRORS’ then 3 else 0</p> | Database monitor |
db.odbc.select[backup status,{$BACKUP_DSN}]<p>Update: 1h</p> |
Soft Parse Ratio | <p>-</p> | Database monitor |
db.odbc.select[Soft Parse Ratio,{$DSN}]<p>Update: 5m</p> |
Waiting sessions count | <p>-</p> | Database monitor |
db.odbc.select[Waiting sessions count,{$DSN}]<p>Update: 5m</p> |
Blocked sessions count | <p>-</p> | Database monitor |
db.odbc.select[Blocked sessions count,{$DSN}]<p>Update: 5m</p> |
Physical Reads Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Reads Per Sec,{$DSN}]<p>Update: 5m</p> |
Host CPU Utilization % | <p>-</p> | Database monitor |
db.odbc.select[Host CPU Utilization,{$DSN}]<p>Update: 5m</p> |
Instance CPU count | <p>-</p> | Database monitor |
db.odbc.select[Instance CPU count,{$DSN}]<p>Update: 1h</p> |
Archived log Primary-Standby gap | <p>-</p> | Database monitor |
db.odbc.select[archive log gap,{$DSN}]<p>Update: 10m</p> |
Database lock count | <p>-</p> | Database monitor |
db.odbc.select[Database lock count,{$DSN}]<p>Update: 5m</p> |
Buffer Cache Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Buffer Cache Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Shared Pool Free % | <p>-</p> | Database monitor |
db.odbc.select[Shared Pool Free %,{$DSN}]<p>Update: 5m</p> |
Instance status | <p>-</p> | Database monitor |
db.odbc.select[Instance Status,{$DSN}]<p>Update: 60</p> |
Physical Read Bytes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Read Bytes Per Sec,{$DSN}]<p>Update: 2m</p> |
Session blockers count | <p>-</p> | Database monitor |
db.odbc.select[session blockers count,{$DSN}]<p>Update: 5m</p> |
Database session count | <p>-</p> | Database monitor |
db.odbc.select[db session count,{$DSN}]<p>Update: 5m</p> |
Physical Write Bytes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Write Bytes Per Sec,{$DSN}]<p>Update: 2m</p> |
Database CPU Time Ratio | <p>-</p> | Database monitor |
db.odbc.select[Database CPU Time Ratio,{$DSN}]<p>Update: 5m</p> |
Physical reads direct per sec | <p>-</p> | Database monitor |
db.odbc.select[Physical reads direct per sec,{$DSN}]<p>Update: 5m</p> |
Instance name | <p>-</p> | Database monitor |
db.odbc.select[instance_name,{$DSN}]<p>Update: 1d</p> |
Physical writes direct per sec | <p>-</p> | Database monitor |
db.odbc.select[Physical writes direct per sec,{$DSN}]<p>Update: 5m</p> |
Total wait time on Blocking session: {#SID} | <p>-</p> | Database monitor |
db.odbc.select[waiting time - {#SID},{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} CPU used in seconds | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} CPU time,{$DSN}]<p>Update: 2m</p><p>LLD</p> |
Session {#SID} SQL ID | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} SQL ID,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} username | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} username,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} change in CPU time per sec | <p>-</p> | Dependent item |
oracle.db.session.cpu_time_change[{#SID}]<p>Update: 0</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: mode status | <p>when ‘OFFLINE’ then 0 when ‘ONLINE’ then 1</p> | Calculated |
oracle.asm.disk.mode_status[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: mount status | <p>when ‘MISSING’ then -3 when ‘CLOSED’ then -2 when ‘CLOSING’ then -1 when ‘IGNORED’ then 0 when ‘OPENED’ then 1 when ‘CACHED’ then 2</p> | Calculated |
oracle.asm.disk.mount_status[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: state | <p>when ‘NORMAL’ then 1 when ‘UNKNOWN’ then 0 when ‘ADDING’ then 2 when ‘DROPPING’ then 3 when ‘HUNG’ then -1 when ‘FORCING’ then -2</p> | Calculated |
oracle.asm.disk.state[{#DISK_NAME}]<p>Update: 1m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: total space | <p>-</p> | Calculated |
oracle.asm.disk.total_space[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: free space | <p>-</p> | Calculated |
oracle.db.disk.free_space[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: pct free | <p>-</p> | Calculated |
oracle.db.disk.pct_free[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: bigfile | <p>-</p> | Calculated |
db.oracle.tablespace.bigfile[{#TABLESPACE_NAME}]<p>Update: 1h</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: contents | <p>-</p> | Calculated |
db.oracle.tablespace.contents[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: max_size | <p>-</p> | Calculated |
db.oracle.tablespace.max_size[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: pct_used | <p>-</p> | Calculated |
db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: size | <p>-</p> | Calculated |
db.oracle.tablespace.size[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Schema {#OWNER}: size | <p>SIze of the schema.</p> | Database monitor |
db.odbc.select[Schema {#OWNER} size,{$DSN}]<p>Update: 1h</p><p>LLD</p> |
FRA: {#NAME}: pct_used | <p>-</p> | Calculated |
db.oracle.fra.pct_used[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
FRA: {#NAME}: size | <p>-</p> | Calculated |
db.oracle.fra.size[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
FRA: {#NAME}: space_used | <p>-</p> | Calculated |
db.oracle.fra.space_used[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
Session {#SID} total wait time in seconds | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} wait time,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Destination {#DEST_ID} status | <p>‘VALID’ 1 ‘INACTIVE’ 2 ‘DEFERRED’ 3 ‘ERROR’ 4 ‘DISABLED’ 5 ‘BAD PARAM’ 6 ‘ALTERNATE’ 7 ‘FULL’ 8 else -1</p> | Database monitor |
db.odbc.select[Dest {#DEST_ID} status. {#DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} bind variables | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} bind variables,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} CPU time | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} CPU time,{$DSN}]<p>Update: 2m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} parsing schema | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} parsing schema,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical read bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical read bytes,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical write bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical write bytes,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} plan | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} plan,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} text | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} text,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID} total CPU time | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total CPU time,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Top SQL {#SQL_ID} total physical read bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total physical read bytes,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Top SQL {#SQL_ID} total physical write bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total physical write bytes,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Name | Description | Expression | Priority |
---|---|---|---|
Session {#SID} is devouring CPU! | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.7</p><p>Recovery expression: </p> | high |
Session {#SID} is eating CPU! | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.6</p><p>Recovery expression: </p> | average |
Session {#SID} is hogging CPU! | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=50 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.5</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=5</p><p>Recovery expression: </p> | high |
ASM disk {#DISK_NAME} is => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.asm.disk.state[{#DISK_NAME}])<>1</p><p>Recovery expression: </p> | disaster |
ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=15</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=10</p><p>Recovery expression: </p> | average |
ASM disk {#DISK_NAME} zero free space | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) <=0.01</p><p>Recovery expression: </p> | disaster |
Session {#SID} is an intensive blocker | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[waiting time - {#SID},])>20</p><p>Recovery expression: </p> | warning |
FRA is almost full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >= 95</p><p>Recovery expression: </p> | high |
FRA is full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}])=100</p><p>Recovery expression: </p> | disaster |
FRA space usage is high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=85</p><p>Recovery expression: </p> | warning |
FRA space usage is very high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=90</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 95 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | high |
Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}])=100 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} space usage is high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 85 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | warning |
Tablespace {#TABLESPACE_NAME} space usage is very high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 90 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | average |
Long waiting session: {#SID} => {ITEM.LASTVALUE} seconds | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[session {#SID} wait time,])>300</p><p>Recovery expression: </p> | warning |
Session {#SID} is an intensive blocker (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[waiting time - {#SID},])>20</p><p>Recovery expression: </p> | warning |
Session {#SID} is devouring CPU! (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.7</p><p>Recovery expression: </p> | high |
Session {#SID} is eating CPU! (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.6</p><p>Recovery expression: </p> | average |
Session {#SID} is hogging CPU! (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=50 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.5</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=5</p><p>Recovery expression: </p> | high |
ASM disk {#DISK_NAME} is => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.asm.disk.state[{#DISK_NAME}])<>1</p><p>Recovery expression: </p> | disaster |
ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=15</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=10</p><p>Recovery expression: </p> | average |
ASM disk {#DISK_NAME} zero free space (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) <=0.01</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 95 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | high |
Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}])=100 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} space usage is high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 85 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | warning |
Tablespace {#TABLESPACE_NAME} space usage is very high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 90 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | average |
FRA is almost full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >= 95</p><p>Recovery expression: </p> | high |
FRA is full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}])=100</p><p>Recovery expression: </p> | disaster |
FRA space usage is high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=85</p><p>Recovery expression: </p> | warning |
FRA space usage is very high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=90</p><p>Recovery expression: </p> | average |
Long waiting session: {#SID} => {ITEM.LASTVALUE} seconds (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[session {#SID} wait time,])>300</p><p>Recovery expression: </p> | warning |
Github repo: https://github.com/HellScre4m/zabbix-monitoring-templates
Min Zabbix version is prone to change at higher versions. Always check template description before getting new version.
Current supporting Oracle is 11gr2
Feel free to fork/edit/pull request.
1.0 / 4.2+
SuNova
Name | Description | Default | Type |
---|---|---|---|
{$ASM_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
{$BACKUP_DSN} | <p>-</p> | {$DSN} |
Text macro |
{$BLOCK_THRESHOLD} | <p>-</p> | 20 |
Text macro |
{$DB_PASSWORD} | <p>-</p> | zabbix |
Text macro |
{$DB_USERNAME} | <p>-</p> | zabbix |
Text macro |
{$DSN} | <p>-</p> | `` | Text macro |
{$FRA_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
{$MIN_READ_BPS} | <p>-</p> | 10485760 |
Text macro |
{$MIN_WRITE_BPS} | <p>-</p> | 1048576 |
Text macro |
{$ORACLE_BACKUP_HOUR} | <p>-</p> | 0 |
Text macro |
{$TB_USAGE_THRESHOLD} | <p>-</p> | 1.0 |
Text macro |
There are no template links in this template.
Name | Description | Type | Key and additional info |
---|---|---|---|
Scheduler jobs discovery | <p>-</p> | Database monitor |
db.odbc.discovery[job discovery,{$DSN}]<p>Update: 5m</p> |
Blocking session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[blocking sessions discovery,{$DSN}]<p>Update: 5m</p> |
Active session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[active session discovery,{$DSN}]<p>Update: 5m</p> |
ASM disk discovery | <p>-</p> | Database monitor |
db.odbc.discovery[ASM Disk Discovery,{$DSN}]<p>Update: 1m</p> |
Tablespace discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Tablespace Discovery,{$DSN}]<p>Update: 1h</p> |
Schema discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Schema Discovery,{$DSN}]<p>Update: 6h</p> |
Flash Recovery Area Discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Flash Recovery Area Discovery,{$DSN}]<p>Update: 5m</p> |
Waiting session discovery | <p>-</p> | Database monitor |
db.odbc.discovery[waiting session discovery,{$DSN}]<p>Update: 5m</p> |
Archive destination discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Archive destination discovery,{$DSN}]<p>Update: 1h</p> |
Top lasting SQLs discovery | <p>-</p> | Database monitor |
db.odbc.discovery[Top lasting SQLs discovery,{$DSN}]<p>Update: 5m</p> |
Name | Description | Type | Key and additional info |
---|---|---|---|
Physical Writes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Writes Per Sec,{$DSN}]<p>Update: 5m</p> |
Cursor Cache Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Cursor Cache Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Redo Allocation Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Redo Allocation Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Max archived log | <p>-</p> | Database monitor |
db.odbc.select[max archived log,{$DSN}]<p>Update: 5m</p> |
Max applied archived log | <p>-</p> | Database monitor |
db.odbc.select[max applied archived log,{$DSN}]<p>Update: 5m</p> |
Global DB name | <p>-</p> | Database monitor |
db.odbc.select[global_db_name,{$DSN}]<p>Update: 1d</p> |
PGA Cache Hit % | <p>-</p> | Database monitor |
db.odbc.select[PGA Cache Hit Percentage,{$DSN}]<p>Update: 5m</p> |
Physical reads direct temporary tablespace per sec | <p>-</p> | Database monitor |
db.odbc.select[physical reads direct temporary tablespace per sec,{$DSN}]<p>Update: 5m</p> |
Long table scans per sec | <p>-</p> | Database monitor |
db.odbc.select[Long Table Scans Per Sec,{$DSN}]<p>Update: 5m</p> |
Maximum sessions | <p>-</p> | Database monitor |
db.odbc.select[max number of sessions,{$DSN}]<p>Update: 1h</p> |
Maximum processes | <p>-</p> | Database monitor |
db.odbc.select[max number of processes,{$DSN}]<p>Update: 1h</p> |
Last 24h backup details | <p>when status = ‘COMPLETED’ then 1 when status = ‘FAILED’ then -1 when status like ‘WITH WARNINGS’ then 2 when status like ‘WITH ERRORS’ then 3 else 0</p> | Database monitor |
db.odbc.select[backup status,{$BACKUP_DSN}]<p>Update: 1h</p> |
Soft Parse Ratio | <p>-</p> | Database monitor |
db.odbc.select[Soft Parse Ratio,{$DSN}]<p>Update: 5m</p> |
Waiting sessions count | <p>-</p> | Database monitor |
db.odbc.select[Waiting sessions count,{$DSN}]<p>Update: 5m</p> |
Blocked sessions count | <p>-</p> | Database monitor |
db.odbc.select[Blocked sessions count,{$DSN}]<p>Update: 5m</p> |
Physical Reads Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Reads Per Sec,{$DSN}]<p>Update: 5m</p> |
Host CPU Utilization % | <p>-</p> | Database monitor |
db.odbc.select[Host CPU Utilization,{$DSN}]<p>Update: 5m</p> |
Instance CPU count | <p>-</p> | Database monitor |
db.odbc.select[Instance CPU count,{$DSN}]<p>Update: 1h</p> |
Archived log Primary-Standby gap | <p>-</p> | Database monitor |
db.odbc.select[archive log gap,{$DSN}]<p>Update: 10m</p> |
Database lock count | <p>-</p> | Database monitor |
db.odbc.select[Database lock count,{$DSN}]<p>Update: 5m</p> |
Buffer Cache Hit Ratio | <p>-</p> | Database monitor |
db.odbc.select[Buffer Cache Hit Ratio,{$DSN}]<p>Update: 5m</p> |
Shared Pool Free % | <p>-</p> | Database monitor |
db.odbc.select[Shared Pool Free %,{$DSN}]<p>Update: 5m</p> |
Instance status | <p>-</p> | Database monitor |
db.odbc.select[Instance Status,{$DSN}]<p>Update: 60</p> |
Physical Read Bytes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Read Bytes Per Sec,{$DSN}]<p>Update: 2m</p> |
Session blockers count | <p>-</p> | Database monitor |
db.odbc.select[session blockers count,{$DSN}]<p>Update: 5m</p> |
Database session count | <p>-</p> | Database monitor |
db.odbc.select[db session count,{$DSN}]<p>Update: 5m</p> |
Physical Write Bytes Per Sec | <p>-</p> | Database monitor |
db.odbc.select[Physical Write Bytes Per Sec,{$DSN}]<p>Update: 2m</p> |
Database CPU Time Ratio | <p>-</p> | Database monitor |
db.odbc.select[Database CPU Time Ratio,{$DSN}]<p>Update: 5m</p> |
Physical reads direct per sec | <p>-</p> | Database monitor |
db.odbc.select[Physical reads direct per sec,{$DSN}]<p>Update: 5m</p> |
Instance name | <p>-</p> | Database monitor |
db.odbc.select[instance_name,{$DSN}]<p>Update: 1d</p> |
Physical writes direct per sec | <p>-</p> | Database monitor |
db.odbc.select[Physical writes direct per sec,{$DSN}]<p>Update: 5m</p> |
Total wait time on Blocking session: {#SID} | <p>-</p> | Database monitor |
db.odbc.select[waiting time - {#SID},{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} CPU used in seconds | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} CPU time,{$DSN}]<p>Update: 2m</p><p>LLD</p> |
Session {#SID} SQL ID | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} SQL ID,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} username | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} username,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Session {#SID} change in CPU time per sec | <p>-</p> | Dependent item |
oracle.db.session.cpu_time_change[{#SID}]<p>Update: 0</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: mode status | <p>when ‘OFFLINE’ then 0 when ‘ONLINE’ then 1</p> | Calculated |
oracle.asm.disk.mode_status[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: mount status | <p>when ‘MISSING’ then -3 when ‘CLOSED’ then -2 when ‘CLOSING’ then -1 when ‘IGNORED’ then 0 when ‘OPENED’ then 1 when ‘CACHED’ then 2</p> | Calculated |
oracle.asm.disk.mount_status[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: state | <p>when ‘NORMAL’ then 1 when ‘UNKNOWN’ then 0 when ‘ADDING’ then 2 when ‘DROPPING’ then 3 when ‘HUNG’ then -1 when ‘FORCING’ then -2</p> | Calculated |
oracle.asm.disk.state[{#DISK_NAME}]<p>Update: 1m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: total space | <p>-</p> | Calculated |
oracle.asm.disk.total_space[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: free space | <p>-</p> | Calculated |
oracle.db.disk.free_space[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
ASM disk: {#DISK_NAME}: pct free | <p>-</p> | Calculated |
oracle.db.disk.pct_free[{#DISK_NAME}]<p>Update: 5m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: bigfile | <p>-</p> | Calculated |
db.oracle.tablespace.bigfile[{#TABLESPACE_NAME}]<p>Update: 1h</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: contents | <p>-</p> | Calculated |
db.oracle.tablespace.contents[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: max_size | <p>-</p> | Calculated |
db.oracle.tablespace.max_size[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: pct_used | <p>-</p> | Calculated |
db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Tablespace: {#TABLESPACE_NAME}: size | <p>-</p> | Calculated |
db.oracle.tablespace.size[{#TABLESPACE_NAME}]<p>Update: 4m</p><p>LLD</p> |
Schema {#OWNER}: size | <p>SIze of the schema.</p> | Database monitor |
db.odbc.select[Schema {#OWNER} size,{$DSN}]<p>Update: 1h</p><p>LLD</p> |
FRA: {#NAME}: pct_used | <p>-</p> | Calculated |
db.oracle.fra.pct_used[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
FRA: {#NAME}: size | <p>-</p> | Calculated |
db.oracle.fra.size[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
FRA: {#NAME}: space_used | <p>-</p> | Calculated |
db.oracle.fra.space_used[{#NAME}]<p>Update: 4m</p><p>LLD</p> |
Session {#SID} total wait time in seconds | <p>-</p> | Database monitor |
db.odbc.select[session {#SID} wait time,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Destination {#DEST_ID} status | <p>‘VALID’ 1 ‘INACTIVE’ 2 ‘DEFERRED’ 3 ‘ERROR’ 4 ‘DISABLED’ 5 ‘BAD PARAM’ 6 ‘ALTERNATE’ 7 ‘FULL’ 8 else -1</p> | Database monitor |
db.odbc.select[Dest {#DEST_ID} status. {#DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} bind variables | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} bind variables,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} CPU time | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} CPU time,{$DSN}]<p>Update: 2m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} parsing schema | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} parsing schema,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical read bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical read bytes,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical write bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} physical write bytes,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} plan | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} plan,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID}:{#CHILD_ADDRESS} text | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID}:{#CHILD_ADDRESS} text,{$DSN}]<p>Update: 5m</p><p>LLD</p> |
Top SQL {#SQL_ID} total CPU time | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total CPU time,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Top SQL {#SQL_ID} total physical read bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total physical read bytes,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Top SQL {#SQL_ID} total physical write bytes | <p>-</p> | Database monitor |
db.odbc.select[Top SQL {#SQL_ID} total physical write bytes,{$DSN}]<p>Update: 30m</p><p>LLD</p> |
Name | Description | Expression | Priority |
---|---|---|---|
Session {#SID} is devouring CPU! | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.7</p><p>Recovery expression: </p> | high |
Session {#SID} is eating CPU! | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.6</p><p>Recovery expression: </p> | average |
Session {#SID} is hogging CPU! | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=50 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.5</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=5</p><p>Recovery expression: </p> | high |
ASM disk {#DISK_NAME} is => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.asm.disk.state[{#DISK_NAME}])<>1</p><p>Recovery expression: </p> | disaster |
ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=15</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=10</p><p>Recovery expression: </p> | average |
ASM disk {#DISK_NAME} zero free space | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) <=0.01</p><p>Recovery expression: </p> | disaster |
Session {#SID} is an intensive blocker | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[waiting time - {#SID},])>20</p><p>Recovery expression: </p> | warning |
FRA is almost full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >= 95</p><p>Recovery expression: </p> | high |
FRA is full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}])=100</p><p>Recovery expression: </p> | disaster |
FRA space usage is high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=85</p><p>Recovery expression: </p> | warning |
FRA space usage is very high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=90</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 95 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | high |
Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}])=100 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} space usage is high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 85 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | warning |
Tablespace {#TABLESPACE_NAME} space usage is very high => {ITEM.VALUE1} | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 90 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | average |
Long waiting session: {#SID} => {ITEM.LASTVALUE} seconds | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[session {#SID} wait time,])>300</p><p>Recovery expression: </p> | warning |
Session {#SID} is an intensive blocker (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[waiting time - {#SID},])>20</p><p>Recovery expression: </p> | warning |
Session {#SID} is devouring CPU! (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.7</p><p>Recovery expression: </p> | high |
Session {#SID} is eating CPU! (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=60 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.6</p><p>Recovery expression: </p> | average |
Session {#SID} is hogging CPU! (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[Host CPU Utilization,])>=50 and last(/Oracle DB/db.odbc.select[session {#SID} CPU time,])>=0.5</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=5</p><p>Recovery expression: </p> | high |
ASM disk {#DISK_NAME} is => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.asm.disk.state[{#DISK_NAME}])<>1</p><p>Recovery expression: </p> | disaster |
ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=15</p><p>Recovery expression: </p> | warning |
ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) * 1.0 <=10</p><p>Recovery expression: </p> | average |
ASM disk {#DISK_NAME} zero free space (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/oracle.db.disk.pct_free[{#DISK_NAME}]) <=0.01</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 95 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | high |
Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}])=100 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | disaster |
Tablespace {#TABLESPACE_NAME} space usage is high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 85 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | warning |
Tablespace {#TABLESPACE_NAME} space usage is very high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]) >= 90 * 1.0 and last(/Oracle DB/db.oracle.tablespace.contents[{#TABLESPACE_NAME}])=1</p><p>Recovery expression: </p> | average |
FRA is almost full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >= 95</p><p>Recovery expression: </p> | high |
FRA is full => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}])=100</p><p>Recovery expression: </p> | disaster |
FRA space usage is high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=85</p><p>Recovery expression: </p> | warning |
FRA space usage is very high => {ITEM.VALUE1} (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.oracle.fra.pct_used[{#NAME}]) * 1.0 >=90</p><p>Recovery expression: </p> | average |
Long waiting session: {#SID} => {ITEM.LASTVALUE} seconds (LLD) | <p>-</p> | <p>Expression: last(/Oracle DB/db.odbc.select[session {#SID} wait time,])>300</p><p>Recovery expression: </p> | warning |