Database DataWarehousing (MOSC)

MOSC Banner

Query runs in parallel in one database but not in the other, why?

edited Feb 28, 2013 4:22PM in Database DataWarehousing (MOSC) 11 commentsAnswered ✓
Hi,

11.2..02

We have two test databases (DB1 & DB2). Data warehouses.

DB2 is a export/import from DB1.

They both run in a RHEL6 cluster on the same physical server.

Statistics is up to date.

But a couple of queries runs in parallel in DB1 and not in DB2.

I can force DB2 to run the query in parallel using hints. But I would like to know why DB2 dont run the same query in parallel as it does in DB1. The parameters regarding parallel is the same in both databases and I have also gathered system statistics.

Any pointers?

Regards

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