2 Replies Latest reply on Jun 12, 2018 3:54 PM by Beauty_and_dBest

    EBS 12.x Lots of temp

    Beauty_and_dBest

      EBS 12.x

      10g,11g,12c

      OL6

       

      Hi ALL,

       

      I checked our EBS database and I see lots of TEMP datafiles, corresponding to different TEMP tablespaces.

      [root@oradb-1 temp_files]# ls -l

      total 405584

      -rw-r----- 1 oracle oinstall  2097160192 May 31 07:42 a_txn_TEMP_EPMS_01.dbf

      -rw-r----- 1 oracle oinstall  1073750016 May 31 07:42 eproc_temp01.dbf

      -rw-r----- 1 oracle oinstall  2097160192 May 31 07:42 EPS_temp01.dbf

      -rw-r----- 1 oracle oinstall  2097160192 May 31 07:42 IPORTS_temp01.dbf

      -rw-r----- 1 oracle oinstall  2097160192 May 31 07:42 OPCE_temp01.dbf

      -rw-r----- 1 oracle oinstall  1073750016 May 31 14:18 temp02.dbf

      -rw-r----- 1 oracle oinstall  1073750016 Jun 13 04:06 temp03.dbf

      -rw-r----- 1 oracle oinstall 21474844672 Jun 11 17:35 temp04.dbf

      -rw-r----- 1 oracle oinstall 21474844672 Jun 13 04:00 temp05.dbf

      [root@oradb-1 temp_files]#

       

      Does it improve performance if I have lots of TEMP and distribute it to different users? Or one is enough?

       

       

      Please help...

       

       

      Kind regards,

      Jc