ALTER TABLE FACT_SALE EXCHANGE PARTITION PERFORMANCE ISSUES..
Hi Experts,
We have as oracle Data Warehouse system, and I see some performance issues on the below statement. Remember it used to run in few seconds, but over the last 3 days its taking about 22 minutes to complete the execution.
ALTER TABLE FACT_SALE EXCHANGE PARTITION P_201511 WITH TABLE SWAP_SALE INCLUDING INDEXES WITH VALIDATION
I have run the ASH report for this statement, and the time is spent on 'db file sequential read', Is there a way to investigate more on this and guide me to resolution please ?
Database version 11.2.0.2
CPU - 8
Physical RAM - 24GB
SGA - 20,389M