peoplesoft and partitioning

From: Orlando L <oralrnr_at_gmail.com>
Date: Thu, 3 Mar 2016 18:37:02 -0600
Message-ID: <CAL8Ae77=Z43waWfX8zPaS6HmeS+J8m4DOpAEzroNP3BwTSiOeg_at_mail.gmail.com>



Hi

Our peoplesoft Fin system is getting bigger. Currently we do not have partitioned tables in there. We are thinking partitioning. Can anyone share their experiences with partitioning in psft?

I have several questions on
- what to partition by (this probably is the toughest - the tables don't
make any good sense),
- the indexes, esp, the global ones,

  • post partition-implementation maintenance,
  • query and db performance afterwards, etc. Does a paper exist for the above. TIA.

Orlando.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 04 2016 - 01:37:02 CET

Original text of this message