Re: Physical Log Size v5 -> v7

In article <567b4m$jt5@cssun.mathcs.emory.edu>, "S. Hanson" <scott@tiga.worldaccess.nl> writes >Hello, > >I have a small question concerning the size of the physical log. >According to the Online v5 Adm. Guide the size of the physical log should >be created from > >"..is that total disk space allocated to the physical log and the logical log >files should equal about 20 percent of all dbspace dedicated to Online. The >ratio of logical log space to physical log space should be about 3:1." > Correct. >But the v7.2 Adm. Guide says theat the Physical log size should be >calculated from > >userthreads * (max_log_pages_per_critical_section) * 4 > Correct. >These two calculations give VERY different results on one of our machines >(197000KB vs 4340KB). > >Can anyone help? > >Thanks, > >Scott Hanson > I've users relatively large systems (up to 28Gb), With only 20Mb of physical log. On my Online 7 Tuning course the tutor did mention a very large site (several hundred gigabytes) which uses 2Gb for logical logs, physical logs tend to be smaller. Try 20Mb and monitor it. -- David Williams