Re: Oracle Portal -- DB Performance Tuning -- any tips ?

On Wed, 09 Oct 2002 22:00:28 +0800, Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg> wrote:

> 3. StatsPack indicates high waits on log-file-sync. OK, the LGWR may
>be
>slow writing to redo logs --- but this is a Portal, why are we having a
>large number
>of writes/transactions/commits in the first place ?

Because you most likely commit every single individual record (which you should of course NOT do and is a real performance killer for obvious reasons)

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 09 2002 - 12:17:15 CDT