Monthly Archives: November 2014

Insert Performance analysis part 2

I promised I would have more today.  Here is the raw data from my analysis.  As you can see as rejection (dup_val_on_index) increased, the execution time for select + insert decreased and execution time increased for insert with exception. This … Continue reading

Posted in Database Stuff | Leave a comment

Insert performance on a unique constraint.

In the past, I have read about the performance of exception handlers and all that is said is, There is performance overhead. Okay, the generic answer of “performance overhead” tells us nothing. One of the great pleasures of what I … Continue reading

Posted in Database Stuff, Life of a Oracle DBA, pl/sql performance | Leave a comment