OraFAQ Forum: Performance Tuning » High Frequency of Redo Log Files

Home » RDBMS Server » Performance Tuning » High Frequency of Redo Log Files (Oracle 8.1.7.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

High Frequency of Redo Log Files [message #329403]

Wed, 25 June 2008 06:10

pune01
Messages: 1
Registered: June 2008

Junior Member

We are using Oracle 8i (8.1.7.0) on our production server. We have a primary server and a standby server. The standby server is in managed recovery mode.
On primary server there are four redo log groups of size 150 MB. Currently archive files are generated every 2 min (average). We fired SQL queries in the shared pool (for v$sql) to identify the queries that are mostly fired by the transactions taking place. How can we find the cause of initiation of the transactions? How can we reduce the high archive file generation rate without increasing the size of the redo log files.

Report message to a moderator

Re: High Frequency of Redo Log Files [message #329413 is a reply to message #329403]

Wed, 25 June 2008 06:35

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

How can we reduce the high archive file generation rate without increasing the size of the redo log files.

Do less work.

Regards
Michel

Report message to a moderator

Re: High Frequency of Redo Log Files [message #329423 is a reply to message #329403]

Wed, 25 June 2008 07:03

alanm
Messages: 284
Registered: March 2005

Senior Member

hi,
try checking

the ratio of "db block changes" to "db block gets"

"DB block changes" is the count of the total number of changes that were part of an update or delete operation that were made to blocks in the SGA. Such changes generate redo log entries and hence become permanent changes to the database if the transaction is committed. This is an indication of how hard the database is working.

regards

Alan

Report message to a moderator

Re: High Frequency of Redo Log Files [message #329461 is a reply to message #329423]

Wed, 25 June 2008 08:43

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Run Statspack (or rather UTLBSTAT/UTLESTAT as you're on on obsolete version) and check to see which insert/update/delete statements are generating the redo.

Report message to a moderator

Previous Topic:	Window Sort
Next Topic:	Tuning the query - Not using the index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:35:47 CST 2024