Do you have directio enabled on UFS? Especially for the redo logs? With directio enabled, UFS writes to the log do not serialize on the RW lock for the log file(s).
directio will also bypass the memory cache, so you need to increase the Oracle db_block_buffers when enabling UFS directio. Thanks, /jim Hans-Peter wrote: > Hi Mauro, > > Yes I understand why sysinfo is not the best to measure IO. > But I just wanted to see when in the whole trace the actual physical write > was being done. > So it seems to me that, because the sysinfo:::pwrite is right at the end the > performance bottle neck is more because of the locking etc. > > The database files are on ufs filesystems. > Is zfs better? > > Regards Hans-Peter > _______________________________________________ dtrace-discuss mailing list dtrace-discuss@opensolaris.org
