1 Reply Latest reply: Apr 15, 2012 9:15 PM by Hussein Sawwan-Oracle RSS

    Pre payroll processing-system enhancement

    733431
      Dear all,

      11.5.10.2 on Linux. DB size of 3 T with more than 2400 concurrent users.

      In order to avoid any problem during payroll, The Current company had recommended to rebuild undo/temp tablespaces and gather schema stats for HR and APPLSYS schema . Is this a good option ?

      Can anyone shed some lights on this?

      Thanks
        • 1. Re: Pre payroll processing-system enhancement
          Hussein Sawwan-Oracle
          In order to avoid any problem during payroll, The Current company had recommended to rebuild undo/temp tablespaces
          Rebuilding the UNDO/TEMP tablespaces will not help in improving the performance, and the payroll run process does not require large amounts of TEMP tablespace (just make sure it is sized properly) -- Oracle 11i & R12 Human Resources (HRMS) & Benefits (BEN) Tuning & System Health Checks [ID 226987.1]
          and gather schema stats for HR and APPLSYS schema . Is this a good option ?
          This would definitely help and you should schedule Gather Schema Statistics to run on regular basis -- How Often Should Gather Schema Statistics Program be Run? [ID 168136.1]

          Thanks,
          Hussein