Re: Tablespace/Datafile Layout for Datawarehouse

From: EscVector <EscVector_at_gmail.com>
Date: Sat, 09 Jun 2007 02:59:42 -0000
Message-ID: <1181357982.625839.314150@w5g2000hsg.googlegroups.com>

On Jun 8, 11:08 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0, 8 GB memory, Windows 2003 Server
>
> Below is the layout of tablespaces and datafiles for the datawarehouse where
> I work (the X's in the directory path are to protect the innocent/guilty).
> In a previous post here it appears that the drives could be mount points.
>
> Does the layout make sense? Having so many tablespaces on the same
> drive/mount points?
>
> I'm questioning this because we've been experiencing disk utilization rates
> of 98%+ on the F and G drives in the past few weeks.
>
> Thanks.
>
> 1=Status, 2=Type, 3=Extent Management, 4=Allocation Type, 5=Segment Space
> Management/Size (temp tablespaces only)
> 6=Enable Logging, 7=Block Size
>
> 1
> 2 3 4 5 6 7
> APP_DATA01 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data01_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_11.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_12.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_13.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_14.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_15.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_16.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_17.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_18.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_19.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_20.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_21.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_22.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_23.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_24.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_25.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_26.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_27.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_28.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_29.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_30.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_31.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_32.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_33.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_34.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data01_35.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA02 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data02_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_11.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_12.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_13.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_14.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_15.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_16.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_17.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_18.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_19.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_20.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_21.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_22.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_23.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_24.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_25.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_26.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_27.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_28.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_29.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_30.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_31.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_32.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_33.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_34.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data02_35.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA03 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data03_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_11.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_12.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_13.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_14.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_15.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_16.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_17.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_18.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_19.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_20.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_21.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_22.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_23.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_24.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_25.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_26.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_27.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_28.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_29.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_30.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_31.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_32.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_33.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_34.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data03_35.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA04 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data04_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_11.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_12.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_13.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_14.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_15.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_16.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_17.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_18.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_19.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_20.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_21.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_22.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_23.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_24.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_25.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_26.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_27.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_28.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_29.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_30.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_31.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_32.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_33.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_34.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data04_35.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA05 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data05_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_11.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_12.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_13.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_14.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_15.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_16.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_17.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_18.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_19.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_20.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_21.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_22.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_23.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_24.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_25.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_26.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_27.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_28.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_29.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_30.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_31.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_32.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_33.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_34.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data05_35.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA06 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data06_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_11.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_12.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_13.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_14.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_15.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_16.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_17.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_18.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_19.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_20.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_21.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_22.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_23.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_24.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_25.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_26.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_27.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_28.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_29.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_30.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_31.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_32.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_33.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_34.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data06_35.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA07 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data07_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_11.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_12.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_13.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_14.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_15.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_16.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_17.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_18.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_19.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_20.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_21.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_22.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_23.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_24.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_25.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_26.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_27.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_28.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_29.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_30.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_31.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_32.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_33.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_34.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data07_35.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA08 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data08_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_11.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_12.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_13.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_14.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_15.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_16.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_17.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_18.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_19.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_20.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_21.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_22.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_23.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_24.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_25.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_26.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_27.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_28.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_29.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_30.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_31.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_32.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_33.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_34.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data08_35.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA09 140,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> app_data09_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_11.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_12.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_13.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_14.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_15.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_16.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_17.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_18.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_19.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_20.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_21.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_22.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_23.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_24.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_25.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_26.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_27.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_28.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_29.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_30.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_31.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_32.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_33.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_34.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data09_35.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA10 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data10_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_11.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_12.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_13.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_14.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_15.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_16.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_17.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_18.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_19.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_20.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_21.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_22.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_23.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_24.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_25.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_26.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_27.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_28.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_29.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_30.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_31.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_32.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_33.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_34.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_35.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA11 140,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_data10_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_11.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_12.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_13.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_14.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_15.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_16.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_17.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_18.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_19.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_20.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_21.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_22.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_23.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_24.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_25.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_26.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_27.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_28.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_29.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_30.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_31.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_32.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_33.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_34.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data10_35.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_DATA12 140,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> app_data12_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_11.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_12.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_13.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_14.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_15.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_16.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_17.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_18.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_19.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_20.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_21.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_22.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_23.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_24.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_25.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_26.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_27.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_28.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_29.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_30.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_31.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_32.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_33.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_34.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_data12_35.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX01 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx01_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx01_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX02 40,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> app_indx02_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx02_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX03 40,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> app_indx03_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx03_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX04 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx04_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx04_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX05 40,000 MB RW PERM LOCAL AUTO MANUAL
> NO 8192
> app_indx05_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx05_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX06 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx06_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx06_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX07 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx07_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx07_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX08 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx08_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx08_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX09 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx09_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx09_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX10 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx10_1.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_3.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_4.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_5.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_6.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_7.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_8.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_9.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx10_10.ora G:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDX11 40,000 MB RW PERM LOCAL AUTO MANUAL
> YES 8192
> app_indx11_1.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_2.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_3.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_4.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_5.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_6.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_7.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_8.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_9.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indx11_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_INDXCLM 60,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> app_indxclm_1.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_2.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_3.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_4.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_5.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_6.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_7.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_8.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_9.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_10.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_11.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_12.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_13.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_14.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_indxclm_15.ora D:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> APP_TEMP 140,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> app_temp_1.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_2.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_3.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_4.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_5.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_6.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_7.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_8.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_9.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_10.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_11.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_12.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_13.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_14.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_15.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_16.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_17.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_18.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_19.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_20.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_21.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_22.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_23.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_24.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_25.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_26.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_27.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_28.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_29.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_30.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_31.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_32.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_33.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_34.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
> app_temp_35.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> SYSAUX 2,000 MB RW PERM LOCAL AUTO AUTO YES
> 8192
> sysaux01.dbf E:\ORACLE\ORADATA\XXXXXXX\ 2,000 MB
>
> SYSTEM 28,740 MB RW PERM LOCAL AUTO MANUAL YES
> 8192
> system01.dbf E:\ORACLE\ORADATA\XXXXXXX\ 28,740 MB
>
> TEMP 57,768 MB RW TEMP LOCAL UNIFORM 1024 NO
> 8192
> temp01.dbf E:\ORACLE\ORADATA\XXXXXXX\ 32,767 MB
> temp01_2.dbf E:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_02 50,000 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_02_1.ora E:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
> temp_02_2.ora E:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_03 57,767 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_03.ora G:\ORACLE\ORADATA\XXXXXXX\ 32,767 MB
> temp_03_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_04 57,767 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_04.ora G:\ORACLE\ORADATA\XXXXXXX\ 32,767 MB
> temp_04_2.ora G:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_05 30,160 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_05.ora G:\ORACLE\ORADATA\XXXXXXX\ 30,160 MB
>
> TEMP_06 25,000 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_06.ora F:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_07 25,000 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_07.ora F:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_08 25,000 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_08.ora F:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_09 50,000 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_09.ora F:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
> temp_09_.ora2.ora F:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TEMP_10 25,000 MB RW TEMP LOCAL UNIFORM 1024
> NO 8192
> temp_10.ora F:\ORACLE\ORADATA\XXXXXXX\ 25,000 MB
>
> TESTING 14,000 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> testing.ora E:\ORACLE\ORADATA\XXXXXXX\ 10,000 MB
> testing2.ora E:\ORACLE\ORADATA\XXXXXXX\ 4,000 MB
>
> TOOLS 45,000 MB RW PERM LOCAL AUTO AUTO YES
> 8192
> tools.ora E:\ORACLE\ORADATA\XXXXXXX\ 5,000 MB
> tools2.ora E:\ORACLE\ORADATA\XXXXXXX\ 20,000 MB
> tools3.ora E:\ORACLE\ORADATA\XXXXXXX\ 20,000 MB
>
> UNDOTBS1 32,768 MB RW UNDO LOCAL AUTO n/a
> YES 8192
> undotbs01.dbf E:\ORACLE\ORADATA\XXXXXXX\ 32,768 MB
>
> USERS 250 MB RW PERM LOCAL AUTO AUTO
> YES 8192
> users01.dbf D:\ORACLE\ORADATA\XXXXXXX\ 250 MB
>
> CONTROL FILES
> control01.ctl D:\ORACLE\ORADATA\XXXXXXX\
> control02.ctl D:\ORACLE\ORADATA\XXXXXXX\
> control03.ctl D:\ORACLE\ORADATA\XXXXXXX\
>
> REDO LOG GROUPS:
> 1 614,440 KB
> REDO_LOG1.ORA D:\ORACLE\ORADATA\XXXXXXX\
> 2 614,440 KB
> REDO_LOG2.ORA D:\ORACLE\ORADATA\XXXXXXX\
> 3 614,440 KB
> REDO_LOG3.ORA D:\ORACLE\ORADATA\XXXXXXX\
> 4 614,440 KB
> REDO_LOG4.ORA D:\ORACLE\ORADATA\XXXXXXX\
At first glance, your setup is less than optimal. For startes you have 3 control file going to the same place. Drop the 3rd if not splitting to separate disk. Also, the more files, the more file access overhead. If not on a SAN, I'd say good luck keeping performance going. Knowing if this is good or bad really relies on the underlying storage setup. But 3 control files to the same mount is plain silly. Received on Fri Jun 08 2007 - 21:59:42 CDT