This content has been marked as final. Show 1 reply
Sam D wrote:Hi,
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.
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.
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]