[ZBX-9635] Availability report does not use Oracle Binding Created: 2015 Jun 10  Updated: 2017 May 30  Resolved: 2015 Dec 03

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 2.4.2
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Rodrigo Fraga Mohr Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: bind, oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Database using Oracle 11g
Web servers using Oracle Enterprise Linux
Number of items: 127,031
Number of triggers: 47,209
Current VPS: 217.44

Attachments: PNG File SQL ID for history queries.png     Text File availability report.debug.txt    
Issue Links:
Duplicate
duplicates ZBXNEXT-3061 Using Oracle bind variables in the qu... Closed

 Comments   
Comment by richlv [ 2015 Jun 10 ]

this issue seems to be a bit light on detail - could you please provide more information

Comment by Oleksii Zagorskyi [ 2015 Jun 11 ]

See ZBXNEXT-166 where binding for oracle has been introduced.

Comment by Rodrigo Fraga Mohr [ 2015 Jun 11 ]

Partial debug log.

Comment by Rodrigo Fraga Mohr [ 2015 Jun 11 ]

We have DEBUG turned on and we noticed that when the Availability report is executed, the queries do not appear to have binding. Also DBA checked and wasn't able to identify any query with binding when the Availability Report is being executed. Attached a partial extract from the debug log.

– Script profiler –
Total time: 17544.252015
Total SQL time: 16492.821889
SQL count: 106674 (selects: 106670 | executes: 4)
Peak memory usage: 1349.25M
Memory limit: 4096M

Comment by Oleg Ivanivskyi [ 2015 Dec 03 ]

I am closing this issue as duplicate of ZBXNEXT-3061, feel free to reopen if you do not agree.

Generated at Sat Apr 12 06:24:23 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.