Exadata General (MOSC)

MOSC Banner

Performance issue

edited Dec 18, 2019 4:07AM in Exadata General (MOSC) 1 commentAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center