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;
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:
Post a Comment