Home » RDBMS Server » Server Administration » disable parallelins at database level
disable parallelins at database level [message #295030] Mon, 21 January 2008 03:10 Go to next message
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 #295034 is a reply to message #295030] Mon, 21 January 2008 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
parallel_max_servers=0

Regards
Michel
Re: disable parallelins at database level [message #295075 is a reply to message #295030] Mon, 21 January 2008 04:49 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member


Following link may be of some help.

http://www.akadia.com/services/ora_parallel_processing.html

Regards

Manjit Kumar [mkbhati]

Re: disable parallelins at database level [message #295079 is a reply to message #295030] Mon, 21 January 2008 04:56 Go to previous messageGo to next message
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.
Re: disable parallelins at database level [message #295080 is a reply to message #295079] Mon, 21 January 2008 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about my answer?

Regards
Michel
Re: disable parallelins at database level [message #295102 is a reply to message #295030] Mon, 21 January 2008 06:11 Go to previous message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member

Hope this will clear further. Weigh your options with pros & cons before you proceed further with disabling default parallelism in Oracle server.

http://www.oracle.com/technology/oramag/oracle/05-may/o35dba.html

Manjit Kumar [mkbhati]

Previous Topic: Oracle Server date
Next Topic: Database starts automatically
Goto Forum:
  


Current Time: Thu Dec 08 06:18:48 CST 2016

Total time taken to generate the page: 0.11479 seconds