|
-
Thanks a lot. I found it. It is set to 2 and my log_simultaneous_copies is also set to 2.
Also if i run some scripts i shows me that there is a heavy contention for redo copy latch.
Can i just go ahead and increase the values of log_simultaneous_copies to 4 from 2.
Also is there any way of specifying that out of the 2 cpu's on my server i want oracle to use only 1. I dont think it can be changed in init.ora file as cpu_count is a derived parameter.
Thanks
Anurag.
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
|