Redo Logs sizes!

[amitstora]

Hi all!

Working on Oracle v8i with D2K Forms & Reports v6i OS as win2k.

How are you!

Query:

1.For a shared mode(MTS) Database as we have at present for a 3GB database,My redo Log Files are of the following sizes:


SQL> select GROUP#,THREAD#,SEQUENCE#,BYTES,MEMBERS,STATUS
2 from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ----------------
1 1 56047 1048576 1 INACTIVE
2 1 56048 1048576 1 ACTIVE
3 1 56049 1048576 1 CURRENT

SQL> select * from v$logfile;

GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
1
D:\ORACLE\ORADATA\PVPL\REDO03.LOG

2
D:\ORACLE\ORADATA\PVPL\REDO02.LOG

3
D:\ORACLE\ORADATA\PVPL\REDO01.LOG


Please suggest whether the above sizes for redo log Files are ok for a 3GB database or should I increase the sizes as
well as members for redo log Groups to increase Performance!


Thanks & Regards,

Amit.

[jmodic]

The size of the database and the size of the redo logs are not directly corelated. For your 3GB database, three log groups of 1M might be just right, way too small or way too large. The same could be said for 100K or 500M log sizes on 3GB database.

It is not the size of the database, it is the amount of redo information generated in a unit of time that matters.

[Tarry]

Correct. Look at it this way it's a huge database but there are a lot of tables which are being filed in as history(purchase orders/maintenance jobs/etc etc) and in a period of time it'll accumulate/size up but will necessarily not be queried.
So it might just be ok.