Hi all,
11.2.0.3
aix6
We are currently experiencing performance issues to our batch process due to heavy delete and insert of a big tables, generating lots of acrhived logs hence affecting also our dataguard physical standby updates.
I am suggesting to my boss that we use partition tables to improve performance since we can use truncate instead of delete/insert to its history tables.
They have reservations for partitioned tables as they heard it is slower in inserts compared to non-partition and may degrade performance to the highly active table.
Is this true that partitioned tabled is slower in inserts than non-partitioned?
I want to test benchmark it by importing 2M rows to a partitioned table vs. non-partitioned tables. Is this an acceptable proof of concepts?
How do I get the performance statistics difference? Can I use AWR?
Thanks a lot,
pK