| Neeraj |
Posted: Dec 14, 2007 02:28:20 AM |
Total Post: 240
Joined: Jan, 2007
|
i m running some tables of my dtabase on diffrent machine to process a report by creating a diffrent database, i take my dump from export utility.
but the porcess is taking long time to process , so tell me how can i speed up my database so my process can completed in less time,
what parameter i shuld tune,or wt strategy i shud apply when i take export backup. |
|
|
 MOH_DBA |
| Posted: Jan 29, 2008 01:15:02 PM |  |
|
Total Post: 133
Joined: Nov, 2007
|
I will give more than one solutions, I hope that will help:
1) Use the buffer option in the import ex.(buffer=100000000)
2)try to use direct path not conventional path (direct=y)
3)to use parallel in your database use this parameters:
parallel_adaptive_multi_user
parallel_server
parallel_server_instances
parallel_min_percent
parallel_min_servers
parallel_max_servers
parallel_execution_message_size
parallel_adaptive_multi_user
parallel_threads_per_cpu
|
|
|
|
|
| Neeraj |
| Posted: Jan 30, 2008 12:19:00 AM | |
|
Total Post: 240
Joined: Jan, 2007
|
HI,
THXS FOR THE HELP BUT TELL ME THAT PARAMETERS U TOLD ME SO TELL ME WT SHUD BE THE VALUE OF THESE PARAMETERS .
THXS
|
|
|
|
|
| MOH_DBA |
| Posted: Jan 30, 2008 08:05:04 AM | |
|
Total Post: 133
Joined: Nov, 2007
|
parallel_adaptive_multi_user = true (the default) (enables adaptive algorithm designed to imporove performance in multiuser enviroments that use parallel processing)
parallel_max_servers=(#of CPUs availiable to the database instance)
(specifies maximum processing of parallel process for the database instance)
parallel_min_percent=number(specifies minimum percentage of parallel processing required for parallel processing. Value is a percentage of parallel_max_servers)
parallel_min_servers=number(Specifies minimum number of parallel processes for the database instance. Cannot be greater than value of parallel_max_servers)
parallel_execution_message_size=bytes (Specifies the bytes size of messages for parallel processing)
parallel_threads_per_cpu=number "depend on the OS" (Specifies teh number of parallel processes per CPU).
the other parameter used in Oracle parallel server if you are using it. and how to set them :http://download-west.oracle.com/docs/cd/A87860_01/doc/paraserv.817/a76970/psadm_pa.htm
if you are using RAC you can use this parameter:
parallel_instance_group=group_name
PARALLEL_INSTANCE_GROUP is a Real Application Clusters parameter that you can specify in parallel mode only. Used in conjunction with the INSTANCE_GROUPS parameter, it lets you restrict parallel query operations to a limited number of instances.
I hope that help.
|
|
|
|
|
| MOH_DBA |
| Posted: Jan 30, 2008 08:22:13 AM | |
|
Total Post: 133
Joined: Nov, 2007
|
this parameter is not:
parallel_max_servers=(#of CPUs availiable to the database instance)
But is :
PARALLEL_MAX_SERVERS specifies the maximum number of parallel execution processes and parallel recovery processes for an instance. As demand increases, Oracle increases the number of processes from the number created at instance startup up to this value.
PARALLEL_MAX_SERVERS = number (0 to 3599)
If you set this parameter too low, some queries may not have a parallel execution process available to them during query processing. If you set it too high, memory resource shortages may occur during peak periods, which can degrade performance
i hope that help.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
