Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2015
Added on Feb 10 2015
#delete, #insert
4 comments
364 views