Performance issue
We have a query running on top of Exacs. Issue:-The query is eating up all the temp space allocated(which is 2 tb). Could anyone give us any pointer where to look into it for proper resolutions.
Query:-
/* Formatted on 27-11-2019 14:18:40 (QP5 v5.215.12089.38647) */
INSERT /*+ append */
INTO BIA_DW.W_SLA_XACT_F T (GL_ACCOUNT_WID,
LEDGER_WID,
COMPANY_ORG_WID,
BALANCING_SEGMENT_WID,
COST_CENTER_WID,
CUSTOMER_WID,
CUSTOMER_ACCT_WID,
SUPPLIER_WID,
SUPPLIER_ACCT_WID,
RECEIVABLES_ORG_WID,
PAYABLES_ORG_WID,
GL_SEGMENT1_WID,
GL_SEGMENT2_WID,
SUPPORT_REF1_WID,
SUPPORT_REF2_WID,
SUPPORT_REF3_WID,
SUPPORT_REF4_WID,