Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

report_tuning_task's "too many bind variables supplied" msg

VeverkeAug 9 2010 — edited Aug 11 2010
Hi, this is the first time I am trying to use dbms_sqltune.report_tuning_task to analyze and improve the performance of one problematic query here.
The only message the reporting tool is reporting is: ORA-16951: Too many bind variables supplied for this SQL statement.

But there are only 2 places where Oracle would put a bind variable in the query below. Is removing these where clauses my only option ?

Thanks.
-----------------------------------------------------------------------------------

Oracle version: 10g

Select statement (arbitrary one):

SELECT d.column_1,
d.column_2,
a.column_1,
a.column_2,
a.column_3,
i.column_1
FROM table_a a
JOIN table_b b
ON b.column_7 = a.column_3
JOIN table_c c
ON c.column_4 = b.column_2
JOIN table_d d
ON d.column_5 = c.column_1
JOIN table_e e
ON e.column_12 = c.column_3
JOIN table_f f
ON f.column_1 = a.column_2
JOIN table_g g
ON g.column_4 = a.column_5
JOIN table_h h
ON h.column_10 = f.column_7
JOIN table_line tl
ON tl.numeric_3 = e.output_type_id
AND tl.numeric_4 = a.content_category
AND tl.long_text_1 = g.business_type
JOIN table_i i
ON i.column_1 = h.column_2
AND i.column_3 = tl.table_code
WHERE tl.table_id = 'VAL001'
AND i.column_2 = 'VC';



Reporting result:

GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name : 09AUG001
Tuning Task Owner : AKAHANA
Scope : COMPREHENSIVE
Time Limit(seconds) : 60
Completion Status : COMPLETED
Started at : 08/09/2010 13:25:13
Completed at : 08/09/2010 13:25:13
Number of Errors : 1

ERRORS SECTION
-------------------------------------------------------------------------------
- ORA-16951: Too many bind variables supplied for this SQL statement.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2010
Added on Aug 9 2010
3 comments
3,919 views