Top 5 Timed Foreground Events

Event 	                       Waits Time(s) Avg wait (ms) % DB time Wait Class 
DB CPU   			      6,437                  24.69   
SQL*Net message from dblink  146,277  6,337         43       24.30   Network 
db file sequential read      327,987  2,938          9       11.27   User I/O 
log file sync                 97,437  2,404         25        9.22   Commit 
SQL*Net more data from dblink 16,682  1,421         85        5.45   Network 

Query 1:
======== 

SELECT SERIAL_NUM FROM IDA.S_ASSET@KEN_LINK.WORLD 
WHERE (OWNER_ACCNT_ID = :B1 ) 
AND STATUS_CD = 'Active' 
AND PROD_ID IN ('1-1XT7XU', '1-SRL6LA', '1-P74IP6') 
AND SUBSTR(SERIAL_NUM, 1, 1)='0'

Query 2:
======== 

SELECT DISTINCT A.SERIAL_NUM FROM IDA.S_ASSET@KEN_LINK.WORLD A, IDA.S_ORG_EXT@KEN_LINK.WORLD B 
WHERE A.BILL_ACCNT_ID=B.ROW_ID 
AND B.OU_NUM=:B1 
AND (TO_CHAR (SUBSTR (A.SERIAL_NUM, 1, 1)) = '0') 
AND LENGTH (A.SERIAL_NUM) > 9 
AND LENGTH (A.SERIAL_NUM) < 14 
AND LENGTH (A.SERIAL_NUM)- LENGTH (TRANSLATE (A.SERIAL_NUM, CHR (1)|| 
TRANSLATE (A.SERIAL_NUM, CHR (1) || '1234567890', CHR (1)), CHR (1)))=0 
AND A.SERIAL_NUM IS NOT NULL;


Query 3:
======== 
	 INSERT ALL
         INTO FETCHPROCESS.TMP_ORDERDETAILS_TAB_ORD
         (
         ORDERID,
         ORDERITEMSUBTYPE,
         ORDERVERSIONNUMBER,
         ORDERDATE,
         ORDERITEMID,
         ORDERITEMORDERID,
         ORDERITEMREQSHIPDATE,
         ORDERITEMACTIONCODE,
         ORDERITEMASSETID,
         ORDERITEMPARENTITEMID,
         ORDERITEMROOTITEMID,
         ORDERITEMSERVICENUM,
         ORDERITEMSTATUS,
         ORDERITEMPROMOID,
         ORDERITEMAPPOINTMENTID,
         ORDERITEMSUBSTATUS,
         ORDERITEMSHIPTOCONTACTID,
         ORDERITEMPRODUCTSCODE,
         ORDERITEMPREVIOUSSERVICEID,
         SERVICEPOINTSERVICEID,
         SERVICEPOINTSTATUS,
         SERVICEPOINTSUBSTATUS,
         SERVICEPOINTHIGHBANDSUBSTATUS,
         ORDERITEMATTRIBNAME,
         ORDERITEMATTRIBCHARVALUE,
         ORDERITEMCREATED,
         ORDERITEMLASTUPDATED,
         ORDERSERVACCTID
         )
         values (
         ORDERID,
         ORDERITEMSUBTYPE,
         ORDERVERSIONNUMBER,
         ORDERDATE,
         ORDERITEMID,
         ORDERITEMORDERID,
         ORDERITEMREQSHIPDATE,
         ORDERITEMACTIONCODE,
         ORDERITEMASSETID,
         ORDERITEMPARENTITEMID,
         ORDERITEMROOTITEMID,
         ORDERITEMSERVICENUM,
         ORDERITEMSTATUS,
         ORDERITEMPROMOID,
         ORDERITEMAPPOINTMENTID,
         ORDERITEMSUBSTATUS,
         ORDERITEMSHIPTOCONTACTID,
         ORDERITEMPRODUCTSCODE,
         ORDERITEMPREVIOUSSERVICEID,
         SERVICEPOINTSERVICEID,
         SERVICEPOINTSTATUS,
         SERVICEPOINTSUBSTATUS,
         SERVICEPOINTHIGHBANDSUBSTATUS,
         ORDERITEMATTRIBNAME,
         ORDERITEMATTRIBCHARVALUE,
         ORDERITEMCREATED,
         ORDERITEMLASTUPDATED,
         ORDERSERVACCTID
         )
         INTO FETCHPROCESS.TMP_OVORDERDETAILS_TAB
         (
         ORDERID,
         ORDERITEMSUBTYPE,
         ORDERVERSIONNUMBER,
         ORDERDATE,
         ORDERITEMID,
         ORDERITEMORDERID,
         ORDERITEMREQSHIPDATE,
         ORDERITEMACTIONCODE,
         ORDERITEMASSETID,
         ORDERITEMPARENTITEMID,
         ORDERITEMROOTITEMID,
         ORDERITEMSERVICENUM,
         ORDERITEMSTATUS,
         ORDERITEMPROMOID,
         ORDERITEMAPPOINTMENTID,
         ORDERITEMSUBSTATUS,
         ORDERITEMSHIPTOCONTACTID,
         ORDERITEMPRODUCTSCODE,
         ORDERITEMPREVIOUSSERVICEID,
         SERVICEPOINTSERVICEID,
         SERVICEPOINTSTATUS,
         SERVICEPOINTSUBSTATUS,
         SERVICEPOINTHIGHBANDSUBSTATUS,
         ORDERITEMATTRIBNAME,
         ORDERITEMATTRIBCHARVALUE,
         ORDERITEMCREATED,
         ORDERITEMLASTUPDATED,
         ORDERSERVACCTID
         )
         values
         (
         ORDERID,
         ORDERITEMSUBTYPE,
         ORDERVERSIONNUMBER,
         ORDERDATE,
         ORDERITEMID,
         ORDERITEMORDERID,
         ORDERITEMREQSHIPDATE,
         ORDERITEMACTIONCODE,
         ORDERITEMASSETID,
         ORDERITEMPARENTITEMID,
         ORDERITEMROOTITEMID,
         ORDERITEMSERVICENUM,
         ORDERITEMSTATUS,
         ORDERITEMPROMOID,
         ORDERITEMAPPOINTMENTID,
         ORDERITEMSUBSTATUS,
         ORDERITEMSHIPTOCONTACTID,
         ORDERITEMPRODUCTSCODE,
         ORDERITEMPREVIOUSSERVICEID,
         SERVICEPOINTSERVICEID,
         SERVICEPOINTSTATUS,
         SERVICEPOINTSUBSTATUS,
         SERVICEPOINTHIGHBANDSUBSTATUS,
         ORDERITEMATTRIBNAME,
         ORDERITEMATTRIBCHARVALUE,
         ORDERITEMCREATED,
         ORDERITEMLASTUPDATED,
         ORDERSERVACCTID
         )
         Select
         Ord.Order_Num Orderid,
         S_Order_X.Attrib_36 Orderitemsubtype,
         Ord.Rev_Num Orderversionnumber,
         Ord.Order_Dt Orderdate,
         Ord_Itm.Row_Id Orderitemid,
         Ord_Itm.Order_Id Orderitemorderid,
         Ord_Itm.Req_Ship_Dt Orderitemreqshipdate,
         Ord_Itm.Action_Cd Orderitemactioncode,
         Ord_Itm.Asset_Id Orderitemassetid,
         Ord_Itm.Par_Order_Item_Id Orderitemparentitemid,
         Ord_Itm.Root_Order_Item_Id Orderitemrootitemid,
         Ord_Itm.Service_Num Orderitemservicenum,
         Ord_Itm.Status_Cd Orderitemstatus,
         Ord_Itm.Promotion_Id Orderitempromoid,
         Ord_Itm.X_Bt_Appointment_Id Orderitemappointmentid,
         Ord_Itm.X_Bt_Sub_Status_Cd Orderitemsubstatus,
         Ord_Itm.Ship_Con_Id Orderitemshiptocontactid,
         Prd_Int.Part_Num Orderitemproductscode,
         Ord_Itm_Om.Prev_Service_Num Orderitempreviousserviceid,
         Sp.Serial_Num Servicepointserviceid,
         Sp.Status_Cd Servicepointstatus,
         Sp.Sub_Status_Cd Servicepointsubstatus,
         Sp.X_Bt_High_Band_Sub_Status Servicepointhighbandsubstatus,
         Xa.Attr_Name Orderitemattribname,
         Xa.Char_Val Orderitemattribcharvalue,
         Ord_Itm.Created Orderitemcreated,
         Ord_Itm.Last_Upd Orderitemlastupdated,
         Ord_Itm.Serv_Accnt_Id Orderservacctid
         FROM 	IDA.S_ORDER_ITEM@bs_prod.world ord_itm,
         	IDA.S_PROD_INT@bs_prod.world  prd_int,
         	IDA.S_ORDER@bs_prod.world ord,
         	IDA.S_ORDER_ITEM_OM@bs_prod.world ord_itm_om,
         	IDA.S_ASSET@bs_prod.world sp,
         	IDA.s_Order_x@bs_prod.world s_order_x,
         	IDA.S_ORDER_ITEM_XA@bs_prod.world XA
         WHERE  ord_itm.prod_id = prd_int.row_id
         AND    ord_itm.row_id = ord_itm_om.par_row_id
         AND    ord_itm.order_id = ord.row_id
         AND    ord_itm.asset_id = sp.row_id(+)
         AND    ord.row_id = s_order_x.par_row_id(+)
         AND    ord_itm.row_id = XA.ORDER_ITEM_ID(+)
         AND    ord.X_BT_EXTERNAL_SYSTEM_TYPE IS NULL
         AND    ord.ACTIVE_FLG = 'Y'
         AND    (EXP_TO_ICTXN_FLG = 'Y' OR FULFIL_LOCKED_FLG = 'Y')
         AND    ord_itm.LAST_UPD BETWEEN :start_date AND :end_date;