Performance problems with bind variables
From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Thu, 13 Oct 94 22:21:00 -0300
Message-ID: <2aa.502.846%mpcbbs_at_ibase.org.br>
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Fri Oct 14 1994 - 02:21:00 CET
Date: Thu, 13 Oct 94 22:21:00 -0300
Message-ID: <2aa.502.846%mpcbbs_at_ibase.org.br>
Hi,
My customer has a report (using ReportWriter) that takes 50 seconds to run. While tunning the SQL statement (explain, etc.), I moved the query to SQL*Plus and replaced all bind variables with constants. Surprise: the same query now takes 10 seconds to run!
After, I move back to ReportWriter and replace the parameters with constants. ReportWriter also takes 10 seconds to run!
O look at the tkprof output for all executions. The execution plans are identical, but timings are different.
The question: is it a Oracle bug? can I get a patch? Local Oracle give us no answer yet!
Thanks a lot,
----->>>>>>>>>>>> Don't reply. Reply will not work! <<<<<<<<<<<<<<----
| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ibase.org.br |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |
|---------------------------------------------------------------------------|
| Softex 2000 member | Brazil, Sao Paulo state, Campinas city |
=============================================================================
- Evaluation copy of Silver Xpress. Day # 111
--- via Silver Xpress V4.01P [NR]
User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.
Received on Fri Oct 14 1994 - 02:21:00 CET