Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Sunday, October 16, 2011

Stripe data files across multiple physical devices and locations

Goal of striping data is simple:-
To avoid I/O bottlenecks during parallel processing, all tablespaces  accessed by parallel operations should be striped.  Many current OS's support disk striping hence DBA's need not stripe data  across the disk.


In the event that you have to stripe data across Disks then  you should distribute the load evenly across the Disks. 

Let us say we have to stripe database files and we have 2 disk controllers
CONTROLLER 1 CONTROLLER 2
/u02 /u03
/u04 /u05
/u06 /u07
/u08 /u09
Create a tablespace which will look as one logical device
from oracle perspective and spread it across the disks.
CREATE TABLESPACE MYDATA
DATAFILE '/u02/oradata/mylcl/mydata.dbf' size 2M ,
DATAFILE '/u03/oradata/mylcl/mydata.dbf' size 2M ,
DATAFILE '/u04/oradata/mylcl/mydata.dbf' size 2M ,
DATAFILE '/u05/oradata/mylcl/mydata.dbf' size 2M
extent management local SEGMENT SPACE MANAGEMENT AUTOALLOCATE;

 

No comments: