Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Expected Archive Redo File Size
KPP
post Sep 22 2017, 02:51 PM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 22-September 17
Member No.: 52,183



Iíd like to know:
Is there an equation I can use to determine what I should be expecting as a normal archive redo file-size?

Background:
I have a case where twice in the last 11 months a user of my application was required to delete their archive files much earlier than they normally do in order to make a complete connection to an Oracle 11 database to complete the startup of the application server.
The logs reference: ORA-00257

Iím not convinced itís not a problem Iíve created programmatically but if it was I would expect to see this issue with much higher frequency since this database is under a steady load 24/7/365.

The database vendor and the settings utilized is not something we attempt to provide much guidance on but Iím concerned the disk space theyíve made available is too little for these files and I would like to go back to the customer and say something to the effect of ďWhile under most circumstances, 5GB is a sufficient amount of disk space for the archives given how often your backup and purge procedures are utilized, in some cases the amount of space needed require the disk space be at least 20GB. You are recommended to increase your disk space accordingly.Ē

So Iím imagining the variables would be:
. Number of redo processors
. Size of data being saved
. Concurrent transactions
. Redo log file destination size
. etc

I believe I saw another post say that the file would grow 1GB/3mins wasnít that unusual.
Is this correct?
Go to the top of the page
 
+Quote Post
burleson
post Sep 22 2017, 07:31 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi kpp, and welcome to the forum!

The redo log size is determined by the size of the online redo logs, and the volume of redo is determined by the volume of DML. Please read:

http://www.dba-oracle.com/oracle_tips_sizing_advisor.htm

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd October 2017 - 03:47 PM