SQL Performance (MOSC)

MOSC Banner

Split table partition take a long time ?

in SQL Performance (MOSC) 6 commentsAnswered ✓

Hi All,

I've some question, i try to add new range partition with split partition method, but it took a long time for finished 1 new range partition it's almost 1 hour to do that, my table size is 194 GB and i use this query for split partition,

ALTER TABLE IONPAY.TB_TRANS_REQ SPLIT PARTITION TRANS_REQ_999999 AT (20210301) INTO (PARTITION TRANS_REQ_20210301, PARTITION TRANS_REQ_999999);

My question is, what it running so long , and there's a way to make it faster for add new range partition, or what should i check ?

Regards,

Irfan

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