SQL & PL/SQL

Hi, All,
In the customer's application, there is a such sql as shown below(it is very long, but the structure is not too complicated.) The problem is, when we execute the sql, it eat up nearly 420M pga memory(even when I just use 'trace only', not really execute it). If serveral user execute it concurrently, the ora-4030 will be thrown out. The action plan has been also attachement behind the sql. Since the action plan is extremely too long, I just abstract one part of it.

My question is: Why will the sql eat up so much PGA memory? even just execute it with 'trace only'? the parameter: pga_aggregate_target=139M, why it can not limit the use of PGA?

SELECT DISTINCT "VOUCHER".FID "ID", "VOUCHER".FCompanyID
"COMPANY.ID", "COMPANY".FName_L2 "COMPANY.NAME",
((TO_CHAR("PERIOD".FPeriodYear) || :"SYS_B_0") ||
TO_CHAR("PERIOD".FPeriodNumber)) "PERIOD",
"VOUCHERTYPE".FName_L2 "VOUCHERTYPE.NAME", "VOUCHER".FNumber
"NUMBER", "VOUCHER".FIsCheck "ISCHECK", "VOUCHER".FBookedDate
"BOOKEDDATE", "VOUCHER".FBizDate "BIZDATE",
"VOUCHER".FSourceSys "SOURCESYS", "VOUCHER".FSourceType
"SOURCETYPE", "CASHIER".FName_L2 "CASHIER.NAME",
"AUDITOR".FName_L2 "AUDITOR.NAME", "CREATOR".FName_L2
"CREATOR.NAME", "POSTER".FName_L2 "POSTER.NAME",
"VOUCHER".FBizStatus "BIZSTATUS", "VOUCHER".FEntryCount
"ENTRYCOUNT", "ENTRIES".FID "ENTRIES.ID", "ENTRIES".FSeq
"ENTRIES.SEQ", "ENTRIES".FDescription "ENTRIES.DESCRIPTION",
"ACCOUNT".FNumber "ACCOUNT.NUMBER", "ACCOUNT".FLongName_L2
"ACCOUNT.LONGNAME", "CURRENCY".FName_L2 "CURRENCY.NAME",
"ASSGRP".FLongNameGroup_L2 "ASSGRP.LONGNAMEGROUP",
"CURRENCY".FPrecision "CURRENCY.PRECISION", CASE WHEN
("ASSISTRECORDS".FOriginalAmount IS NULL) THEN
"ENTRIES".FOriginalAmount ELSE
"ASSISTRECORDS".FOriginalAmount END "ENTRIES.ORIGINALAMOUNT",
CASE WHEN ("ENTRIES".FEntryDC > :"SYS_B_1") THEN CASE WHEN
("ASSISTRECORDS".FLocalAmount IS NULL) THEN
"ENTRIES".FLocalAmount ELSE "ASSISTRECORDS".FLocalAmount END
ELSE NULL END "LOCALAMOUNTDEBIT", CASE WHEN
("ENTRIES".FEntryDC > :"SYS_B_2") THEN NULL ELSE CASE WHEN
("ASSISTRECORDS".FLocalAmount IS NULL) THEN
"ENTRIES".FLocalAmount ELSE "ASSISTRECORDS".FLocalAmount END
END "LOCALAMOUNTCREDIT", CASE WHEN ("ENTRIES".FEntryDC >
:"SYS_B_3") THEN CASE WHEN ("ASSISTRECORDS".FReportingAmount
IS NULL) THEN "ENTRIES".FReportingAmount ELSE
"ASSISTRECORDS".FReportingAmount END ELSE NULL END
"REPORTINGAMOUNTDEBIT", CASE WHEN ("ENTRIES".FEntryDC >
:"SYS_B_4") THEN NULL ELSE CASE WHEN
("ASSISTRECORDS".FReportingAmount IS NULL) THEN
"ENTRIES".FReportingAmount ELSE
"ASSISTRECORDS".FReportingAmount END END
"REPORTINGAMOUNTCREDIT", "VOUCHER".FHasCashAccount
"HASCASHACCOUNT", "VOUCHER".FDescription "DESCRIPTION",
"VOUCHER".FAttachments "ATTACHMENTS", "ASSISTRECORDS".FID
"ASSISTRECORDS.ID"
FROM T_GL_Voucher "VOUCHER" LEFT OUTER JOIN T_PM_User
"CASHIER"
ON "VOUCHER".FCashierID = "CASHIER".FID LEFT OUTER JOIN
T_BD_VoucherTypes "VOUCHERTYPE"
ON "VOUCHER".FVoucherTypeID = "VOUCHERTYPE".FID LEFT OUTER
JOIN T_BD_Period "PERIOD"
ON "VOUCHER".FPeriodID = "PERIOD".FID LEFT OUTER JOIN
T_PM_User "AUDITOR"
ON "VOUCHER".FAuditorID = "AUDITOR".FID LEFT OUTER JOIN
T_PM_User "CREATOR"
ON "VOUCHER".FCreatorID = "CREATOR".FID LEFT OUTER JOIN
T_PM_User "POSTER"
ON "VOUCHER".FPosterID = "POSTER".FID INNER JOIN
T_GL_VoucherEntry "ENTRIES"
ON "VOUCHER".FID = "ENTRIES".FBillID LEFT OUTER JOIN
T_ORG_BaseUnit "COMPANY"
ON "VOUCHER".FCompanyID = "COMPANY".FID LEFT OUTER JOIN
T_BD_Currency "CURRENCY"
ON "ENTRIES".FCurrencyID = "CURRENCY".FID LEFT OUTER JOIN
T_BD_AccountView "ACCOUNT"
ON "ENTRIES".FAccountID = "ACCOUNT".FID LEFT OUTER JOIN
T_GL_VoucherAssistRecord "ASSISTRECORDS"
ON "ENTRIES".FID = "ASSISTRECORDS".FEntryID LEFT OUTER JOIN
T_BD_AssistantHG "ASSGRP"
ON "ASSISTRECORDS".FAssGrpID = "ASSGRP".FID
WHERE
((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((("VOUCHER".FID
= :1
AND "ENTRIES".FID = :2)
AND "ASSISTRECORDS".FID = :3) OR (("VOUCHER".FID = :4
AND "ENTRIES".FID = :5)
AND "ASSISTRECORDS".FID = :6)) OR (("VOUCHER".FID = :7
AND "ENTRIES".FID = :8)
AND "ASSISTRECORDS".FID = :9)) OR (("VOUCHER".FID = :10
AND "ENTRIES".FID = :11)
AND "ASSISTRECORDS".FID = :12)) OR (("VOUCHER".FID = :13
AND "ENTRIES".FID = :14)
AND "ASSISTRECORDS".FID = :15)) OR (("VOUCHER".FID = :16
AND "ENTRIES".FID = :17)
AND "ASSISTRECORDS".FID = :18)) OR (("VOUCHER".FID = :19
AND "ENTRIES".FID = :20)
AND "ASSISTRECORDS".FID = :21)) OR (("VOUCHER".FID = :22
AND "ENTRIES".FID = :23)
AND "ASSISTRECORDS".FID = :24)) OR (("VOUCHER".FID = :25
AND "ENTRIES".FID = :26)
AND "ASSISTRECORDS".FID = :27)) OR (("VOUCHER".FID = :28
AND "ENTRIES".FID = :29)
AND "ASSISTRECORDS".FID = :30)) OR (("VOUCHER".FID = :31
AND "ENTRIES".FID = :32)
AND "ASSISTRECORDS".FID = :33)) OR (("VOUCHER".FID = :34
AND "ENTRIES".FID = :35)
AND "ASSISTRECORDS".FID = :36)) OR (("VOUCHER".FID = :37
AND "ENTRIES".FID = :38)
AND "ASSISTRECORDS".FID = :39)) OR (("VOUCHER".FID = :40
AND "ENTRIES".FID = :41)
AND "ASSISTRECORDS".FID = :42)) OR (("VOUCHER".FID = :43
AND "ENTRIES".FID = :44)
AND "ASSISTRECORDS".FID = :45)) OR (("VOUCHER".FID = :46
AND "ENTRIES".FID = :47)
AND "ASSISTRECORDS".FID = :48)) OR (("VOUCHER".FID = :49
AND "ENTRIES".FID = :50)
AND "ASSISTRECORDS".FID = :51)) OR (("VOUCHER".FID = :52
AND "ENTRIES".FID = :53)
AND "ASSISTRECORDS".FID = :54)) OR (("VOUCHER".FID = :55
AND "ENTRIES".FID = :56)
AND "ASSISTRECORDS".FID = :57)) OR (("VOUCHER".FID = :58
AND "ENTRIES".FID = :59)
AND "ASSISTRECORDS".FID = :60)) OR (("VOUCHER".FID = :61
AND "ENTRIES".FID = :62)
AND "ASSISTRECORDS".FID = :63)) OR (("VOUCHER".FID = :64
AND "ENTRIES".FID = :65)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :66
AND "ENTRIES".FID = :67)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :68
AND "ENTRIES".FID = :69)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :70
AND "ENTRIES".FID = :71)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :72
AND "ENTRIES".FID = :73)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :74
AND "ENTRIES".FID = :75)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :76
AND "ENTRIES".FID = :77)
AND "ASSISTRECORDS".FID = :78)) OR (("VOUCHER".FID = :79
AND "ENTRIES".FID = :80)
AND "ASSISTRECORDS".FID = :81)) OR (("VOUCHER".FID = :82
AND "ENTRIES".FID = :83)
AND "ASSISTRECORDS".FID = :84)) OR (("VOUCHER".FID = :85
AND "ENTRIES".FID = :86)
AND "ASSISTRECORDS".FID = :87)) OR (("VOUCHER".FID = :88
AND "ENTRIES".FID = :89)
AND "ASSISTRECORDS".FID = :90)) OR (("VOUCHER".FID = :91
AND "ENTRIES".FID = :92)
AND "ASSISTRECORDS".FID = :93)) OR (("VOUCHER".FID = :94
AND "ENTRIES".FID = :95)
AND "ASSISTRECORDS".FID = :96)) OR (("VOUCHER".FID = :97
AND "ENTRIES".FID = :98)
AND "ASSISTRECORDS".FID = :99)) OR (("VOUCHER".FID = :100
AND "ENTRIES".FID = :101)
AND "ASSISTRECORDS".FID = :102)) OR (("VOUCHER".FID = :103
AND "ENTRIES".FID = :104)
AND "ASSISTRECORDS".FID = :105)) OR (("VOUCHER".FID = :106
AND "ENTRIES".FID = :107)
AND "ASSISTRECORDS".FID = :108)) OR (("VOUCHER".FID = :109
AND "ENTRIES".FID = :110)
AND "ASSISTRECORDS".FID = :111)) OR (("VOUCHER".FID = :112
AND "ENTRIES".FID = :113)
AND "ASSISTRECORDS".FID = :114)) OR (("VOUCHER".FID = :115
AND "ENTRIES".FID = :116)
AND "ASSISTRECORDS".FID = :117)) OR (("VOUCHER".FID = :118
AND "ENTRIES".FID = :119)
AND "ASSISTRECORDS".FID = :120)) OR (("VOUCHER".FID = :121
AND "ENTRIES".FID = :122)
AND "ASSISTRECORDS".FID = :123)) OR (("VOUCHER".FID = :124
AND "ENTRIES".FID = :125)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :126
AND "ENTRIES".FID = :127)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :128
AND "ENTRIES".FID = :129)
AND "ASSISTRECORDS".FID = :130)) OR (("VOUCHER".FID = :131
AND "ENTRIES".FID = :132)
AND "ASSISTRECORDS".FID = :133)) OR (("VOUCHER".FID = :134
AND "ENTRIES".FID = :135)
AND "ASSISTRECORDS".FID = :136)) OR (("VOUCHER".FID = :137
AND "ENTRIES".FID = :138)
AND "ASSISTRECORDS".FID = :139)) OR (("VOUCHER".FID = :140
AND "ENTRIES".FID = :141)
AND "ASSISTRECORDS".FID = :142)) OR (("VOUCHER".FID = :143
AND "ENTRIES".FID = :144)
AND "ASSISTRECORDS".FID = :145)) OR (("VOUCHER".FID = :146
AND "ENTRIES".FID = :147)
AND "ASSISTRECORDS".FID = :148)) OR (("VOUCHER".FID = :149
AND "ENTRIES".FID = :150)
AND "ASSISTRECORDS".FID = :151)) OR (("VOUCHER".FID = :152
AND "ENTRIES".FID = :153)
AND "ASSISTRECORDS".FID = :154)) OR (("VOUCHER".FID = :155
AND "ENTRIES".FID = :156)
AND "ASSISTRECORDS".FID = :157)) OR (("VOUCHER".FID = :158
AND "ENTRIES".FID = :159)
AND "ASSISTRECORDS".FID = :160)) OR (("VOUCHER".FID = :161
AND "ENTRIES".FID = :162)
AND "ASSISTRECORDS".FID = :163)) OR (("VOUCHER".FID = :164
AND "ENTRIES".FID = :165)
AND "ASSISTRECORDS".FID = :166)) OR (("VOUCHER".FID = :167
AND "ENTRIES".FID = :168)
AND "ASSISTRECORDS".FID = :169)) OR (("VOUCHER".FID = :170
AND "ENTRIES".FID = :171)
AND "ASSISTRECORDS".FID = :172)) OR (("VOUCHER".FID = :173
AND "ENTRIES".FID = :174)
AND "ASSISTRECORDS".FID = :175)) OR (("VOUCHER".FID = :176
AND "ENTRIES".FID = :177)
AND "ASSISTRECORDS".FID = :178)) OR (("VOUCHER".FID = :179
AND "ENTRIES".FID = :180)
AND "ASSISTRECORDS".FID = :181)) OR (("VOUCHER".FID = :182
AND "ENTRIES".FID = :183)
AND "ASSISTRECORDS".FID = :184)) OR (("VOUCHER".FID = :185
AND "ENTRIES".FID = :186)
AND "ASSISTRECORDS".FID = :187)) OR (("VOUCHER".FID = :188
AND "ENTRIES".FID = :189)
AND "ASSISTRECORDS".FID = :190)) OR (("VOUCHER".FID = :191
AND "ENTRIES".FID = :192)
AND "ASSISTRECORDS".FID = :193)) OR (("VOUCHER".FID = :194
AND "ENTRIES".FID = :195)
AND "ASSISTRECORDS".FID = :196)) OR (("VOUCHER".FID = :197
AND "ENTRIES".FID = :198)
AND "ASSISTRECORDS".FID = :199)) OR (("VOUCHER".FID = :200
AND "ENTRIES".FID = :201)
AND "ASSISTRECORDS".FID = :202)) OR (("VOUCHER".FID = :203
AND "ENTRIES".FID = :204)
AND "ASSISTRECORDS".FID = :205)) OR (("VOUCHER".FID = :206
AND "ENTRIES".FID = :207)
AND "ASSISTRECORDS".FID = :208)) OR (("VOUCHER".FID = :209
AND "ENTRIES".FID = :210)
AND "ASSISTRECORDS".FID = :211)) OR (("VOUCHER".FID = :212
AND "ENTRIES".FID = :213)
AND "ASSISTRECORDS".FID = :214)) OR (("VOUCHER".FID = :215
AND "ENTRIES".FID = :216)
AND "ASSISTRECORDS".FID = :217)) OR (("VOUCHER".FID = :218
AND "ENTRIES".FID = :219)
AND "ASSISTRECORDS".FID = :220)) OR (("VOUCHER".FID = :221
AND "ENTRIES".FID = :222)
AND "ASSISTRECORDS".FID = :223)) OR (("VOUCHER".FID = :224
AND "ENTRIES".FID = :225)
AND "ASSISTRECORDS".FID = :226)) OR (("VOUCHER".FID = :227
AND "ENTRIES".FID = :228)
AND "ASSISTRECORDS".FID = :229)) OR (("VOUCHER".FID = :230
AND "ENTRIES".FID = :231)
AND "ASSISTRECORDS".FID = :232)) OR (("VOUCHER".FID = :233
AND "ENTRIES".FID = :234)
AND "ASSISTRECORDS".FID = :235)) OR (("VOUCHER".FID = :236
AND "ENTRIES".FID = :237)
AND "ASSISTRECORDS".FID = :238)) OR (("VOUCHER".FID = :239
AND "ENTRIES".FID = :240)
AND "ASSISTRECORDS".FID = :241)) OR (("VOUCHER".FID = :242
AND "ENTRIES".FID = :243)
AND "ASSISTRECORDS".FID = :244)) OR (("VOUCHER".FID = :245
AND "ENTRIES".FID = :246)
AND "ASSISTRECORDS".FID = :247)) OR (("VOUCHER".FID = :248
AND "ENTRIES".FID = :249)
AND "ASSISTRECORDS".FID = :250)) OR (("VOUCHER".FID = :251
AND "ENTRIES".FID = :252)
AND "ASSISTRECORDS".FID = :253)) OR (("VOUCHER".FID = :254
AND "ENTRIES".FID = :255)
AND "ASSISTRECORDS".FID = :256)) OR (("VOUCHER".FID = :257
AND "ENTRIES".FID = :258)
AND ("ASSISTRECORDS".FID IS NULL))) OR (("VOUCHER".FID = :259
AND "ENTRIES".FID = :260)
AND "ASSISTRECORDS".FID = :261)) OR (("VOUCHER".FID = :262
AND "ENTRIES".FID = :263)
AND "ASSISTRECORDS".FID = :264)) OR (("VOUCHER".FID = :265
AND "ENTRIES".FID = :266)
AND "ASSISTRECORDS".FID = :267)) OR (("VOUCHER".FID = :268
AND "ENTRIES".FID = :269)
AND "ASSISTRECORDS".FID = :270)) OR (("VOUCHER".FID = :271
AND "ENTRIES".FID = :272)
AND "ASSISTRECORDS".FID = :273)) OR (("VOUCHER".FID = :274
AND "ENTRIES".FID = :275)
AND "ASSISTRECORDS".FID = :276)) OR (("VOUCHER".FID = :277
AND "ENTRIES".FID = :278)
AND "ASSISTRECORDS".FID = :279)) OR (("VOUCHER".FID = :280
AND "ENTRIES".FID = :281)
AND "ASSISTRECORDS".FID = :282)) OR (("VOUCHER".FID = :283
AND "ENTRIES".FID = :284)
AND "ASSISTRECORDS".FID = :285)) OR (("VOUCHER".FID = :286
AND "ENTRIES".FID = :287)
AND "ASSISTRECORDS".FID = :288)) OR (("VOUCHER".FID = :289
AND "ENTRIES".FID = :290)
AND "ASSISTRECORDS".FID = :291)) ORDER BY
"VOUCHERTYPE".FName_L2 ASC, "VOUCHER".FNumber DESC,
"VOUCHER".FID ASC, "ENTRIES".FSeq ASC


Action Plan:
I have cut off the repeated part, and just showed out the action plan for the first two where clause.
SELECT STATEMENT, GOAL = ALL_ROWS Cost=9391103 Cardinality=32115733 Bytes=33047089257
SORT UNIQUE Cost=1758 Cardinality=32115733 Bytes=33047089257
CONCATENATION
NESTED LOOPS OUTER Cost=17 Cardinality=1 Bytes=1029
NESTED LOOPS OUTER Cost=16 Cardinality=1 Bytes=940
NESTED LOOPS OUTER Cost=15 Cardinality=1 Bytes=901
NESTED LOOPS OUTER Cost=14 Cardinality=1 Bytes=855
NESTED LOOPS OUTER Cost=13 Cardinality=1 Bytes=819
NESTED LOOPS OUTER Cost=12 Cardinality=1 Bytes=780
NESTED LOOPS OUTER Cost=11 Cardinality=1 Bytes=741
NESTED LOOPS OUTER Cost=10 Cardinality=1 Bytes=702
NESTED LOOPS OUTER Cost=9 Cardinality=1 Bytes=649
NESTED LOOPS OUTER Cost=8 Cardinality=1 Bytes=604
FILTER
NESTED LOOPS OUTER Cost=7 Cardinality=1 Bytes=532
NESTED LOOPS Cost=4 Cardinality=1 Bytes=433
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_GL_VOUCHERENTRY Cost=3 Cardinality=1 Bytes=164
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_GL_VCHENTRY Cost=2 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_GL_VOUCHER Cost=1 Cardinality=1 Bytes=269
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_GL_VCH Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_GL_VOUCHERASSISTRECORD Cost=3 Cardinality=505544 Bytes=50048856
INDEX RANGE SCAN Object owner=PLANBUG Object name=IX_GL_VCHASSREC_1 Cost=2 Cardinality=7
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_ACCOUNTVIEW Cost=1 Cardinality=23495 Bytes=1691640
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_BD_ACCOUNTVIEW Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_CURRENCY Cost=1 Cardinality=18 Bytes=810
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_BD_CURRENCY Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_ORG_BASEUNIT Cost=1 Cardinality=709 Bytes=37577
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_ORG_FULLORGUNIT Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_PERIOD Cost=1 Cardinality=252 Bytes=9072
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PERIOD Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_VOUCHERTYPES Cost=1 Cardinality=9 Bytes=414
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_VOUCHERTYPE Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_ASSISTANTHG Cost=1 Cardinality=8106 Bytes=721434
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_BD_ASSISTANTHG Cost=0 Cardinality=1
NESTED LOOPS OUTER Cost=17 Cardinality=1 Bytes=1029
NESTED LOOPS OUTER Cost=16 Cardinality=1 Bytes=940
NESTED LOOPS OUTER Cost=15 Cardinality=1 Bytes=901
NESTED LOOPS OUTER Cost=14 Cardinality=1 Bytes=855
NESTED LOOPS OUTER Cost=13 Cardinality=1 Bytes=819
NESTED LOOPS OUTER Cost=12 Cardinality=1 Bytes=780
NESTED LOOPS OUTER Cost=11 Cardinality=1 Bytes=741
NESTED LOOPS OUTER Cost=10 Cardinality=1 Bytes=702
NESTED LOOPS OUTER Cost=9 Cardinality=1 Bytes=649
NESTED LOOPS OUTER Cost=8 Cardinality=1 Bytes=604
FILTER
NESTED LOOPS OUTER Cost=7 Cardinality=1 Bytes=532
NESTED LOOPS Cost=4 Cardinality=1 Bytes=433
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_GL_VOUCHERENTRY Cost=3 Cardinality=1 Bytes=164
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_GL_VCHENTRY Cost=2 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_GL_VOUCHER Cost=1 Cardinality=1 Bytes=269
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_GL_VCH Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_GL_VOUCHERASSISTRECORD Cost=3 Cardinality=505544 Bytes=50048856
INDEX RANGE SCAN Object owner=PLANBUG Object name=IX_GL_VCHASSREC_1 Cost=2 Cardinality=7
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_ACCOUNTVIEW Cost=1 Cardinality=23495 Bytes=1691640
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_BD_ACCOUNTVIEW Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_CURRENCY Cost=1 Cardinality=18 Bytes=810
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_BD_CURRENCY Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_ORG_BASEUNIT Cost=1 Cardinality=709 Bytes=37577
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_ORG_FULLORGUNIT Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_PERIOD Cost=1 Cardinality=252 Bytes=9072
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PERIOD Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_VOUCHERTYPES Cost=1 Cardinality=9 Bytes=414
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_VOUCHERTYPE Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_PM_USER Cost=1 Cardinality=566 Bytes=22074
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_PM_USER Cost=0 Cardinality=1
TABLE ACCESS BY INDEX ROWID Object owner=PLANBUG Object name=T_BD_ASSISTANTHG Cost=1 Cardinality=8106 Bytes=721434
INDEX UNIQUE SCAN Object owner=PLANBUG Object name=PK_BD_ASSISTANTHG Cost=0 Cardinality=1