 Parallelism disabled in data warehouse [message #417342] |
Fri, 07 August 2009 07:32  |
goo321
Messages: 28
Registered: June 2008
Location: houston
|
Junior Member |
|
|
Occasionally I would like to know what is normal.
I don't generally talk to other human beings about work stuff so all I have is this.
I work in a data warehouse, with plenty of operational processing as well.
Parallel queries are disabled at the database level. If parallel queries were enabled the system would come down due to a few processes taking all the processing power. There are reports and other processes that take 20 hours and let us say things are not well organized. Queries regularly fail due to lack of rollback space or temp space.
Do most data warehouses have parallelism? Is it normal or possible for only certain users to have parallel query permission?
thanks.
|
|
|
|
|
|
| Re: Parallelism disabled in data warehouse [message #417374 is a reply to message #417342] |
Fri, 07 August 2009 12:57  |
coleing
Messages: 213
Registered: February 2008
|
Senior Member |
|
|
" Is it normal or possible for only certain users to have parallel query permission"
You can enable parallel query at table level, but if you do that, anyone can add it to their select query as hints and use it also.
However, there is something called parallel adaptive multi-user which basically means that the server wont get overloaded, the queries will just slow down the bigger the load.
if you request 10 parallel servers, and oracle wants to downgrade your request, it will, or even serialise it.
|
|
|
|
| Re: Parallelism disabled in data warehouse [message #417447 is a reply to message #417374] |
Sat, 08 August 2009 21:01 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
It isn't normal to have operational queries/transactions running on your data warehouse.
There are very good reasons why physically separating your OLTP system from your DW is a best practice.
Once you have separated them, parallelism is "normal", depending on the type of warehouse.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
