Home » RDBMS Server » Performance Tuning » High Frequency of Redo Log Files (Oracle 8.1.7.0)
High Frequency of Redo Log Files [message #329403] Wed, 25 June 2008 06:10 Go to next message
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.
Re: High Frequency of Redo Log Files [message #329413 is a reply to message #329403] Wed, 25 June 2008 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: High Frequency of Redo Log Files [message #329423 is a reply to message #329403] Wed, 25 June 2008 07:03 Go to previous messageGo to next message
alanm
Messages: 282
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
Re: High Frequency of Redo Log Files [message #329461 is a reply to message #329423] Wed, 25 June 2008 08:43 Go to previous message
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.
Previous Topic: Window Sort
Next Topic: Tuning the query - Not using the index
Goto Forum:
  


Current Time: Wed Dec 07 16:14:01 CST 2016

Total time taken to generate the page: 0.11924 seconds