Hi experts
Any view.

Regds
Lav Pandit


-----Original Message-----
From: Lav Pandit
[mailto:oracledba-ezmlmshield-x61612300.[Email address protected]
Sent: Thursday, November 30, 2006 4:24 PM
To: LazyDBA Discussion
Subject: parallelism


Hi,

I am running a datawarehouse size 1tb, I used to query large tables, pls
some one tell me how to exploit parallelism on my server in every query, I
found parameters below but don't know appropriate optimal value, pls suggest
I have 4 processors in my server.

optimizer_percent_parallel
parallel_adaptive_multi_user
parallel_automatic_tuning
parallel_broadcast_enabled
parallel_execution_message_size
parallel_instance_group
parallel_min_percent
parallel_min_servers
parallel_server
parallel_server_instances
parallel_threads_per_cpu
recovery_parallelism


Regds
Lav Pandit




Make your callers hear anything you like.Call 456 say DIALER TONES.

An idea can change your life.

************** LEGAL DISCLAIMER ************
This E-Mail may contain Confidential and/or legally privileged Information
and is meant for the intended recipient(s) only. If you have received this
e-mail in error and are not the intended recipient/s, kindly notify us at
[Email address protected] and then delete this e-mail immediately from your
system. You are also hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail, its contents or its attachment/s other than by
its intended recipient/s is strictly prohibited and may be unlawful.

Internet Communications cannot be guaranteed to be secure or error-free as
information could be delayed, intercepted, corrupted, lost, or contain
viruses. IDEA Cellular Limited does not accept any liability for any errors,
omissions, viruses or computer problems experienced by any recipient as a
result of this e-mail.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Make your callers hear anything you like.Call 456 say DIALER TONES.

An idea can change your life.

************** LEGAL DISCLAIMER ************
This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at [Email address protected] and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful.

Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail.

Oracle LazyDBA home page