Database DataWarehousing (MOSC)

MOSC Banner

Enabling parallalism on transaction database

edited Sep 27, 2011 2:06AM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi All,

I am new to oracle, so I need some suggestions from all you experts.

I have Oracle 11g R2 database server with 2 quod core CPU and 16 GB of RAM.

Which is being used for both transaction and reporting purpose. So can I enable parallelism in that? If yes, then what should be DOP? As I went through some document, it should be CPU*2. Yet I need your suggestions.

Thanks to all 

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