Chris,
 
I agreed with what you said, however sometimes you want to put the file in certain location when the file is first created, any ideal??
 
KC
 
 
-----Original Message-----
From: Christopher Spence <[EMAIL PROTECTED]>
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wednesday, June 20, 2001 1:15 AM
Subject: RE: Disk configuration

As that person if Santa exists.
 
The datafiles allocate their extents upon their creation, so a new insert will write within that space,
 

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
From: KC [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Subject: Disk configuration

Dear List,
 
Someone told me when a disk receive a write request, it write to the nearest free space on disk where the disk read/write head is currently positioning, is this information correct?? If this is true, is this a bad thing for database application?? That mean we can't really control where the file go, for performance purpose we may want to put certain files on the outer tracks of a disk, if the write location is depending on where the read/write head is, how can we avoid that, can we create subdisks from the outer track of a disk and create a logical volume from it??
 
KC

Reply via email to