Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datawarehouse sizing

RobeenJul 4 2018 — edited Sep 9 2018

Oracle Database 12c

Red Hat Linux 7

Hello,

We are implementing a datawarehouse. The architecture is as follows.

pastedImage_0.png

Production, Test and Other Environments

pastedImage_4.png

In order to test new SW patches, SW upgrades, HW upgrades and problem investigation a test system environment is required. It should be possible to test the SW level as it is running in the live environment but new SW versions and/or patches will be tested as well.

This environment shall be equivalent to the production system in terms of functionalities and capabilities. The only difference between the test system and production system would be capacity. The test environment shall be built with a minimalist view

Grateful if you can guide me for the preparation of the new systems for PROD and test environments of the Data warehouse. Following is my partition sizing:

PROD

|

/

|

/u01

|

/var

|

/tmp

|

/data1

|

/archive

|

/boot

|

/home

|
|

40G

|

100G

|

40G

|

27G

|

10T

|

1T

|

500M

|

40G

|
|

Memory:

CPU:

TEST

|

|
|

/

|

/u01

|

/var

|

/tmp

|

/data1

|

/archive

|

/boot

|

/home

|
|

20G

|

20G

|

20G

|

15G

|

1T

|

500G

|

500M

|

20G

|

Memory:

CPU:

Thanks,

Joe

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2018
Added on Jul 4 2018
15 comments
291 views