| recovery parameters confusion [message #256517] |
Sun, 05 August 2007 08:33  |
pramodgaree
Messages: 22
Registered: August 2007
|
Junior Member |
|
|
Hi.....
we have a physical standby database on our site....every time when standby db is up it is trying to start recovery with (no of datafiles)*2 processes...but as parallel max servers is the ultimate parallel threshold it is taking that many no of processes for parallel recovery....
My doubt is what does recover_parallelism parameter is doing then...n wat about parallel_threadspercpu....please help me....
|
|
|
|
|
|
| Re: recovery parameters confusion [message #257034 is a reply to message #256521] |
Tue, 07 August 2007 07:40  |
pramodgaree
Messages: 22
Registered: August 2007
|
Junior Member |
|
|
Of course every time recovery is continuous...so finally as i said it is using PARALLEL_MAX_SERVERS no of recovery processes...in those processes exactly how many are used for read n how many r used for apply to blocks.....if it uses recovery_parallelism no of processes for apply to data blocks,how i can get optimum value for that parameter..ultimately when log shipping is fine,i want to increase recovery speed....
if i heave parallel_max_servers=64,recovery_parallelism=30 for a 32 CPU how can i speed up log applying further....pls help me....
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
