Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Let's take a look at how it would work with DB Optimizer.

Image Modified

We can clearly see that the database is not bottlenecked and there must be a problem on the application.

...

for i in 1..1000 loop insert into foo values
('a');
–commit;
end loop;
end;

/
commit;

This change improves the communication delay and now we get a fully loaded database but we run into database configuration issues.

...