-
Hi,
I have a 4 CPU AIX box with oracle 8.1.7 (64 bit).
I observed that on running sar command, Oracle is using only 1 cpu at any instance of time (oracle proceeses are not bound to any CPU).
The degree of parallelism is one on e tables and indexes.
Waht it the alter table or alter index command to alter the degree. Can I alter and reset it to 1 later on ???
-
Degree of parallelism can be implemented at the instance level (in init.ora), table level or query level. You can use the command:alter table table_name degree=2 (don't quite remember the exact syntax, give it a try). Yes, it can be changed back.
-
Link
Hi, 9th May 2001 20:33 hrs chennai
The first link will help you on this
http://www.oradoc.com/ora816/paraser...0/psadm_px.htm
http://www.dbmsmag.com/9705d16.html
http://info-it.umsystem.edu/oradocs/...conce.htm#1051
Did you balance the number of latches with the number of CPU's==>just to know what how you have balanced this.
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|