Database DataWarehousing (MOSC)

MOSC Banner

From the server resource allocation perspective is there a difference between these two statements:

edited Dec 24, 2015 10:01AM in Database DataWarehousing (MOSC) 1 commentAnswered

This is a Data warehouse with many large fact tables and many smallish dimensions.

My understanding is that smaller tables should not use parallel processing.

I have also read that if parallel is set to ie.

ALTER TABLE table_name PARALLEL (DEGREE 1 INSTANCES 1);

Oracle will assign a coordinator and a parallel process.

However if parallel is set to ie.

ALTER TABLE table_name NOPARALLEL;

Oracle will not assign a coordinator and will process in serial.


First is my understanding correct and is there any other difference in resource allocation?

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