|
-
I detect small LOG_BUFFER. Tell me first what you get from that query:
select (req.value*5000)/entries.value "Ratio"
from v$sysstat req, v$sysstat entries
where req.name = 'redo log space requests'
and entries.name = 'redo entries';
If you get a number more than 1, let's start with ecreasing the LOG_BUFFER. Set it then to 1M.
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
|