Hello,
How can I optimize the query insert into tr1234566_tmp_calc VALUES
(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14,:p15,:p
16,:p17) :
Recommendation 1: SQL Tuning
Estimated benefit is .28 active sessions, 10.88% of total activity.
-------------------------------------------------------------------
insert into tr1234566_tmp_calc VALUES
(:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11,:p12,:p13,:p14,:p15,:p
16,:p17)
Rationale
The SQL spent 98% of its database time on CPU, I/O and Cluster waits.
This part of database time may be improved by the SQL Tuning Advisor.
Rationale
Database time for this SQL was divided as follows: 99% for SQL
execution, 1% for parsing, 0% for PL/SQL execution and 0% for Java
execution.
Rationale
SQL statement with SQL_ID "f79cfu8cpyg1b" was executed 464908 times and
had an average elapsed time of 0.0063 seconds.
Thanks
bibi