| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Questions on prealloc command
Hi,
In order to compare the effects of the nodatainlog /etc/fstab
parameter, a consultant issued the following command. Note: the
discussion was whether it made sense to implement this parameter for
filesystems that contained the online redo logs and the archive logs,
not for data or indices.
/bin/time -p prealloc myfile 1000000000
The results indicated slightly poorer I/O performance with the datainlog parameter. The question is, was this a valid simulation of I/O for online redo logs?
Thanks,
Russ
Received on Tue Mar 25 2003 - 14:46:21 CST
![]() |
![]() |