Query runs in parallel in one database but not in the other, why?
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