Toad World® Forums

Performance problems using bind list with more than 1400 entries

SQL Optimizer 9.2.0.4159 64 against Oracle 11.2.0.3 with Oracle 11.2.0.3 x64 client

Have notified that when you use longer list (1400 bind sets with 8 binds in each set) on 5 chosen queries, SQL Optimizer become very unstable and slow.

Probably all data is used in memory …

Brg
Damir
P.S.
If needed, sending example file on mail (I have Alex one)

I can try generate that number of bind sets to test but will also appreciate you sending me your file. Also it would be great if you can send the SQL statement.

Thanks,
Alex

Sorry attached wrong file…this one is OK for you.

Brg,**
________________________**

Damir Vadas
http://damir-vadas.blogspot.com

It does not matter what you have in your life, but who!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Fri, Nov 4, 2016 at 12:14 PM, Damir Vadas damir.vadas@gmail.com wrote:

File attached

Brg,**
________________________**

Damir Vadas
http://damir-vadas.blogspot.com

It does not matter what you have in your life, but who!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Fri, Nov 4, 2016 at 11:56 AM, Alex Luk bounce-AlexLuk@toadworld.com wrote:

RE: Performance problems using bind list with more than 1400 entries

Reply by Alex Luk
I can try generate that number of bind sets to test but will also appreciate you sending me your file. Also it would be great if you can send the SQL statement.

Thanks,
Alex

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from SQL Optimizer for Oracle Forum notifications altogether.

SQL Optimizer for Oracle - Discussion Forum

Flag this post as spam/abuse.