SQL Performance (MOSC)

MOSC Banner

ALTER TABLE FACT_SALE EXCHANGE PARTITION PERFORMANCE ISSUES..

edited Dec 11, 2015 2:32PM in SQL Performance (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center