Hi,
I monitor my Oracle 19c server with the 2 PDB. But the all items give by the key "oracle.sys.metrics" has the following error:
Preprocessing failed for:
1. Failed: cannot extract value from json by path "$.['Active Parallel Sessions']": invalid object format, expected opening character '{' or '[' at: ''
I have found that is good for the CDB because the following query return the all values.
[root@svx-mon-02t ~]# zabbix_get -s svx-11 -k oracle.sys.metrics["tcp://svx-11:1521","user_zabbix","password","CDB.unifr.ch "]
{"Buffer Cache Hit Ratio":93.544,"Memory Sorts Ratio":100,"Redo Allocation Hit Ratio":100,"User Transaction Per Sec":7.862,"Physical Reads Per Sec":339561.917,"Physical Reads Per Txn":43192.276,"Physical Writes Per Sec":6.786,"Physical Writes Per Txn":0.863,"Physical Reads Direct Per Sec":332024.115,"Physical Reads Direct Per Txn":42233.467,"Physical Writes Direct Per Sec":0,"Physical Writes Direct Per Txn":0,"Physical Reads Direct Lobs Per Sec":2.814,"Physical Reads Direct Lobs Per Txn":0.358,"Physical Writes Direct Lobs Per Sec":0,"Physical Writes Direct Lobs Per Txn":0,"Redo Generated Per Sec":16227.077,"Redo Generated Per Txn":2064.084,"Logons Per Sec":0.463,"Logons Per Txn":0.059,"Open Cursors Per Sec":61.519,"Open Cursors Per Txn":7.825,"User Commits Per Sec":7.746,"User Commits Percentage":98.526,"User Rollbacks Per Sec":0.116,"User Rollbacks Percentage":1.474,"User Calls Per Sec":1543.082,"User Calls Per Txn":196.28,"Recursive Calls Per Sec":5858.904,"Recursive Calls Per Txn":745.253,"Logical Reads Per Sec":448770.242,"Logical Reads Per Txn":57083.575,"DBWR Checkpoints Per Sec":1.374,"Background Checkpoints Per Sec":0,"Redo Writes Per Sec":10.907,"Redo Writes Per Txn":1.387,"Long Table Scans Per Sec":3.327,"Long Table Scans Per Txn":0.423,"Total Table Scans Per Sec":15.359,"Total Table Scans Per Txn":1.954,"Full Index Scans Per Sec":0.563,"Full Index Scans Per Txn":0.072,"Total Index Scans Per Sec":1655.991,"Total Index Scans Per Txn":210.642,"Total Parse Count Per Sec":59.616,"Total Parse Count Per Txn":7.583,"Hard Parse Count Per Sec":0.017,"Hard Parse Count Per Txn":0.002,"Parse Failure Count Per Sec":0.017,"Parse Failure Count Per Txn":0.002,"Cursor Cache Hit Ratio":88.087,"Disk Sort Per Sec":0,"Disk Sort Per Txn":0,"Rows Per Sort":26.939,"Execute Without Parse Ratio":3.613,"Soft Parse Ratio":99.972,"User Calls Ratio":20.847,"Host CPU Utilization (%)":21.691,"Network Traffic Volume Per Sec":222429.576,"Enqueue Timeouts Per Sec":0,"Enqueue Timeouts Per Txn":0,"Enqueue Waits Per Sec":1.374,"Enqueue Waits Per Txn":0.175,"Enqueue Deadlocks Per Sec":0,"Enqueue Deadlocks Per Txn":0,"Enqueue Requests Per Sec":339.854,"Enqueue Requests Per Txn":43.229,"DB Block Gets Per Sec":588.431,"DB Block Gets Per Txn":74.848,"Consistent Read Gets Per Sec":448188.381,"Consistent Read Gets Per Txn":57009.562,"DB Block Changes Per Sec":78.352,"DB Block Changes Per Txn":9.966,"Consistent Read Changes Per Sec":268.222,"Consistent Read Changes Per Txn":34.118,"CPU Usage Per Sec":251.698,"CPU Usage Per Txn":32.016,"CR Blocks Created Per Sec":0.215,"CR Blocks Created Per Txn":0.027,"CR Undo Records Applied Per Sec":1.109,"CR Undo Records Applied Per Txn":0.141,"User Rollback UndoRec Applied Per Sec":0,"User Rollback Undo Records Applied Per Txn":0,"Leaf Node Splits Per Sec":0.116,"Leaf Node Splits Per Txn":0.015,"Branch Node Splits Per Sec":0,"Branch Node Splits Per Txn":0,"PX downgraded 1 to 25% Per Sec":0,"PX downgraded 25 to 50% Per Sec":0,"PX downgraded 50 to 75% Per Sec":0,"PX downgraded 75 to 99% Per Sec":0,"PX downgraded to serial Per Sec":0,"Physical Read Total IO Requests Per Sec":8806.356,"Physical Read Total Bytes Per Sec":2782386089.904,"GC CR Block Received Per Second":0,"GC CR Block Received Per Txn":0,"GC Current Block Received Per Second":0,"GC Current Block Received Per Txn":0,"Global Cache Average CR Get Time":0,"Global Cache Average Current Get Time":0,"Physical Write Total IO Requests Per Sec":17.279,"Global Cache Blocks Corrupted":0,"Global Cache Blocks Lost":0,"Current Logons Count":260,"Current Open Cursors Count":1283,"User Limit %":0,"SQL Service Response Time":0.035,"Database Wait Time Ratio":4.017,"Database CPU Time Ratio":95.983,"Response Time Per Txn":33.356,"Row Cache Hit Ratio":100,"Row Cache Miss Ratio":0,"Library Cache Hit Ratio":99.971,"Library Cache Miss Ratio":0.029,"Shared Pool Free %":13.953,"PGA Cache Hit %":95.488,"Process Limit %":32.444,"Session Limit %":21,"Executions Per Txn":7.867,"Executions Per Sec":61.85,"Txns Per Logon":16.964,"Database Time Per Sec":262.231,"Physical Write Total Bytes Per Sec":93265.012,"Physical Read IO Requests Per Sec":8764.614,"Physical Read Bytes Per Sec":2781734743.198,"Physical Write IO Requests Per Sec":5.313,"Physical Write Bytes Per Sec":55589.54,"DB Block Changes Per User Call":0.051,"DB Block Gets Per User Call":0.381,"Executions Per User Call":0.04,"Logical Reads Per User Call":290.827,"Total Sorts Per User Call":0.028,"Total Table Scans Per User Call":0.01,"Current OS Load":2.18,"Streams Pool Usage Percentage":0,"PQ QC Session Count":0,"PQ Slave Session Count":0,"Queries parallelized Per Sec":0,"DML statements parallelized Per Sec":0,"DDL statements parallelized Per Sec":0,"PX operations not downgraded Per Sec":0,"Session Count":315,"Average Synchronous Single-Block Read Latency":0.001,"I/O Megabytes per Second":2651.44,"I/O Requests per Second":6177.607,"Average Active Sessions":2.622,"Active Serial Sessions":3,"Active Parallel Sessions":0,"Captured user calls":0,"Replayed user calls":0,"Workload Capture and Replay status":0,"Background CPU Usage Per Sec":1.569,"Background Time Per Sec":0.038,"Host CPU Usage Per Sec":259.302,"Cell Physical IO Interconnect Bytes":168119663616,"Temp Space Used":1048576,"Total PGA Allocated":1997281280,"Total PGA Used by SQL Workareas":194560,"Run Queue Per Sec":0,"VM in bytes Per Sec":384245.746,"VM out bytes Per Sec":50437.339}
[root@svx-mon-02t ~]#
But the similar query for the PDB, they are no value.
[root@svx-mon-02t ~]# zabbix_get -s svx-11 -k oracle.sys.metrics["tcp://svx-11:1521","user_zabbix","password","PDB.unifr.ch"]
[root@svx-mon-02t ~]#
I need help ?
Regards
Olivier
I monitor my Oracle 19c server with the 2 PDB. But the all items give by the key "oracle.sys.metrics" has the following error:
Preprocessing failed for:
1. Failed: cannot extract value from json by path "$.['Active Parallel Sessions']": invalid object format, expected opening character '{' or '[' at: ''
I have found that is good for the CDB because the following query return the all values.
[root@svx-mon-02t ~]# zabbix_get -s svx-11 -k oracle.sys.metrics["tcp://svx-11:1521","user_zabbix","password","CDB.unifr.ch "]
{"Buffer Cache Hit Ratio":93.544,"Memory Sorts Ratio":100,"Redo Allocation Hit Ratio":100,"User Transaction Per Sec":7.862,"Physical Reads Per Sec":339561.917,"Physical Reads Per Txn":43192.276,"Physical Writes Per Sec":6.786,"Physical Writes Per Txn":0.863,"Physical Reads Direct Per Sec":332024.115,"Physical Reads Direct Per Txn":42233.467,"Physical Writes Direct Per Sec":0,"Physical Writes Direct Per Txn":0,"Physical Reads Direct Lobs Per Sec":2.814,"Physical Reads Direct Lobs Per Txn":0.358,"Physical Writes Direct Lobs Per Sec":0,"Physical Writes Direct Lobs Per Txn":0,"Redo Generated Per Sec":16227.077,"Redo Generated Per Txn":2064.084,"Logons Per Sec":0.463,"Logons Per Txn":0.059,"Open Cursors Per Sec":61.519,"Open Cursors Per Txn":7.825,"User Commits Per Sec":7.746,"User Commits Percentage":98.526,"User Rollbacks Per Sec":0.116,"User Rollbacks Percentage":1.474,"User Calls Per Sec":1543.082,"User Calls Per Txn":196.28,"Recursive Calls Per Sec":5858.904,"Recursive Calls Per Txn":745.253,"Logical Reads Per Sec":448770.242,"Logical Reads Per Txn":57083.575,"DBWR Checkpoints Per Sec":1.374,"Background Checkpoints Per Sec":0,"Redo Writes Per Sec":10.907,"Redo Writes Per Txn":1.387,"Long Table Scans Per Sec":3.327,"Long Table Scans Per Txn":0.423,"Total Table Scans Per Sec":15.359,"Total Table Scans Per Txn":1.954,"Full Index Scans Per Sec":0.563,"Full Index Scans Per Txn":0.072,"Total Index Scans Per Sec":1655.991,"Total Index Scans Per Txn":210.642,"Total Parse Count Per Sec":59.616,"Total Parse Count Per Txn":7.583,"Hard Parse Count Per Sec":0.017,"Hard Parse Count Per Txn":0.002,"Parse Failure Count Per Sec":0.017,"Parse Failure Count Per Txn":0.002,"Cursor Cache Hit Ratio":88.087,"Disk Sort Per Sec":0,"Disk Sort Per Txn":0,"Rows Per Sort":26.939,"Execute Without Parse Ratio":3.613,"Soft Parse Ratio":99.972,"User Calls Ratio":20.847,"Host CPU Utilization (%)":21.691,"Network Traffic Volume Per Sec":222429.576,"Enqueue Timeouts Per Sec":0,"Enqueue Timeouts Per Txn":0,"Enqueue Waits Per Sec":1.374,"Enqueue Waits Per Txn":0.175,"Enqueue Deadlocks Per Sec":0,"Enqueue Deadlocks Per Txn":0,"Enqueue Requests Per Sec":339.854,"Enqueue Requests Per Txn":43.229,"DB Block Gets Per Sec":588.431,"DB Block Gets Per Txn":74.848,"Consistent Read Gets Per Sec":448188.381,"Consistent Read Gets Per Txn":57009.562,"DB Block Changes Per Sec":78.352,"DB Block Changes Per Txn":9.966,"Consistent Read Changes Per Sec":268.222,"Consistent Read Changes Per Txn":34.118,"CPU Usage Per Sec":251.698,"CPU Usage Per Txn":32.016,"CR Blocks Created Per Sec":0.215,"CR Blocks Created Per Txn":0.027,"CR Undo Records Applied Per Sec":1.109,"CR Undo Records Applied Per Txn":0.141,"User Rollback UndoRec Applied Per Sec":0,"User Rollback Undo Records Applied Per Txn":0,"Leaf Node Splits Per Sec":0.116,"Leaf Node Splits Per Txn":0.015,"Branch Node Splits Per Sec":0,"Branch Node Splits Per Txn":0,"PX downgraded 1 to 25% Per Sec":0,"PX downgraded 25 to 50% Per Sec":0,"PX downgraded 50 to 75% Per Sec":0,"PX downgraded 75 to 99% Per Sec":0,"PX downgraded to serial Per Sec":0,"Physical Read Total IO Requests Per Sec":8806.356,"Physical Read Total Bytes Per Sec":2782386089.904,"GC CR Block Received Per Second":0,"GC CR Block Received Per Txn":0,"GC Current Block Received Per Second":0,"GC Current Block Received Per Txn":0,"Global Cache Average CR Get Time":0,"Global Cache Average Current Get Time":0,"Physical Write Total IO Requests Per Sec":17.279,"Global Cache Blocks Corrupted":0,"Global Cache Blocks Lost":0,"Current Logons Count":260,"Current Open Cursors Count":1283,"User Limit %":0,"SQL Service Response Time":0.035,"Database Wait Time Ratio":4.017,"Database CPU Time Ratio":95.983,"Response Time Per Txn":33.356,"Row Cache Hit Ratio":100,"Row Cache Miss Ratio":0,"Library Cache Hit Ratio":99.971,"Library Cache Miss Ratio":0.029,"Shared Pool Free %":13.953,"PGA Cache Hit %":95.488,"Process Limit %":32.444,"Session Limit %":21,"Executions Per Txn":7.867,"Executions Per Sec":61.85,"Txns Per Logon":16.964,"Database Time Per Sec":262.231,"Physical Write Total Bytes Per Sec":93265.012,"Physical Read IO Requests Per Sec":8764.614,"Physical Read Bytes Per Sec":2781734743.198,"Physical Write IO Requests Per Sec":5.313,"Physical Write Bytes Per Sec":55589.54,"DB Block Changes Per User Call":0.051,"DB Block Gets Per User Call":0.381,"Executions Per User Call":0.04,"Logical Reads Per User Call":290.827,"Total Sorts Per User Call":0.028,"Total Table Scans Per User Call":0.01,"Current OS Load":2.18,"Streams Pool Usage Percentage":0,"PQ QC Session Count":0,"PQ Slave Session Count":0,"Queries parallelized Per Sec":0,"DML statements parallelized Per Sec":0,"DDL statements parallelized Per Sec":0,"PX operations not downgraded Per Sec":0,"Session Count":315,"Average Synchronous Single-Block Read Latency":0.001,"I/O Megabytes per Second":2651.44,"I/O Requests per Second":6177.607,"Average Active Sessions":2.622,"Active Serial Sessions":3,"Active Parallel Sessions":0,"Captured user calls":0,"Replayed user calls":0,"Workload Capture and Replay status":0,"Background CPU Usage Per Sec":1.569,"Background Time Per Sec":0.038,"Host CPU Usage Per Sec":259.302,"Cell Physical IO Interconnect Bytes":168119663616,"Temp Space Used":1048576,"Total PGA Allocated":1997281280,"Total PGA Used by SQL Workareas":194560,"Run Queue Per Sec":0,"VM in bytes Per Sec":384245.746,"VM out bytes Per Sec":50437.339}
[root@svx-mon-02t ~]#
But the similar query for the PDB, they are no value.
[root@svx-mon-02t ~]# zabbix_get -s svx-11 -k oracle.sys.metrics["tcp://svx-11:1521","user_zabbix","password","PDB.unifr.ch"]
[root@svx-mon-02t ~]#
I need help ?
Regards
Olivier