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.