I checked some ratios on our databases today and how these 2 issues:
For log space requests we had a value of 1001
Oracle suggests it be around 0
And gets to misses ratio for redo copy latch contention was almost 100% (97.8%)
Oracle sugesst less than or equal to 1%
Anyone have any suggestions on what I should do to improve these numbers.
For the latch contention I did check the log_simultaneous_copies paramter and found it equals the number of CPU's we have, should I add more.
Any suggestions would be appreciated
Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic