SQL Performance (MOSC)

MOSC Banner

A very complex query running long

edited Dec 17, 2013 3:03AM in SQL Performance (MOSC) 8 commentsAnswered

Here is the Query and also attaching explain plan.

The database is standard edition and running on 10.2.0.4.

optimizer_mode                       string      ALL_ROWS

optimizer_features_enable            string      10.2.0.4

optimizer_index_caching              integer     0

INSERT /*+ APPEND */

      INTO  IFACS_SUMMARY_WORK (FVO,

                                CLIENTID,

                                SUBSIDIARY,

                                PLATESOURCE,

                                IA,

                                IANAME,

                                IARESST,

                                IARESCNTRY,

                                IAST,

                                IACNTRY,

                                IAWEBSITE,

                                IATYPE,

                                IATYPEATRESP,

                                IADEF,

                                VIOID,

                                VIONUM,

                                PENALTY,

                                SUSPEND,

                                VIOAMT,

                                CALCAMT,

                                VIOCURR,

                                APT,

                                CALCDAYS,

                                VIODT,

                                VIOTIME,

                                VIOPLATE,

                                VIOPLATEST,

                                VIOTYPE,

                                VIODUEDT,

                                VIONOTICEDT,

                                VIOAFFDUEDT,

                                VIOAFFDUEDTSTARTDT,

                                VIOKEYEDDUEDT,

                                VIOAFFDUEDTCALC,

                                MAILRCVDDT,

                                KEYDT,

                                RELDT,

                                REQDT,

                                RESPDT,

                                LASTRESPERRDT,

                                DOCNUM,

                                BATCHTYPE,

                                BATCHPROCTYPE,

                                FILENAMEUPLD,

                                FILENAMEEVIO,

                                CLIENTRESP,

                                STATRESPPARTY,

                                TYPERESPPARTY,

                                FINLIAB,

                                FINLIABREASON,

                                CLIENTFINLIABEFFDT,

                                RNTFINBILLEDTOCLIENTDT,

                                FINREIMBURSETOCLIENTDT,

                                CENTRALBILLING,

                                TYPERESPPARTYCHGDT,

                                RESPREASON,

                                SOLDSTOLENDT,

                                SALETYPE,

                                RESPTYPE,

                                BPADT,

                                CCNUMPROV,

                                CCCREDITORDEBIT,

                                CCEXPDT,

                                CCADDDT,

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