1 Reply Latest reply: Mar 19, 2013 9:15 AM by EBSDBA RSS

    Fine Tune  performance of oe_order_headers_all table

    856374
      Dear Experts,

      the performance of Oe_order_headers_all table is extremly poor in our current enviroment. below simple sql script takes about 5 mins to run.

      select count(1) from apps.oe_order_headers_all where trunc(creation_date) = trunc(sysdate) -- 4 min 52 sec.

      we have data in the table since 2004 and user does not allow to purge the data.


      Please suggest various ways by which we can improve the performance of this table.

      Regards,
      Samir
        • 1. Re: Fine Tune  performance of oe_order_headers_all table
          EBSDBA
          Sam D wrote:
          Dear Experts,

          the performance of Oe_order_headers_all table is extremly poor in our current enviroment. below simple sql script takes about 5 mins to run.

          select count(1) from apps.oe_order_headers_all where trunc(creation_date) = trunc(sysdate) -- 4 min 52 sec.

          we have data in the table since 2004 and user does not allow to purge the data.


          Please suggest various ways by which we can improve the performance of this table.

          Regards,
          Samir
          Hi,

          What is the application release and db release?

          Please make sure you have latest patches and performance patches for these ONT products.

          Trace the actions which are slowing down, find the bottelneck and tune them.

          Please see which indexes you have for this table and trace the queries which are slowing down. Then tune them.

          Please see
          Purchase Release - Full Table Scan On OE_ORDER_LINES_ALL Table [ID 1086142.1]     
          Oe_order_lines_all Table Has 11 Million Rows. Queries Are Getting Slowed Down. [ID 421246.1]
          Booking Performance Issue After Patching to 11.5.10 Extended Support Level [ID 1307399.1]
          PERFORMANCE Issues In OM, SE, QP [ID 130511.1]