Oracle Disk Architecture...

From: HARI OM <hari_om_at_hotmail.com>
Date: 22 Feb 2005 14:33:32 -0800
Message-ID: <1109111612.935119.157420@c13g2000cwb.googlegroups.com>

I am using Oracle 9.2.0.1.0 on IBM AIX 5.1L. This is our Disk Structure:

Volume Group (VG) = rootvg --> 2 disks Mirrored. Contains: OS Files, Oracle SW and COntrol03.ctl files

VG = redo1_indx_vg --> 2 disks Mirrored. Logical Volumes (LV): /r1, /index
Contains: Group 1 of Redo Logs and Index for all instances.

VG = redo2_dict_vg --> 2 disks Mirrored. LV: /r2, /dict Contains: Group 2 of Redo Logs, Dictionary for all instances and Control01.ctl.

VG = datavg --> 2 disks Mirrored. LV: /data Contains: All Data files and Control02.ctl...

My questions:
1) Would there be any Issues or performance bottlenecks etc as far as I/O Contention, Diskusage... as per above architectue?

2) I have created DB Instance using DBCA and it creates a bunch of Datafiles which I DO NOT know where to place. Following are the files and their location I have guessed it... correct me if I am wrong in putting these files:

drsys01.dbf   --> /dict
example01.dbf --> /data
indx01.dbf    --> /indx
odm01.dbf     --> /data
system01.dbf  --> /dict
tools01.dbf   --> /data
undotbs01.dbf --> /data
users01.dbf   --> /data
xdb01.dbf     --> /data
temp01.dbf    --> /data

Thanks!

HARI OM Received on Tue Feb 22 2005 - 16:33:32 CST