Home » RDBMS Server » Performance Tuning » Increase the redo log buffer: a couple of questions
Increase the redo log buffer: a couple of questions [message #269985] Tue, 25 September 2007 05:31 Go to next message
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

Re: Increase the redo log buffer: a couple of questions [message #269996 is a reply to message #269985] Tue, 25 September 2007 06:18 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: AWR REPORT
Next Topic: Adding columns vs Adding tables
Goto Forum:
  


Current Time: Sun Dec 04 00:28:58 CST 2016

Total time taken to generate the page: 0.05622 seconds