-
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.
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|