Re: Can Missing Tempfiles be Simply ADDED back after eXtract of FULL Database Backup ?

On 10/25/06, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> What did you mean by the word "sparse" in your statement "when the file
> isn't already present, in order to prevent it from being created sparse
> under *nix"
>
> What are the advantages of NOT having a sparse tempfile?
>

By sparse[1] I mean that the space for the file isn't actually allocated until it's used. This lets you create a 16 GB tempfile, for example, in a 2 GB filesystem... instead of getting an error during creation, it occurs later when the usage finally climbs too high. BTW, this can have rather nasty consequences if you have a controlfile and tempfile sharing the same filesystem (trust me on this one).

Last I checked, tempfiles are the only type that Oracle will create sparse (and only under *nix). You can check this by comparing the output of "ls -l" and "du -k" immediately after creation.

[1] http://en.wikipedia.org/wiki/Sparse_file

-- 
"I'm too sexy for my code." - Awk Sed Fred.

--
http://www.freelists.org/webpage/oracle-l