This is the fixed template for Zabbix PyOra to work on 3.0. I remove the unsupported tags and downgraded version. Note you will most likely have to update the triggers manually.
Name | Description | Default | Type |
---|---|---|---|
{$ASMHIGH} | <p>-</p> | 85 |
Text macro |
{$DATABASE} | <p>-</p> | `` | Text macro |
{$HIGH} | <p>-</p> | 80 |
Text macro |
{$ZABBIXPASSWORD} | <p>-</p> | `` | Text macro |
{$ZABBIXURL} | <p>-</p> | `` | Text macro |
{$ZABBIXUSER} | <p>-</p> | `` | Text macro |
There are no template links in this template.
Name | Description | Type | Key and additional info |
---|---|---|---|
Discovery Oracle temp tablespaces | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces_temp]<p>Update: 3600</p> |
Discovery Oracle tablespaces | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces]<p>Update: 3600</p> |
Discovery Oracle ASM volumes | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_asm_volumes]<p>Update: 3600</p> |
Discovery Oracle users | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_users]<p>Update: 3600</p> |
Name | Description | Type | Key and additional info |
---|---|---|---|
Oracle/User Commits on {$DATABASE} | <p>-</p> | Zabbix trapper |
commits<p>Update: 0</p> |
Oracle/Latchfree on {$DATABASE} | <p>-</p> | Zabbix trapper |
latchfree<p>Update: 0</p> |
Oracle/Read Cache hit ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
rcachehit<p>Update: 0</p> |
Oracle/dbsnglwrite {$DATABASE} | <p>-</p> | Zabbix trapper |
dbsnglwrite<p>Update: 0</p> |
Oracle/Active user count on {$DATABASE} | <p>-</p> | Zabbix trapper |
activeusercount<p>Update: 0</p> |
Oracle/Index fast full scans (full) on {$DATABASE} | <p>-</p> | Zabbix trapper |
indexffs<p>Update: 0</p> |
Oracle/Enqueue on {$DATABASE} | <p>-</p> | Zabbix trapper |
enqueue<p>Update: 0</p> |
Query Lock list on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_lock_list2<p>Update: 0</p> |
Oracle/Table scans (long tables) on {$DATABASE} | <p>-</p> | Zabbix trapper |
tblscans<p>Update: 0</p> |
Oracle/dbprllwrite on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbprllwrite<p>Update: 0</p> |
Oracle/Deadlocks on {$DATABASE} | <p>-</p> | Zabbix trapper |
deadlocks<p>Update: 0</p> |
Oracle/Disk sorts ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
dsksortratio<p>Update: 0</p> |
Oracle/Netresv on {$DATABASE} | <p>-</p> | Zabbix trapper |
netresv<p>Update: 0</p> |
Oracle/Archive {$ARCHIVE} on {$DATABASE} | <p>-</p> | Zabbix trapper |
check_archive[{$ARCHIVE}]<p>Update: 0</p> |
Oracle/Logonscurrent on {$DATABASE} | <p>-</p> | Zabbix trapper |
logonscurrent<p>Update: 0</p> |
Zabbix failed checks on {$DATABASE} | <p>-</p> | Zabbix trapper |
failedchecks<p>Update: 0</p> |
Oracle/fra_use on {$DATABASE} | <p>-</p> | Zabbix trapper |
fra_use<p>Update: 0</p> |
Oracle/Uptime on {$DATABASE} | <p>-</p> | Zabbix trapper |
uptime<p>Update: 0</p> |
Oracle/Hard parse ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
hparsratio<p>Update: 0</p> |
Zabbix items list | <p>-</p> | Zabbix agent |
pyora-items-list[{$ZABBIXURL},{$ZABBIXUSER},{$ZABBIXPASSWORD},{HOST.HOST},{$ADDRESS},{$DATABASE}]<p>Update: 3600</p> |
Oracle/Lastarclog on {$DATABASE} | <p>-</p> | Zabbix trapper |
lastarclog<p>Update: 0</p> |
Oracle/Logfilesync on {$DATABASE} | <p>-</p> | Zabbix trapper |
logfilesync<p>Update: 0</p> |
Oracle/Logprllwrite on {$DATABASE} | <p>-</p> | Zabbix trapper |
logprllwrite<p>Update: 0</p> |
Oracle/Query Rollbacks on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_rollbacks<p>Update: 0</p> |
Oracle/Size of user data (without temp) on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbsize<p>Update: 0</p> |
Oracle/dbseqread on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbseqread<p>Update: 0</p> |
Oracle/Query Redologs on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_redologs<p>Update: 0</p> |
Oracle/Size of all datafiles on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbfilesize<p>Update: 0</p> |
Oracle/Query Lock on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_lock<p>Update: 0</p> |
Oracle/Netsent on {$DATABASE} | <p>-</p> | Zabbix trapper |
netsent<p>Update: 0</p> |
Oracle/Redo Writes on {$DATABASE} | <p>-</p> | Zabbix trapper |
redowrites<p>Update: 0</p> |
Oracle/Table scan rows gotten on {$DATABASE} | <p>-</p> | Zabbix trapper |
tblrowsscans<p>Update: 0</p> |
Oracle/Query Sessions on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sessions<p>Update: 0</p> |
Oracle/Instance is active and open on {$DATABASE} | <p>-</p> | Zabbix trapper |
check_active<p>Update: 0</p> |
Oracle/Directread on {$DATABASE} | <p>-</p> | Zabbix trapper |
directread<p>Update: 0</p> |
Oracle/Logswcompletion on {$DATABASE} | <p>-</p> | Zabbix trapper |
logswcompletion<p>Update: 0</p> |
Oracle/Database CPU Time Ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[Database_CPU_Time_Ratio]<p>Update: 0</p> |
Oracle/User Transaction Per Sec on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[User_Transaction_Per_Sec]<p>Update: 0</p> |
Oracle/Lastapplarclog on {$DATABASE} | <p>-</p> | Zabbix trapper |
lastapplarclog<p>Update: 0</p> |
Oracle/dbscattread on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbscattread<p>Update: 0</p> |
Oracle/Buffer busy waits on {$DATABASE} | <p>-</p> | Zabbix trapper |
bufbusywaits<p>Update: 0</p> |
Oracle/Netroundtrips on {$DATABASE} | <p>-</p> | Zabbix trapper |
netroundtrips<p>Update: 0</p> |
Oracle/Version on {$DATABASE} | <p>-</p> | Zabbix trapper |
version<p>Update: 0</p> |
Oracle/freebufwaits on {$DATABASE} | <p>-</p> | Zabbix trapper |
freebufwaits<p>Update: 0</p> |
Oracle/Database Wait Time Ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[Database_Wait_Time_Ratio]<p>Update: 0</p> |
Temp Tablespace Use on {#TABLESPACE_TEMP} | <p>-</p> | Zabbix trapper |
tablespace_temp[{#TABLESPACE_TEMP}]<p>Update: 0</p><p>LLD</p> |
Tablespace percentual use on {#TABLESPACE} | <p>-</p> | Zabbix trapper |
tablespace[{#TABLESPACE}]<p>Update: 0</p><p>LLD</p> |
Tablespace free on {#TABLESPACE} | <p>-</p> | Zabbix trapper |
tablespace_abs[{#TABLESPACE}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Free on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_free[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Size on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_size[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Use on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_use[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
{#DBUSER} user status | <p>-</p> | Zabbix trapper |
user_status[{#DBUSER}]<p>Update: 0</p><p>LLD</p> |
Name | Description | Expression | Priority |
---|---|---|---|
ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1}) | <p>-</p> | <p>Expression: ({Pyora active send:asm_volume_size[{#ASMVOLUME}].last()} - {Pyora active send:asm_volume_free[{#ASMVOLUME}].last()}) / {Pyora active send:asm_volume_size[{#ASMVOLUME}].last()} *100 > 85</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} % | <p>-</p> | <p>Expression: {Pyora active send:tablespace[{#TABLESPACE}].last()}>80</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} % (LLD) | <p>-</p> | <p>Expression: {Pyora active send:tablespace[{#TABLESPACE}].last()}>80</p><p>Recovery expression: </p> | average |
ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1}) (LLD) | <p>-</p> | <p>Expression: ({Pyora active send:asm_volume_size[{#ASMVOLUME}].last()} - {Pyora active send:asm_volume_free[{#ASMVOLUME}].last()}) / {Pyora active send:asm_volume_size[{#ASMVOLUME}].last()} *100 > 85</p><p>Recovery expression: </p> | average |
This is the fixed template for Zabbix PyOra to work on 3.0. I remove the unsupported tags and downgraded version. Note you will most likely have to update the triggers manually.
Name | Description | Default | Type |
---|---|---|---|
{$ASMHIGH} | <p>-</p> | 85 |
Text macro |
{$DATABASE} | <p>-</p> | `` | Text macro |
{$HIGH} | <p>-</p> | 80 |
Text macro |
{$ZABBIXPASSWORD} | <p>-</p> | `` | Text macro |
{$ZABBIXURL} | <p>-</p> | `` | Text macro |
{$ZABBIXUSER} | <p>-</p> | `` | Text macro |
There are no template links in this template.
Name | Description | Type | Key and additional info |
---|---|---|---|
Discovery Oracle users | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_users]<p>Update: 3600</p> |
Discovery Oracle ASM volumes | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_asm_volumes]<p>Update: 3600</p> |
Discovery Oracle tablespaces | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces]<p>Update: 3600</p> |
Discovery Oracle temp tablespaces | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces_temp]<p>Update: 3600</p> |
Name | Description | Type | Key and additional info |
---|---|---|---|
Query Lock list on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_lock_list2<p>Update: 0</p> |
Oracle/Uptime on {$DATABASE} | <p>-</p> | Zabbix trapper |
uptime<p>Update: 0</p> |
Oracle/Buffer busy waits on {$DATABASE} | <p>-</p> | Zabbix trapper |
bufbusywaits<p>Update: 0</p> |
Oracle/Lastarclog on {$DATABASE} | <p>-</p> | Zabbix trapper |
lastarclog<p>Update: 0</p> |
Oracle/Active user count on {$DATABASE} | <p>-</p> | Zabbix trapper |
activeusercount<p>Update: 0</p> |
Oracle/Netsent on {$DATABASE} | <p>-</p> | Zabbix trapper |
netsent<p>Update: 0</p> |
Oracle/Hard parse ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
hparsratio<p>Update: 0</p> |
Oracle/Database CPU Time Ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[Database_CPU_Time_Ratio]<p>Update: 0</p> |
Oracle/Redo Writes on {$DATABASE} | <p>-</p> | Zabbix trapper |
redowrites<p>Update: 0</p> |
Oracle/dbscattread on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbscattread<p>Update: 0</p> |
Oracle/Logprllwrite on {$DATABASE} | <p>-</p> | Zabbix trapper |
logprllwrite<p>Update: 0</p> |
Oracle/Instance is active and open on {$DATABASE} | <p>-</p> | Zabbix trapper |
check_active<p>Update: 0</p> |
Oracle/Netresv on {$DATABASE} | <p>-</p> | Zabbix trapper |
netresv<p>Update: 0</p> |
Oracle/Table scan rows gotten on {$DATABASE} | <p>-</p> | Zabbix trapper |
tblrowsscans<p>Update: 0</p> |
Oracle/Index fast full scans (full) on {$DATABASE} | <p>-</p> | Zabbix trapper |
indexffs<p>Update: 0</p> |
Oracle/dbseqread on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbseqread<p>Update: 0</p> |
Zabbix items list | <p>-</p> | Zabbix agent |
pyora-items-list[{$ZABBIXURL},{$ZABBIXUSER},{$ZABBIXPASSWORD},{HOST.HOST},{$ADDRESS},{$DATABASE}]<p>Update: 3600</p> |
Oracle/Enqueue on {$DATABASE} | <p>-</p> | Zabbix trapper |
enqueue<p>Update: 0</p> |
Oracle/dbprllwrite on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbprllwrite<p>Update: 0</p> |
Oracle/Query Lock on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_lock<p>Update: 0</p> |
Oracle/Database Wait Time Ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[Database_Wait_Time_Ratio]<p>Update: 0</p> |
Oracle/Logfilesync on {$DATABASE} | <p>-</p> | Zabbix trapper |
logfilesync<p>Update: 0</p> |
Oracle/Disk sorts ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
dsksortratio<p>Update: 0</p> |
Oracle/Logswcompletion on {$DATABASE} | <p>-</p> | Zabbix trapper |
logswcompletion<p>Update: 0</p> |
Oracle/Lastapplarclog on {$DATABASE} | <p>-</p> | Zabbix trapper |
lastapplarclog<p>Update: 0</p> |
Oracle/Size of user data (without temp) on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbsize<p>Update: 0</p> |
Oracle/Directread on {$DATABASE} | <p>-</p> | Zabbix trapper |
directread<p>Update: 0</p> |
Oracle/fra_use on {$DATABASE} | <p>-</p> | Zabbix trapper |
fra_use<p>Update: 0</p> |
Oracle/Query Redologs on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_redologs<p>Update: 0</p> |
Oracle/Table scans (long tables) on {$DATABASE} | <p>-</p> | Zabbix trapper |
tblscans<p>Update: 0</p> |
Oracle/User Transaction Per Sec on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[User_Transaction_Per_Sec]<p>Update: 0</p> |
Oracle/Query Sessions on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sessions<p>Update: 0</p> |
Oracle/Deadlocks on {$DATABASE} | <p>-</p> | Zabbix trapper |
deadlocks<p>Update: 0</p> |
Oracle/User Commits on {$DATABASE} | <p>-</p> | Zabbix trapper |
commits<p>Update: 0</p> |
Oracle/Read Cache hit ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
rcachehit<p>Update: 0</p> |
Oracle/Netroundtrips on {$DATABASE} | <p>-</p> | Zabbix trapper |
netroundtrips<p>Update: 0</p> |
Oracle/Latchfree on {$DATABASE} | <p>-</p> | Zabbix trapper |
latchfree<p>Update: 0</p> |
Oracle/dbsnglwrite {$DATABASE} | <p>-</p> | Zabbix trapper |
dbsnglwrite<p>Update: 0</p> |
Oracle/Logonscurrent on {$DATABASE} | <p>-</p> | Zabbix trapper |
logonscurrent<p>Update: 0</p> |
Oracle/Size of all datafiles on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbfilesize<p>Update: 0</p> |
Oracle/Query Rollbacks on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_rollbacks<p>Update: 0</p> |
Oracle/freebufwaits on {$DATABASE} | <p>-</p> | Zabbix trapper |
freebufwaits<p>Update: 0</p> |
Oracle/Archive {$ARCHIVE} on {$DATABASE} | <p>-</p> | Zabbix trapper |
check_archive[{$ARCHIVE}]<p>Update: 0</p> |
Oracle/Version on {$DATABASE} | <p>-</p> | Zabbix trapper |
version<p>Update: 0</p> |
Zabbix failed checks on {$DATABASE} | <p>-</p> | Zabbix trapper |
failedchecks<p>Update: 0</p> |
{#DBUSER} user status | <p>-</p> | Zabbix trapper |
user_status[{#DBUSER}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Free on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_free[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Size on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_size[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Use on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_use[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
Tablespace percentual use on {#TABLESPACE} | <p>-</p> | Zabbix trapper |
tablespace[{#TABLESPACE}]<p>Update: 0</p><p>LLD</p> |
Tablespace free on {#TABLESPACE} | <p>-</p> | Zabbix trapper |
tablespace_abs[{#TABLESPACE}]<p>Update: 0</p><p>LLD</p> |
Temp Tablespace Use on {#TABLESPACE_TEMP} | <p>-</p> | Zabbix trapper |
tablespace_temp[{#TABLESPACE_TEMP}]<p>Update: 0</p><p>LLD</p> |
Name | Description | Expression | Priority |
---|---|---|---|
ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1}) | <p>-</p> | <p>Expression: (last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) - last(/Pyora active send/asm_volume_free[{#ASMVOLUME}])) / last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) *100 > 85</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} % | <p>-</p> | <p>Expression: last(/Pyora active send/tablespace[{#TABLESPACE}])>80</p><p>Recovery expression: </p> | average |
ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1}) (LLD) | <p>-</p> | <p>Expression: (last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) - last(/Pyora active send/asm_volume_free[{#ASMVOLUME}])) / last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) *100 > 85</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} % (LLD) | <p>-</p> | <p>Expression: last(/Pyora active send/tablespace[{#TABLESPACE}])>80</p><p>Recovery expression: </p> | average |
This is the fixed template for Zabbix PyOra to work on 3.0. I remove the unsupported tags and downgraded version. Note you will most likely have to update the triggers manually.
Name | Description | Default | Type |
---|---|---|---|
{$ASMHIGH} | <p>-</p> | 85 |
Text macro |
{$DATABASE} | <p>-</p> | `` | Text macro |
{$HIGH} | <p>-</p> | 80 |
Text macro |
{$ZABBIXPASSWORD} | <p>-</p> | `` | Text macro |
{$ZABBIXURL} | <p>-</p> | `` | Text macro |
{$ZABBIXUSER} | <p>-</p> | `` | Text macro |
There are no template links in this template.
Name | Description | Type | Key and additional info |
---|---|---|---|
Discovery Oracle users | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_users]<p>Update: 3600</p> |
Discovery Oracle ASM volumes | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_asm_volumes]<p>Update: 3600</p> |
Discovery Oracle tablespaces | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces]<p>Update: 3600</p> |
Discovery Oracle temp tablespaces | <p>-</p> | Zabbix agent |
pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces_temp]<p>Update: 3600</p> |
Name | Description | Type | Key and additional info |
---|---|---|---|
Query Lock list on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_lock_list2<p>Update: 0</p> |
Oracle/Uptime on {$DATABASE} | <p>-</p> | Zabbix trapper |
uptime<p>Update: 0</p> |
Oracle/Buffer busy waits on {$DATABASE} | <p>-</p> | Zabbix trapper |
bufbusywaits<p>Update: 0</p> |
Oracle/Lastarclog on {$DATABASE} | <p>-</p> | Zabbix trapper |
lastarclog<p>Update: 0</p> |
Oracle/Active user count on {$DATABASE} | <p>-</p> | Zabbix trapper |
activeusercount<p>Update: 0</p> |
Oracle/Netsent on {$DATABASE} | <p>-</p> | Zabbix trapper |
netsent<p>Update: 0</p> |
Oracle/Hard parse ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
hparsratio<p>Update: 0</p> |
Oracle/Database CPU Time Ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[Database_CPU_Time_Ratio]<p>Update: 0</p> |
Oracle/Redo Writes on {$DATABASE} | <p>-</p> | Zabbix trapper |
redowrites<p>Update: 0</p> |
Oracle/dbscattread on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbscattread<p>Update: 0</p> |
Oracle/Logprllwrite on {$DATABASE} | <p>-</p> | Zabbix trapper |
logprllwrite<p>Update: 0</p> |
Oracle/Instance is active and open on {$DATABASE} | <p>-</p> | Zabbix trapper |
check_active<p>Update: 0</p> |
Oracle/Netresv on {$DATABASE} | <p>-</p> | Zabbix trapper |
netresv<p>Update: 0</p> |
Oracle/Table scan rows gotten on {$DATABASE} | <p>-</p> | Zabbix trapper |
tblrowsscans<p>Update: 0</p> |
Oracle/Index fast full scans (full) on {$DATABASE} | <p>-</p> | Zabbix trapper |
indexffs<p>Update: 0</p> |
Oracle/dbseqread on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbseqread<p>Update: 0</p> |
Zabbix items list | <p>-</p> | Zabbix agent |
pyora-items-list[{$ZABBIXURL},{$ZABBIXUSER},{$ZABBIXPASSWORD},{HOST.HOST},{$ADDRESS},{$DATABASE}]<p>Update: 3600</p> |
Oracle/Enqueue on {$DATABASE} | <p>-</p> | Zabbix trapper |
enqueue<p>Update: 0</p> |
Oracle/dbprllwrite on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbprllwrite<p>Update: 0</p> |
Oracle/Query Lock on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_lock<p>Update: 0</p> |
Oracle/Database Wait Time Ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[Database_Wait_Time_Ratio]<p>Update: 0</p> |
Oracle/Logfilesync on {$DATABASE} | <p>-</p> | Zabbix trapper |
logfilesync<p>Update: 0</p> |
Oracle/Disk sorts ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
dsksortratio<p>Update: 0</p> |
Oracle/Logswcompletion on {$DATABASE} | <p>-</p> | Zabbix trapper |
logswcompletion<p>Update: 0</p> |
Oracle/Lastapplarclog on {$DATABASE} | <p>-</p> | Zabbix trapper |
lastapplarclog<p>Update: 0</p> |
Oracle/Size of user data (without temp) on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbsize<p>Update: 0</p> |
Oracle/Directread on {$DATABASE} | <p>-</p> | Zabbix trapper |
directread<p>Update: 0</p> |
Oracle/fra_use on {$DATABASE} | <p>-</p> | Zabbix trapper |
fra_use<p>Update: 0</p> |
Oracle/Query Redologs on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_redologs<p>Update: 0</p> |
Oracle/Table scans (long tables) on {$DATABASE} | <p>-</p> | Zabbix trapper |
tblscans<p>Update: 0</p> |
Oracle/User Transaction Per Sec on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sysmetrics[User_Transaction_Per_Sec]<p>Update: 0</p> |
Oracle/Query Sessions on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_sessions<p>Update: 0</p> |
Oracle/Deadlocks on {$DATABASE} | <p>-</p> | Zabbix trapper |
deadlocks<p>Update: 0</p> |
Oracle/User Commits on {$DATABASE} | <p>-</p> | Zabbix trapper |
commits<p>Update: 0</p> |
Oracle/Read Cache hit ratio on {$DATABASE} | <p>-</p> | Zabbix trapper |
rcachehit<p>Update: 0</p> |
Oracle/Netroundtrips on {$DATABASE} | <p>-</p> | Zabbix trapper |
netroundtrips<p>Update: 0</p> |
Oracle/Latchfree on {$DATABASE} | <p>-</p> | Zabbix trapper |
latchfree<p>Update: 0</p> |
Oracle/dbsnglwrite {$DATABASE} | <p>-</p> | Zabbix trapper |
dbsnglwrite<p>Update: 0</p> |
Oracle/Logonscurrent on {$DATABASE} | <p>-</p> | Zabbix trapper |
logonscurrent<p>Update: 0</p> |
Oracle/Size of all datafiles on {$DATABASE} | <p>-</p> | Zabbix trapper |
dbfilesize<p>Update: 0</p> |
Oracle/Query Rollbacks on {$DATABASE} | <p>-</p> | Zabbix trapper |
query_rollbacks<p>Update: 0</p> |
Oracle/freebufwaits on {$DATABASE} | <p>-</p> | Zabbix trapper |
freebufwaits<p>Update: 0</p> |
Oracle/Archive {$ARCHIVE} on {$DATABASE} | <p>-</p> | Zabbix trapper |
check_archive[{$ARCHIVE}]<p>Update: 0</p> |
Oracle/Version on {$DATABASE} | <p>-</p> | Zabbix trapper |
version<p>Update: 0</p> |
Zabbix failed checks on {$DATABASE} | <p>-</p> | Zabbix trapper |
failedchecks<p>Update: 0</p> |
{#DBUSER} user status | <p>-</p> | Zabbix trapper |
user_status[{#DBUSER}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Free on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_free[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Size on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_size[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
ASM Volume Use on {#ASMVOLUME} | <p>-</p> | Zabbix trapper |
asm_volume_use[{#ASMVOLUME}]<p>Update: 0</p><p>LLD</p> |
Tablespace percentual use on {#TABLESPACE} | <p>-</p> | Zabbix trapper |
tablespace[{#TABLESPACE}]<p>Update: 0</p><p>LLD</p> |
Tablespace free on {#TABLESPACE} | <p>-</p> | Zabbix trapper |
tablespace_abs[{#TABLESPACE}]<p>Update: 0</p><p>LLD</p> |
Temp Tablespace Use on {#TABLESPACE_TEMP} | <p>-</p> | Zabbix trapper |
tablespace_temp[{#TABLESPACE_TEMP}]<p>Update: 0</p><p>LLD</p> |
Name | Description | Expression | Priority |
---|---|---|---|
ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1}) | <p>-</p> | <p>Expression: (last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) - last(/Pyora active send/asm_volume_free[{#ASMVOLUME}])) / last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) *100 > 85</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} % | <p>-</p> | <p>Expression: last(/Pyora active send/tablespace[{#TABLESPACE}])>80</p><p>Recovery expression: </p> | average |
ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1}) (LLD) | <p>-</p> | <p>Expression: (last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) - last(/Pyora active send/asm_volume_free[{#ASMVOLUME}])) / last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) *100 > 85</p><p>Recovery expression: </p> | average |
Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} % (LLD) | <p>-</p> | <p>Expression: last(/Pyora active send/tablespace[{#TABLESPACE}])>80</p><p>Recovery expression: </p> | average |