Thursday, May 01, 2008

Peoplesoft FSCM9.0 - space required

On that 1st of May and after the famous Queen's Day (Koninginnedag in Dutch), new task on my lab. FSCM installation.

Every FSCM version insrease the number of Peoplesoft objects. This one is not an exception :
SQL> select object_type, count(*)
2 from dba_objects
3 where owner='SYSADM'
4 group by object_type;
OBJECT_TYPE COUNT(*)
------------------- ----------
LOB 2036
TRIGGER 195
TABLE 71871
INDEX 66194
VIEW 27267

Ouch, more than 70,000 tables, good luck to maintain the database.

Moreover, the DMO database is huge, around 90Gb only for sample (!), here below the biggest tablespaces (extents):
TABLESPACE_NAME EXTSIZEMB
------------------------------ ----------
POWORK 575.875
POLARGE 654
INWORK 664.75
ARLARGE 817
OMWORK 930.75
PCLARGE 990
INLARGE 1134
AMLARGE 1185
EOCULRG 1280
APLARGE 1597
SYSTEM 1720.0625
PSIMAGE 1797
PSINDEX 67495

I have to say it was a nightmare to build it on my lab. The indexes (number and size) are really impressive. I had to increase dramatically the disk space available on my VM, some good advices here
If you decide to go for a FSCM9.0 installation, check the space on your device and be patient, it's very long.

Enjoy with Peoplesoft installation !

1 comment:

Anonymous said...

Nick,
I liked your blog. It helped me understand the complete process of installing Peoplesoft.

I like to also learn about Integration Broker. Hope you post how to install Integration broker
Thanks
-Cr