Re: Slow database performance... possible SQL*NET problem?

phil
i'm not sure if u are aware (and if u haven't already loaded it), but there is a possible patch that u can apply to hp-ux 10 if you are running the databases on jfs filesystems.

when 10 came out, many people were noticing dramatic perf issues with jfs
filesystems over the standard hfs types.

this is caused by oracle opening all files using o_sync flag to ensure that all
data is posted all the way to disk before assuming the data has been written.

basically this implies that the buffer cache is being made redundant and therefore modification to the inodes relating to the datafiles being used take
longer.

for 10.01 patch # PHKL_6661

    10.10 patch # PHKL_6663

hth
karl Received on Tue Nov 26 1996 - 00:00:00 CET