S. Hanson wrote:
>
> 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."
>
> But the v7.2 Adm. Guide says theat the Physical log size should be
> calculated from
>
> userthreads * (max_log_pages_per_critical_section) * 4
>
> These two calculations give VERY different results on one of our machines
> (197000KB vs 4340KB).
>
> Can anyone help?
>
> Thanks,
>
> Scott Hanson
My experience of these things is that calculations of the "userthreads"
variety are highly approximate. What i did, and what I'd advise, is to
use the 20% logs/ 3:1 logical:physical and monitor the usage.
Neil Truby
Chase Manhattan Bank,
Bournemouth, UK