Re: Creating tempfiles does not reduce available disk space reported by "df "

What you are seeing is expected behaviour.

Oracle creates tempfiles as 'sparse' files. i.e. allocates the space logically in the file definition without allocating it physically in the disc's space map.

It saves time when rebuilding, or extending temporary tablespaces - which is why backups no longer need to backup temporary tablespaces.

I believe this can still cause problems if you use Veritas Quick I/O -

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Peter Hitchman wrote in message
<10eb1a53.0110310431.4fb6f08c_at_posting.google.com>...


>Hi,

>We are running a veritas filesystem, on Solaris 8.

>

>I have created a tempfile temporary tablespace, but when looking

>at the filesystem where it is created with "df", the used/free space

>stays the same, it does not change until the tablespace is used.

>But I can confirm the file size using "ls -l". I have since managed to

>create tempfiles that do not fit in the filesystem, that then causes the

>dbw to get "out of space" messages from the OS and the file goes offline.

>

>Does anyone know why this is?

>

>Regards

>

>Pete

>

>[END]