Database size & Logfile size relation

Hi friends,

What is the relation between Database size and logfile size.
Is there any ratio? If somebody can tell their database size with number of datafile and logfile in detail, i will be much happier.

Thanks in Advance
Nehruji. R.

Logfile size depends on transaction volume and size.

In a 300G database, with about 100 concurrent OLTP users, I have 16 log files of 32M each.

there is no easy formula for this. from my 2 production databases:
Database 1: 14G used, 10-15 concurrent users.
3 redo logs of 250M each

Database 2: 5G used, 100 concurrent users.
3 redo logs of 15M each

Both database turn over a redo log about once an hour. As you can see, there is little correlation.

fortunately this is easy to remedy if your redolog turn over too quickly (i like to see logs turn over every 60-90 minutes during normal activity). You can do this online with an ALTER DATABASE command. Just be *very* careful about deleting the old under/over-sized files and make a backup of your controlfile if you're not doing a database backup soon.

D.