| disable parallelins at database level [message #295030] |
Mon, 21 January 2008 03:10  |
maga
Messages: 17
Registered: November 2007
|
Junior Member |
|
|
I have a database on windows. This machine has 8 cpu.
Table are created with parallel option in create table.
I want to disable the parallelim at database level, because I want that every select or dmp opetation use always ONLY one process.
How can I do this?
I have modified the parameter:
parallel_threads_per_cpu=0
but it doesn't work
|
|
|
|
|
|
|
|
| Re: disable parallelins at database level [message #295079 is a reply to message #295030] |
Mon, 21 January 2008 04:56  |
maga
Messages: 17
Registered: November 2007
|
Junior Member |
|
|
Thank for the link.
it says:
Specifying the degree of parallelism at the instance level
Each instance has associated with it a set of default values for DEGREE and INSTANCES. The default DEGREE value is either the number of CPUs available or the number of disks upon which a table or index is stored, whichever is less.
Oracle will use the instance-level defaults whenever the keyword DEFAULT is used in a hint or in a table or index definition. Oracle also will use the instance-level defaults when there are no hints and when no degree of parallelism has been specified at the table or index level.
but it doens't say how change it at instance level.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
