On 12 Apr 2003 at 11:23, asr AT ufl DOT edu wrote:
> I'm betting that the striping you're speaking of happens at a
> different logical level. For example, if ORACLE knows that it has a
> 20GB database, with 2GB of container space on each of 10 different
> containers, then it is likely that two consecutive random requests
> will require access from different containers.
>


Exactly.  For example, we just brought up a very large Oracle db.
The database is defined by several hundred datafiles.  If you map out
the filesystems and logical volume structures, you have a structure
where every datafile is spread across every physical disk drive.
This is a SAP db, and runs a 90% random I/O pattern.  The performance
domain is for all Oracle datafiles is all disk drives.



-----------------------------------------
The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.