| Parallel Query option [message #60583] |
Tue, 17 February 2004 19:51  |
Kapil Mishra
Messages: 1
Registered: February 2004
|
Junior Member |
|
|
Hi
I am using 8.1.7.4 Oracle RDBMS. The box hosting the database have 6 CPUs.
I would like to use Parallel query option. Due to some constraint I can not make any changes to my application codes.
If I just change the Parallel degree of all my Tables and Indexes. Will it help to improve the performance.
Will there be any negative performance.
Please advice.
Thanks
Kapil
|
|
|
|
| Re: Parallel Query option [message #60585 is a reply to message #60583] |
Tue, 17 February 2004 22:17  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
Hi Kapil
Check the parameters like parallel_automatic_tuning=true oracle itself decides the numbe of parallel process to be run aganist the database for any query.
and Parallel_min_servers and parallel_max_servers and parallel_threads_per_cpu and How did u checked u'r no of cpu is cpu_count showing 6.
And are u using partions for tables and Indexes and if is so parallel queries are beneficial.
Check v$px_process for Parallel server usage.
Thanks and Regards
Prasad
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
