Oracle Global Temporary Tables inside an AE process
Hi,
One of my clients has PeopleTools 8.49 an FSCM 8.8., they use AE to reorder data and do some calcs before load a functional table. The working data size is very large and the AE process run for hours.
They want to know if is possible to use oracle GTT for performance and security reasons inside the AE, as the Oracle tables does not use redo logs and empty temporary data after process session is finished (or after a commit depending the configuration stablished)
.
Is there any way to use GTT in place of Dedicated Temp Tables? What performance recomendation could you give related to the use of Oracle GTT and PeopleSoft Dedicated Temp Tables?
One of my clients has PeopleTools 8.49 an FSCM 8.8., they use AE to reorder data and do some calcs before load a functional table. The working data size is very large and the AE process run for hours.
They want to know if is possible to use oracle GTT for performance and security reasons inside the AE, as the Oracle tables does not use redo logs and empty temporary data after process session is finished (or after a commit depending the configuration stablished)
.
Is there any way to use GTT in place of Dedicated Temp Tables? What performance recomendation could you give related to the use of Oracle GTT and PeopleSoft Dedicated Temp Tables?
0