| Increase the redo log buffer: a couple of questions [message #269985] |
Tue, 25 September 2007 05:31  |
Malakay79
Messages: 41
Registered: September 2007
|
Member |
|
|
I would like to know if my redo log buffer is ok.
The actual size is: 6980608
I runned this query:
select event, total_waits from v$system_event
where event like 'log buffer space%';
EVENT TOTAL_WAITS
------------------- -----------
log buffer space 1361
I know that the redo log files are too small (50M) and today I will increase them. Actually I have a redo switch every 10 minutes. And in the alert I see "checkpoint inclomplete" very often.
These ara other information:
SQL> SELECT a.name,b.value
2 FROM v$statname a,v$sysstat b
3 WHERE a.statistic# = b.statistic#
4 AND a.name like '%redo%'
5 order by b.value desc;
NAME VALUE
---------------------------------------- ----------
redo size 2.1616E+10
redo wastage 114236868
redo entries 59113991
redo blocks written 43842031
redo subscn max counts 1759235
redo ordering marks 772654
redo synch writes 493706
redo writes 409942
redo blocks read for recovery 121904
redo write time 106960
redo synch time 69404
NAME VALUE
---------------------------------------- ----------
redo log space wait time 24182
redo buffer allocation retries 5638
redo log space requests 5129
redo writer latching time 63
redo log switch interrupts 0
Do you think that I increase also the redo log buffer?
Many thanks
Mary
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
