Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Questions on prealloc command

Questions on prealloc command

From: Russ Brooks <russ.brooks_at_dayzim.com>
Date: 25 Mar 2003 12:46:21 -0800
Message-ID: <a7f817f2.0303251246.5abf1271@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US