Database Tuning (MOSC)

MOSC Banner

Parallelised referential constraints creation

edited Jul 21, 2010 4:25PM in Database Tuning (MOSC) 1 commentAnswered
 Hi,

I'm running an Oracle 11.1 DB. I need to import referential constraints into some of the table, but the import takes 10 hours to complete. I have 32 CPUs in the server.

I come across a note saying that i could parallelized the foreign key constraints creation and validation by alter the table degree to higher value e.g 12.

I just want to clarify if this is really help? any other thing that i need to do other than just issue alter table (tablename) parallel 12;?

Appreciate of any advise given.

Thanks

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