Recent content by OnCallDuty

It took 6.5 minutes to execute the SQL script containing 500 INSERTs. The INSERTs are not wrapped in an PL/SQL block. You are right that wrapping them in a block solves the problem but the 500 INSERTS were just an example that should help you to reproduce the problem. We have written a number of...

I wrote the script containing hundreds of INSERTs just to give you an example with which you can reproduce the problem. We also have other scripts where an anonymous PL/SQL block doesn't help. In an earlier version the script could be executed in a very short amount of time. Why is an entire CPU...

Hello, we have upgraded to version 10.0.5.1710 (20 user license) and our developers now have a problem executing SQL scripts, because the execution takes a long time. If an SQL script contains only 500 simple INSERT statements, then after pressing for executing the script, the UI displays...