Re: How Oracle datafiles are allocated physically on disk

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 01 Oct 2001 18:14:50 +0100
Message-ID: <3BB8A48A.7A52@yahoo.com>

CatherineE wrote:
>
> Can someone please tell me how an Oracle datafile is allocated on a
> disk attatched to a HP unix Server? Assuming a newly formatted disk
> that is not used by anything. If I create a subdirectory
> /disk1/oradata/LIVE and then create a datafile of 2G. How contiguous
> can this be? What are the variations of how the datafile is allocated
> on disk?
>
> Thanks.

On a totally empty disk it will be "moderately" contiguous - where "moderately" is determined by your file system implementation. The only way you'll be able to guarantee where stuff sits and how it looks is on raw devices...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Mon Oct 01 2001 - 12:14:50 CDT