Hi,
Thanks very much for the feedback.

Pete

-----Original Message-----
From: Sarnowski, Chris [mailto:[Email Address Removed] Wednesday, October 31, 2001 3:49 PM
To: LazyDBA.com Discussion
Subject: RE: Creating tempfiles does not reduce available disk space
repor ted by "df "


The temporary files are created as 'sparse' files: that is, the
space isn't actually allocated until it is used. In order to avoid
this, you should create the file first (using mkfile, for example),
and then use REUSE when creating the tempfile.

There are notes about this at Steve Adams's website
http://www.ixora.com.au/tips/creation/temp_disks.htm - but you
will also get a lecture about isolated disks, striping, and raw vs.
filesystem files. I'm sure these are important in many environments,
but I haven't found them to be the most important aspects of
my tuning efforts.

HTH,
-Chris



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
Oracle LazyDBA home page