Skip to Main Content

How to performance-test inserts and deletes?

bonbonbaronFeb 10 2015 — edited Feb 11 2015

I have two questions:

  1. In the context of SQL Developer with Oracle 11g, what's the best way to test the run-time of 2 different versions of a function that involves INSERT or DELETE? I'd do a rollback between the two executions, but when working with massive amounts of data this takes forever and a half.
  2. Is there a safe way to ensure caching doesn't impact the accuracy of run-times in both executions? I'd do the "alter system flush buffer_cache/shared_pool" and whatnot, but I get the feeling that with everybody using the same database here I might seriously screw something up.

Thanks!

Michael

Comments
Post Details
Added on Feb 10 2015
4 comments
134 views