Received: by 10.52.69.241 with SMTP id h17mr16349556vdu.5.1340188555319;
        Wed, 20 Jun 2012 03:35:55 -0700 (PDT)
X-BeenThere: lvoug@googlegroups.com
Received: by 10.220.230.193 with SMTP id jn1ls1512355vcb.8.gmail; Wed, 20 Jun
 2012 03:35:54 -0700 (PDT)
Received: by 10.52.178.166 with SMTP id cz6mr16358438vdc.1.1340188553970;
        Wed, 20 Jun 2012 03:35:53 -0700 (PDT)
Received: by 10.52.178.166 with SMTP id cz6mr16358437vdc.1.1340188553935;
        Wed, 20 Jun 2012 03:35:53 -0700 (PDT)
Return-Path: <andrejs.vorobj...@gmail.com>
Received: from mail-vc0-f174.google.com (mail-vc0-f174.google.com [209.85.220.174])
        by gmr-mx.google.com with ESMTPS id l12si7638452vdf.3.2012.06.20.03.35.53
        (version=TLSv1/SSLv3 cipher=OTHER);
        Wed, 20 Jun 2012 03:35:53 -0700 (PDT)
Received-SPF: pass (google.com: domain of andrejs.vorobj...@gmail.com designates 209.85.220.174 as permitted sender) client-ip=209.85.220.174;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of andrejs.vorobj...@gmail.com designates 209.85.220.174 as permitted sender) smtp.mail=andrejs.vorobj...@gmail.com; dkim=pass header...@gmail.com
Received: by mail-vc0-f174.google.com with SMTP id f11so4321040vcb.5
        for <lvoug@googlegroups.com>; Wed, 20 Jun 2012 03:35:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=USnbQlY5Uz5R6rxORmF0HXP5PkIwTZwv8pu2yqJTGrc=;
        b=AJuDOoNp2GMh4WlQb3C6Oe6UAqGxkCuKXzOF0FTKEPiBk18xPSBkT/T1k8Sp0RtLNJ
         waesSayvDs4K3xzypHhJ6JtpQX215JPu8/KLBfDz9RGkFx4yDrgLaetGgX4TEosqi9E1
         EQG4cp3HdqQQTaqxFmVclzELjjNSVv4d1tJ7Xq7mV9XGJ7CBVbNbqXqPLPbEYfTdT25z
         NjTNeZucwDfVVKX0aBk19aQAzEYPtCfazzw2jBS61dtpJ4divhw8nCHzLc9WlnOOQNzH
         a0qXMTOWT1RJ/eFY1Drk6N718L6YGdtKLYE+uz7NEVI7peiQoPoZFp7kB+mTrFnDJjsQ
         aqrA==
MIME-Version: 1.0
Received: by 10.52.98.8 with SMTP id ee8mr9218217vdb.58.1340188553695; Wed, 20
 Jun 2012 03:35:53 -0700 (PDT)
Received: by 10.220.59.68 with HTTP; Wed, 20 Jun 2012 03:35:53 -0700 (PDT)
In-Reply-To: <CABQhObsT=GYLVaKLaRkQ2_f0XNQmM_e83qeDQ7K2LrOJ1wb...@mail.gmail.com>
References: <448c2231-3466-419c-b5b8-610c3a937...@s9g2000vbg.googlegroups.com>
	<CABQhObuWaFL_kmx-37QmrbXaPNT+s4fGmm-EhPfwyHwWdfv...@mail.gmail.com>
	<b1c2d53d-2e2f-4c2f-bdcc-56f97b553...@v9g2000vbc.googlegroups.com>
	<CABQhObsT=GYLVaKLaRkQ2_f0XNQmM_e83qeDQ7K2LrOJ1wb...@mail.gmail.com>
Date: Wed, 20 Jun 2012 13:35:53 +0300
Message-ID: <CAMWF3_=4ZSWQDPNaW9aZ8doAa8mkLMUfRFC+Ev0Ps41uzoi...@mail.gmail.com>
Subject: =?ISO-8859-13?B?UmU6IFZlaWt0c3DnamFzIHByb2Js521hcyBw4nJlamFzIG5vIDEwLjIuMC40IHV6IA==?=
	=?ISO-8859-13?B?MTEuMi4wLjM=?=
From: Andrejs Vorobjovs <andrejs.vorobj...@gmail.com>
To: lvoug@googlegroups.com
Content-Type: multipart/mixed; boundary=20cf307f33eeacd35904c2e4f6c8

--20cf307f33eeacd35904c2e4f6c8
Content-Type: multipart/alternative; boundary=20cf307f33eeacd35404c2e4f6c6

--20cf307f33eeacd35404c2e4f6c6
Content-Type: text/plain; charset=ISO-8859-13
Content-Transfer-Encoding: quoted-printable

 TEST
var atbild=E7t uz mailu lvoug@googlegroups.com ar attachmentu.

Andrejs.

2012/6/20 Maris Elsins <elma...@gmail.com>

> Hi,
>
> Interesanti ir,
> bet izpildpl=E2ns tik slikti saformat=E7ts, ka negribas nemaz skat=EEties=
...
> ---
> M=E2ris Elsi=F2=F0
>
>
>
> 2012/6/19 Uldis P=E2vuls <uldis...@gmail.com>
>
>> Labvakar!
>> Vispirms paldies visiem, kas atsauc=E2s - gan =F0eit, gan person=EEgi; =
=EEpa=F0i
>> Andrey Chervonec par da=FE=E2m man l=EEdz =F0im nezin=E2m=E2m MOS nor=E2=
d=E7m.
>> Atvainojos ar=EE, ka tik ilgi nevar=E7ju atbild=E7t - vienk=E2r=F0i iekr=
ita
>> slodze, viss san=E2ca kop=E2, neatradu laiku.
>> Probl=E7ma gan v=E7l p=E7c b=FBt=EEbas nav atrisin=E2jusies. Kol=E7=ECis=
 p=E2rrakst=EEja
>> pras=EEjumu cit=E2di, un t=E2 tas iet griezdamies, bet ar izma=F2=E2m ko=
d=E2 ir
>> liela =ED=E7pa, pirmk=E2rt jau birokr=E2tiska, par papildus test=E7=F0an=
u nemaz
>> nerun=E2jot. Turkl=E2t gribas ar=EE skaidr=EEbu par to, kas notiek, lai =
p=E7c
>> tam uz t=E2 pa=F0a gr=E2bek=EFa nek=E2ptu.
>> Ar to tras=E7=F0anu ir zin=E2mas gr=FBt=EEbas. K=E2 jau teicu, otr=E2 ga=
l=E2 ir
>> weblogic. Test=E7=F0ana ar=EE ir automatiz=E7ta, un =F0aj=E2 konkr=E7taj=
=E2 lietojum=E2
>> (k=E2 daudzos citos) uzdevumi (un jaunas sesijas) tiek palaistas ar
>> pogas piespiedienu: iepauz=E7t, lai notvertu vajadz=EEgo sesiju un uzlik=
tu
>> tai 10046 vai 10053, faktiski nav iesp=E7jams. Tiesa, ar AWR un ASH
>> pal=EEdz=EEbu izdev=E2s izdal=EEt vain=EEgos pras=EEjumus, un te s=E2k=
=E2s br=EEnumi.
>> Faktiski jau tas ir galvenais, k=E2d=E7=EF rakstu; dom=E2ju, ka ar=EE ci=
tiem b=FBs
>> interesanti, un varb=FBt k=E2dam b=FBs k=E2da ideja. (Ceru tikai, ka v=
=E7stule
>> neb=FBs p=E2r=E2k gara un ievietosies; aprobe=FEo=F0os ar izteiksm=EEg=
=E2ko piem=E7ru)
>> Visu pras=EEjumu es te nelik=F0u, tikai apcirpto vaiantu. Pilnais satur
>> v=E7l l=E7rumu kolonu, t.sk. ar apak=F0pras=EEjumiem (subqueries). S=E2l=
s ir
>> WHERE, par to es p=E2rliecin=E2jos.
>> T=E2tad:
>> SELECT
>>  /*+ FIRST_ROWS(500) */
>>  T1.rif_id        AS S0,
>>  T1.rif_id        AS S1,
>>  T1.rif_reference AS S2
>> FROM erif_rif_risk_category_V T0,
>>  erif_rif_V T1
>> WHERE (T0.rif_id(+)=3DT1.rif_id)
>> AND (T0.wp_id(+)   =3DT1.wp_id)
>> AND (((EXISTS
>>  (SELECT 1 FROM erif_rif_accessible_V accv WHERE accv.rif_id =3D
>> T1.rif_id
>>  )))
>> AND(NOT EXISTS
>>  (SELECT 1 FROM erif_rif_archive_v WHERE rif_id =3D T1.rif_id
>>  )))
>> ORDER BY S0 DESC,
>>  S1 desc
>>
>>
>>
>>
>>
>>
>>
>>
>> J=E2, te ir EXIST/NOT EXIST un paties=EEb=E2 nav nevienas tie=F0i min=E7=
tas
>> tabulas, tika skati (views), kuros ar=EE ir EXIST.
>> Tagad at=EFau=F0os ievietot, ko r=E2da autotrace ab=E2s versij=E2s, ceru=
 ka
>> iel=EEd=EEs. Atg=E2din=E2=F0u, ka datu b=E2zes ir vienas izcelsmes, shem=
as
>> praktiski neat=F0=EDiras (ar=EE s=E2kotn=E7ji no vienas datnes import=E7=
tas).
>> optimizer_dynamic_sampling=3D4 ; viens no kol=E7=ECiem ierosin=E2ja, bet=
 tas
>> neko neizmain=EEja, tik vien k=E2 pielika piez=EEmi beig=E2s.
>> Bet piev=E7rsiet uzman=EEbu starp=EEbai "consistent gets"  - t=E2p=E7c j=
au 11G
>> ar=EE CPU str=E2d=E2 r=FBkdams un liek dom=E2t, ka kaut kas svar=EEgs ti=
ek
>> dar=EEts... 11G tas ir 1066 reizes vair=E2k.
>> 10.2.0.4:
>> 161 rows selected.
>>
>>
>>
>>
>> Elapsed: 00:00:19.91
>>
>>
>>
>>
>> Execution Plan
>> ----------------------------------------------------------
>> Plan hash value: 1236651934
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------=
-------------------------------------------------------
>> | Id  | Operation                                       | Name
>>               | Rows  | Bytes | Cost (%CPU)| Time     |
>>
>> ------------------------------------------------------------------------=
-------------------------------------------------------
>> |   0 | SELECT STATEMENT                                |
>>                |     2 |   290 |    10  (20)| 00:00:01 |
>> |   1 |  SORT ORDER BY                                  |
>>                |     2 |   290 |    10  (20)| 00:00:01 |
>> |   2 |   NESTED LOOPS OUTER                            |
>>                |     1 |   145 |     7  (15)| 00:00:01 |
>> |   3 |    NESTED LOOPS ANTI                            |
>>                |     1 |   102 |     5  (20)| 00:00:01 |
>> |   4 |     NESTED LOOPS                                |
>>                |     1 |    93 |     5  (20)| 00:00:01 |
>> |   5 |      SORT UNIQUE                                |
>>                |     2 |    66 |     2   (0)| 00:00:01 |
>> |   6 |       VIEW                                      |
>> ERIF_RIF_ACCESSIBLE_V       |     2 |    66 |     2   (0)| 00:00:01 |
>> |   7 |        UNION-ALL                                |
>>                |       |       |            |          |
>> |   8 |         NESTED LOOPS ANTI                       |
>>                |     1 |   153 |   482   (3)| 00:00:06 |
>> |*  9 |          FILTER                                 |
>>                |       |       |            |          |
>> |* 10 |           HASH JOIN OUTER                       |
>>                |     1 |   144 |   482   (3)| 00:00:06 |
>> |  11 |            MERGE JOIN CARTESIAN                 |
>>                |     1 |   106 |   211   (3)| 00:00:03 |
>> |* 12 |             FILTER                              |
>>                |       |       |            |          |
>> |* 13 |              HASH JOIN RIGHT OUTER              |
>>                |     1 |    89 |   186   (3)| 00:00:03 |
>> |  14 |               VIEW                              |
>> ERIF_RIF_TARGETED_GROUP_V   |  4118 |   184K|    22  (10)| 00:00:01 |
>> |  15 |                NESTED LOOPS ANTI                |
>>                |  4118 |   241K|    22  (10)| 00:00:01 |
>> |  16 |                 TABLE ACCESS FULL               |
>> ERIF_RIF_TARGETED_GROUP     |  6584 |   327K|    20   (0)| 00:00:01 |
>> |* 17 |                 INDEX UNIQUE SCAN               |
>> WP_PENDING_PK               |   924 |  8316 |     0   (0)| 00:00:01 |
>> |  18 |               VIEW                              | index$_join
>> $_026            | 11327 |   475K|   163   (2)| 00:00:02 |
>> |* 19 |                HASH JOIN                        |
>>                |       |       |            |          |
>> |  20 |                 INDEX FAST FULL SCAN            | ERIF_RIFWPUK
>>               | 11327 |   475K|    73   (0)| 00:00:01 |
>> |  21 |                 INDEX FAST FULL SCAN            | ERIF_RIF_PK
>>                | 11327 |   475K|    89   (0)| 00:00:02 |
>> |  22 |             BUFFER SORT                         |
>>                |  8168 |   135K|   211   (3)| 00:00:03 |
>> |  23 |              VIEW                               | VW_NSO_1
>>               |  8168 |   135K|    26   (8)| 00:00:01 |
>> |  24 |               HASH UNIQUE                       |
>>                |  8168 | 16336 |    26   (8)| 00:00:01 |
>> |  25 |                COLLECTION ITERATOR PICKLER FETCH|
>> GETRISKCATEGORY             |       |       |            |          |
>> |  26 |            VIEW                                 |
>> ERIF_RIF_RISK_CATEGORY_VH   |  9336 |   346K|   269   (3)| 00:00:04 |
>> |  27 |             UNION-ALL                           |
>>                |       |       |            |          |
>> |  28 |              NESTED LOOPS ANTI                  |
>>                |  9335 |   519K|   258   (3)| 00:00:04 |
>> |  29 |               VIEW                              | index$_join
>> $_020            | 11933 |   559K|   255   (2)| 00:00:04 |
>> |* 30 |                HASH JOIN                        |
>>                |       |       |            |          |
>> |* 31 |                 HASH JOIN                       |
>>                |       |       |            |          |
>> |  32 |                  INDEX FAST FULL SCAN           |
>> ERIF_RIF_RISK_CATEGORY_IDX1 | 11933 |   559K|    35   (0)| 00:00:01 |
>> |  33 |                  INDEX FAST FULL SCAN           |
>> ERIF_RIF_RISK_CATEGORYWPUK  | 11933 |   559K|    78   (0)| 00:00:01 |
>> |  34 |                 INDEX FAST FULL SCAN            |
>> ERIF_RIF_RISK_CATEGORY_PK   | 11933 |   559K|   104   (0)| 00:00:02 |
>> |* 35 |               INDEX UNIQUE SCAN                 |
>> WP_PENDING_PK               |   537 |  4833 |     0   (0)| 00:00:01 |
>> |  36 |              NESTED LOOPS ANTI                  |
>>                |     1 |    57 |    12   (9)| 00:00:01 |
>> |  37 |               TABLE ACCESS FULL                 |
>> ERIF_RIF_RISK_CATEGORY_H    |  2594 |   121K|    11   (0)| 00:00:01 |
>> |* 38 |               INDEX UNIQUE SCAN                 |
>> WP_PENDING_PK               |  2465 | 22185 |     0   (0)| 00:00:01 |
>> |* 39 |          INDEX UNIQUE SCAN                      |
>> WP_PENDING_PK               |   537 |  4833 |     0   (0)| 00:00:01 |
>> |* 40 |         FILTER                                  |
>>                |       |       |            |          |
>> |  41 |          NESTED LOOPS ANTI                      |
>>                |     1 |   162 |    26   (4)| 00:00:01 |
>> |  42 |           NESTED LOOPS ANTI                     |
>>                |     1 |   153 |    26   (4)| 00:00:01 |
>> |  43 |            NESTED LOOPS                         |
>>                |     1 |   144 |    26   (4)| 00:00:01 |
>> |* 44 |             HASH JOIN                           |
>>                |     1 |    93 |    24   (5)| 00:00:01 |
>> |  45 |              NESTED LOOPS ANTI                  |
>>                |     1 |    42 |     3   (0)| 00:00:01 |
>> |  46 |               TABLE ACCESS FULL                 |
>> ERIF_TARGETED_GROUP_VP      |    14 |   462 |     3   (0)| 00:00:01 |
>> |* 47 |               INDEX UNIQUE SCAN                 |
>> WP_PENDING_PK               |  2466 | 22194 |     0   (0)| 00:00:01 |
>> |  48 |              TABLE ACCESS FULL                  |
>> ERIF_RIF_TARGETED_GROUP     |  6584 |   327K|    20   (0)| 00:00:01 |
>> |* 49 |             TABLE ACCESS BY INDEX ROWID         | ERIF_RIF
>>               |     1 |    51 |     2   (0)| 00:00:01 |
>> |* 50 |              INDEX RANGE SCAN                   | ERIF_RIF_PK
>>                |     1 |       |     1   (0)| 00:00:01 |
>> |* 51 |            INDEX UNIQUE SCAN                    |
>> WP_PENDING_PK               |   537 |  4833 |     0   (0)| 00:00:01 |
>> |* 52 |           INDEX UNIQUE SCAN                     |
>> WP_PENDING_PK               |   924 |  8316 |     0   (0)| 00:00:01 |
>> |* 53 |          FILTER                                 |
>>                |       |       |            |          |
>> |  54 |           NESTED LOOPS                          |
>>                |     1 |    86 |     5   (0)| 00:00:01 |
>> |  55 |            NESTED LOOPS ANTI                    |
>>                |     1 |    33 |     4   (0)| 00:00:01 |
>> |* 56 |             TABLE ACCESS FULL                   |
>> ERIF_TARGETED_GROUP_MEMBER  |    72 |  1728 |     4   (0)| 00:00:01 |
>> |* 57 |             INDEX UNIQUE SCAN                   |
>> WP_PENDING_PK               |  2466 | 22194 |     0   (0)| 00:00:01 |
>> |* 58 |            TABLE ACCESS CLUSTER                 |
>> ERIF_ORGANISATION_MEMBER    |     1 |    53 |     1   (0)| 00:00:01 |
>> |* 59 |             INDEX UNIQUE SCAN                   |
>> ERIF_ORGANISATION_CLUST_IDX |     1 |       |     0   (0)| 00:00:01 |
>> |* 60 |           INDEX FAST FULL SCAN                  |
>> WP_PENDING_PK               |     1 |     9 |     3   (0)| 00:00:01 |
>> |  61 |      TABLE ACCESS BY INDEX ROWID                | ERIF_RIF
>>               |     1 |    60 |     2   (0)| 00:00:01 |
>> |* 62 |       INDEX RANGE SCAN                          | ERIF_RIF_PK
>>                |     1 |       |     1   (0)| 00:00:01 |
>> |  63 |        NESTED LOOPS ANTI                        |
>>                |     1 |    52 |     2   (0)| 00:00:01 |
>> |  64 |         TABLE ACCESS BY INDEX ROWID             |
>> ERIF_RIF_ARCHIVE            |     1 |    43 |     2   (0)| 00:00:01 |
>> |* 65 |          INDEX RANGE SCAN                       |
>> ERIF_RIF_ARCHIVE_PK         |     1 |       |     1   (0)| 00:00:01 |
>> |* 66 |         INDEX UNIQUE SCAN                       |
>> WP_PENDING_PK               |  2466 | 22194 |     0   (0)| 00:00:01 |
>> |* 67 |     INDEX UNIQUE SCAN                           |
>> WP_PENDING_PK               |   537 |  4833 |     0   (0)| 00:00:01 |
>> |* 68 |    VIEW PUSHED PREDICATE                        |
>> ERIF_RIF_RISK_CATEGORY_V    |     1 |    43 |     2   (0)| 00:00:01 |
>> |  69 |     NESTED LOOPS ANTI                           |
>>                |     1 |    52 |     3   (0)| 00:00:01 |
>> |  70 |      TABLE ACCESS BY INDEX ROWID                |
>> ERIF_RIF_RISK_CATEGORY      |     1 |    43 |     3   (0)| 00:00:01 |
>> |* 71 |       INDEX RANGE SCAN                          |
>> ERIF_RIF_RISK_CATEGORYWPUK  |     1 |       |     2   (0)| 00:00:01 |
>> |* 72 |      INDEX UNIQUE SCAN                          |
>> WP_PENDING_PK               |  2466 | 22194 |     0   (0)| 00:00:01 |
>>
>> ------------------------------------------------------------------------=
-------------------------------------------------------
>>
>>
>>
>>
>> Predicate Information (identified by operation id):
>> ---------------------------------------------------
>>
>>
>>
>>
>>   9 - filter(DECODE("RIFRC"."CATEGORY_CODE",NULL,
>> 0,TO_NUMBER("RIFRC"."CATEGORY_CODE"))=3DTO_NUMBER("$nso_col_1"))
>>  10 - access("RIFRC"."RIF_ID"(+)=3D"RIF_ID")
>>  12 - filter("RIFTG"."TARGETED_GROUP_ID" IS NULL)
>>  13 - access("RIFTG"."RIF_ID"(+)=3D"RIF_ID")
>>  17 - access("WP_ID"=3D"WP_ID")
>>  19 - access(ROWID=3DROWID)
>>  30 - access(ROWID=3DROWID)
>>  31 - access(ROWID=3DROWID)
>>  35 - access("WP_ID"=3D"WP_ID")
>>  38 - access("WP_ID"=3D"WP_ID")
>>  39 - access("WP_ID"=3D"WP_ID")
>>  40 - filter("CLOSED"=3D0 OR "CLOSED"=3D1 AND  EXISTS (SELECT 0 FROM
>> CRMS."ERIF_ORGANISATION_MEMBER"
>>              "SYS_ALIAS_1",CRMS."ERIF_TARGETED_GROUP_MEMBER"
>> "ERIF_TARGETED_GROUP_MEMBER",CRMS."WP_PENDING" "WP_PENDING" WHERE  NOT
>>              EXISTS (SELECT /*+ */ 0 FROM CRMS."WP_PENDING"
>> "WP_PENDING" WHERE LNNVL("WP_ID"<>:B1)) AND "WP_ID"=3D"WP_ID" AND
>>              "TARGETED_GROUP_ID"=3D:B2 AND
>> "ORGANISATION_CODE"=3D"ORGANISATION_CODE" AND
>> "COUNTRY_CODE"=3D"COUNTRY_CODE" AND ("END_DATE"
>>              IS NULL OR "END_DATE">=3DSYSDATE@!) AND
>> "USER_ID"=3D"RIF_SUPPORT"."GETUSERID"() AND "BEGIN_DATE"<=3DSYSDATE@!))
>>  44 - access("TARGETED_GROUP_ID"=3D"TARGETED_GROUP_ID")
>>  47 - access("WP_ID"=3D"WP_ID")
>>  49 - filter("BEGIN_DATE"<=3D"CREATION_DATE" AND ("END_DATE" IS NULL OR
>> "END_DATE">=3D"CREATION_DATE"))
>>  50 - access("RIF_ID"=3D"RIF_ID")
>>  51 - access("WP_ID"=3D"WP_ID")
>>  52 - access("WP_ID"=3D"WP_ID")
>>  53 - filter( NOT EXISTS (SELECT /*+ */ 0 FROM CRMS."WP_PENDING"
>> "WP_PENDING" WHERE LNNVL("WP_ID"<>:B1)))
>>  56 - filter("TARGETED_GROUP_ID"=3D:B1)
>>  57 - access("WP_ID"=3D"WP_ID")
>>  58 - filter(("END_DATE" IS NULL OR "END_DATE">=3DSYSDATE@!) AND
>> "USER_ID"=3D"RIF_SUPPORT"."GETUSERID"() AND
>>              "BEGIN_DATE"<=3DSYSDATE@!)
>>  59 - access("COUNTRY_CODE"=3D"COUNTRY_CODE" AND
>> "ORGANISATION_CODE"=3D"ORGANISATION_CODE")
>>  60 - filter(LNNVL("WP_ID"<>:B1))
>>  62 - access("ACCV"."RIF_ID"=3D"RIF_ID")
>>       filter( NOT EXISTS (SELECT /*+ ???)
>>  65 - access("RIF_ID"=3D:B1)
>>  66 - access("WP_ID"=3D"WP_ID")
>>  67 - access("WP_ID"=3D"WP_ID")
>>  68 - filter("T0"."RIF_ID"(+)=3D"RIF_ID")
>>  71 - access("WP_ID"=3D"WP_ID")
>>  72 - access("WP_ID"=3D"WP_ID")
>>
>>
>>
>>
>> Statistics
>> ----------------------------------------------------------
>>      20828  recursive calls
>>          0  db block gets
>>      58365  consistent gets
>>       3710  physical reads
>>        116  redo size
>>      14443  bytes sent via SQL*Net to client
>>        414  bytes received via SQL*Net from client
>>         12  SQL*Net roundtrips to/from client
>>        416  sorts (memory)
>>          0  sorts (disk)
>>        161  rows processed
>>
>>
>>
>>
>> -----------------------------------------------
>> 11.2.0.3:
>> 161 rows selected.
>>
>>
>>
>>
>> Elapsed: 00:06:54.44
>>
>>
>>
>>
>> Execution Plan
>> ----------------------------------------------------------
>> Plan hash value: 627833670
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------=
------------------------------------------------------------
>> | Id  | Operation                                    | Name
>>             | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
>>
>> ------------------------------------------------------------------------=
------------------------------------------------------------
>> |   0 | SELECT STATEMENT                             |
>>            |       |  1263K|       | 26259   (1)| 00:05:16 |
>> |   1 |  SORT ORDER BY                               |
>>            |       |  1263K|  1352K| 26259   (1)| 00:05:16 |
>> |*  2 |   FILTER                                     |
>>            |       |       |       |            |          |
>> |   3 |    NESTED LOOPS SEMI                         |
>>            |  8861 |  1263K|       | 12086   (1)| 00:02:26 |
>> |   4 |     NESTED LOOPS ANTI                        |
>>            |  8861 |   977K|       |  3216   (1)| 00:00:39 |
>> |*  5 |      HASH JOIN RIGHT OUTER                   |
>>            | 11327 |  1139K|       |  3213   (1)| 00:00:39 |
>> |   6 |       VIEW                                   |
>> ERIF_RIF_RISK_CATEGORY_V    |  9335 |   391K|       |  2525   (1)|
>> 00:00:31 |
>> |   7 |        NESTED LOOPS ANTI                     |
>>            |  9335 |   483K|       |   150   (4)| 00:00:02 |
>> |   8 |         VIEW                                 | index$_join
>> $_007            | 11933 |   501K|       |   147   (2)| 00:00:02 |
>> |*  9 |          HASH JOIN                           |
>>            |       |       |       |            |          |
>> |  10 |           INDEX FAST FULL SCAN               |
>> ERIF_RIF_RISK_CATEGORYWPUK  | 11933 |   501K|       |    78   (0)|
>> 00:00:01 |
>> |  11 |           INDEX FAST FULL SCAN               |
>> ERIF_RIF_RISK_CATEGORY_PK   | 11933 |   501K|       |   104   (0)|
>> 00:00:02 |
>> |* 12 |         INDEX UNIQUE SCAN                    | WP_PENDING_PK
>>            |   537 |  5370 |       |     0   (0)| 00:00:01 |
>> |  13 |       TABLE ACCESS FULL                      | ERIF_RIF
>>             |   641 | 38460 |       |   687   (1)| 00:00:09 |
>> |* 14 |      INDEX UNIQUE SCAN                       | WP_PENDING_PK
>>            |   537 |  5370 |       |     0   (0)| 00:00:01 |
>> |  15 |     VIEW                                     |
>> ERIF_RIF_ACCESSIBLE_V       |  3387M|   104G|       |     1   (0)|
>> 00:00:01 |
>> |  16 |      UNION-ALL PARTITION                     |
>>            |       |       |       |            |          |
>> |* 17 |       FILTER                                 |
>>            |       |       |       |            |          |
>> |* 18 |        HASH JOIN OUTER                       |
>>            |  3823 |   574K|       |   270   (5)| 00:00:04 |
>> |  19 |         MERGE JOIN CARTESIAN                 |
>>            |     1 |   116 |       |    50   (8)| 00:00:01 |
>> |  20 |          NESTED LOOPS ANTI                   |
>>            |     1 |    99 |       |    24   (9)| 00:00:01 |
>> |* 21 |           FILTER                             |
>>            |       |       |       |            |          |
>> |* 22 |            HASH JOIN OUTER                   |
>>            |     1 |    89 |       |    24   (9)| 00:00:01 |
>> |  23 |             TABLE ACCESS BY INDEX ROWID      | ERIF_RIF
>>             |     1 |    43 |       |     2   (0)| 00:00:01 |
>> |* 24 |              INDEX RANGE SCAN                | ERIF_RIF_PK
>>            |     1 |       |       |     1   (0)| 00:00:01 |
>> |* 25 |             VIEW                             |
>> ERIF_RIF_TARGETED_GROUP_V   |  4118 |   184K|       |    22  (10)|
>> 00:00:01 |
>> |  26 |              NESTED LOOPS ANTI               |
>>            |  4118 |   245K|       |    22  (10)| 00:00:01 |
>> |  27 |               TABLE ACCESS FULL              |
>> ERIF_RIF_TARGETED_GROUP     |  6584 |   327K|       |    20   (0)|
>> 00:00:01 |
>> |* 28 |               INDEX UNIQUE SCAN              | WP_PENDING_PK
>>            |   924 |  9240 |       |     0   (0)| 00:00:01 |
>> |* 29 |           INDEX UNIQUE SCAN                  | WP_PENDING_PK
>>            |  2466 | 24660 |       |     0   (0)| 00:00:01 |
>> |  30 |          BUFFER SORT                         |
>>            |  8168 |   135K|       |    50   (8)| 00:00:01 |
>> |  31 |           VIEW                               | VW_NSO_1
>>             |  8168 |   135K|       |    26   (8)| 00:00:01 |
>> |  32 |            SORT UNIQUE                       |
>>            |  8168 | 16336 |       |    26   (8)| 00:00:01 |
>> |  33 |             COLLECTION ITERATOR PICKLER FETCH| GETRISKCATEGORY
>>            |  8168 | 16336 |       |    24   (0)| 00:00:01 |
>> |* 34 |         VIEW                                 |
>> ERIF_RIF_RISK_CATEGORY_VH   |  9361 |   347K|       |   219   (4)|
>> 00:00:03 |
>> |  35 |          UNION-ALL                           |
>>            |       |       |       |            |          |
>> |  36 |           NESTED LOOPS ANTI                  |
>>            |  9335 |   528K|       |   207   (3)| 00:00:03 |
>> |  37 |            VIEW                              | index$_join
>> $_020            | 11933 |   559K|       |   204   (2)| 00:00:03 |
>> |* 38 |             HASH JOIN                        |
>>            |       |       |       |            |          |
>> |* 39 |              HASH JOIN                       |
>>            |       |       |       |            |          |
>> |  40 |               INDEX FAST FULL SCAN           |
>> ERIF_RIF_RISK_CATEGORY_IDX1 | 11933 |   559K|       |    35   (0)|
>> 00:00:01 |
>> |  41 |               INDEX FAST FULL SCAN           |
>> ERIF_RIF_RISK_CATEGORYWPUK  | 11933 |   559K|       |    78   (0)|
>> 00:00:01 |
>> |  42 |              INDEX FAST FULL SCAN            |
>> ERIF_RIF_RISK_CATEGORY_PK   | 11933 |   559K|       |   104   (0)|
>> 00:00:02 |
>> |* 43 |            INDEX UNIQUE SCAN                 | WP_PENDING_PK
>>            |   537 |  5370 |       |     0   (0)| 00:00:01 |
>> |  44 |           NESTED LOOPS ANTI                  |
>>            |    26 |  1508 |       |    12   (9)| 00:00:01 |
>> |  45 |            TABLE ACCESS FULL                 |
>> ERIF_RIF_RISK_CATEGORY_H    |  2594 |   121K|       |    11   (0)|
>> 00:00:01 |
>> |* 46 |            INDEX UNIQUE SCAN                 | WP_PENDING_PK
>>            |  2465 | 24650 |       |     0   (0)| 00:00:01 |
>> |* 47 |       FILTER                                 |
>>            |       |       |       |            |          |
>> |  48 |        NESTED LOOPS ANTI                     |
>>            |     1 |   165 |       |     6   (0)| 00:00:01 |
>> |  49 |         NESTED LOOPS ANTI                    |
>>            |     1 |   155 |       |     6   (0)| 00:00:01 |
>> |  50 |          NESTED LOOPS                        |
>>            |     1 |   145 |       |     6   (0)| 00:00:01 |
>> |  51 |           NESTED LOOPS ANTI                  |
>>            |     1 |   112 |       |     4   (0)| 00:00:01 |
>> |  52 |            NESTED LOOPS                      |
>>            |     1 |   102 |       |     4   (0)| 00:00:01 |
>> |  53 |             TABLE ACCESS BY INDEX ROWID      | ERIF_RIF
>>             |     1 |    51 |       |     2   (0)| 00:00:01 |
>> |* 54 |              INDEX RANGE SCAN                | ERIF_RIF_PK
>>            |     1 |       |       |     1   (0)| 00:00:01 |
>> |  55 |             TABLE ACCESS BY INDEX ROWID      |
>> ERIF_RIF_TARGETED_GROUP     |     1 |    51 |       |     2   (0)|
>> 00:00:01 |
>> |* 56 |              INDEX RANGE SCAN                |
>> ERIF_RIF_TARGETED_GROUP_PK  |     1 |       |       |     1   (0)|
>> 00:00:01 |
>> |* 57 |            INDEX UNIQUE SCAN                 | WP_PENDING_PK
>>            |  2466 | 24660 |       |     0   (0)| 00:00:01 |
>> |* 58 |           TABLE ACCESS BY INDEX ROWID        |
>> ERIF_TARGETED_GROUP_VP      |     1 |    33 |       |     2   (0)|
>> 00:00:01 |
>> |* 59 |            INDEX RANGE SCAN                  |
>> ERIF_TARGETED_GROUP_VP_PK   |     1 |       |       |     1   (0)|
>> 00:00:01 |
>> |* 60 |          INDEX UNIQUE SCAN                   | WP_PENDING_PK
>>            |  2466 | 24660 |       |     0   (0)| 00:00:01 |
>> |* 61 |         INDEX UNIQUE SCAN                    | WP_PENDING_PK
>>            |  2290 | 22900 |       |     0   (0)| 00:00:01 |
>> |* 62 |        HASH JOIN ANTI SNA                    |
>>            |     1 |    97 |       |     9  (12)| 00:00:01 |
>> |  63 |         NESTED LOOPS                         |
>>            |     1 |    87 |       |     5   (0)| 00:00:01 |
>> |  64 |          NESTED LOOPS ANTI                   |
>>            |     1 |    34 |       |     4   (0)| 00:00:01 |
>> |* 65 |           TABLE ACCESS FULL                  |
>> ERIF_TARGETED_GROUP_MEMBER  |    72 |  1728 |       |     4   (0)|
>> 00:00:01 |
>> |* 66 |           INDEX UNIQUE SCAN                  | WP_PENDING_PK
>>            |  2466 | 24660 |       |     0   (0)| 00:00:01 |
>> |* 67 |          TABLE ACCESS CLUSTER                |
>> ERIF_ORGANISATION_MEMBER    |     1 |    53 |       |     1   (0)|
>> 00:00:01 |
>> |* 68 |           INDEX UNIQUE SCAN                  |
>> ERIF_ORGANISATION_CLUST_IDX |     1 |       |       |     0   (0)|
>> 00:00:01 |
>> |  69 |         INDEX FAST FULL SCAN                 | WP_PENDING_PK
>>            |  2466 | 24660 |       |     3   (0)| 00:00:01 |
>> |  70 |    NESTED LOOPS ANTI                         |
>>            |     1 |    53 |       |     2   (0)| 00:00:01 |
>> |  71 |     TABLE ACCESS BY INDEX ROWID              |
>> ERIF_RIF_ARCHIVE            |     1 |    43 |       |     2   (0)|
>> 00:00:01 |
>> |* 72 |      INDEX RANGE SCAN                        |
>> ERIF_RIF_ARCHIVE_PK         |     1 |       |       |     1   (0)|
>> 00:00:01 |
>> |* 73 |     INDEX UNIQUE SCAN                        | WP_PENDING_PK
>>            |  2466 | 24660 |       |     0   (0)| 00:00:01 |
>>
>> ------------------------------------------------------------------------=
------------------------------------------------------------
>>
>>
>>
>>
>> Predicate Information (identified by operation id):
>> ---------------------------------------------------
>>   2 - filter( NOT EXISTS (SELECT /*+ <not feasible>)
>>   5 - access("T0"."RIF_ID"(+)=3D"RIF_ID" AND "T0"."WP_ID"(+)=3D"WP_ID")
>>   9 - access(ROWID=3DROWID)
>>  12 - access("WP_ID"=3D"WP_ID")
>>  14 - access("WP_ID"=3D"WP_ID")
>>  17 - filter(DECODE("RIFRC"."CATEGORY_CODE",NULL,
>> 0,TO_NUMBER("RIFRC"."CATEGORY_CODE"))=3DTO_NUMBER("$kkqu_col_1"))
>>  18 - access("RIFRC"."RIF_ID"(+)=3D"RIF_ID")
>>  21 - filter("RIFTG"."TARGETED_GROUP_ID" IS NULL)
>>  22 - access("RIFTG"."RIF_ID"(+)=3D"RIF_ID")
>>  24 - access("RIF_ID"=3D"RIF_ID")
>>  25 - filter("RIFTG"."RIF_ID"(+)=3D"RIF_ID")
>>  28 - access("WP_ID"=3D"WP_ID")
>>  29 - access("WP_ID"=3D"WP_ID")
>>  34 - filter("RIFRC"."RIF_ID"(+)=3D"RIF_ID")
>>  38 - access(ROWID=3DROWID)
>>  39 - access(ROWID=3DROWID)
>>  43 - access("WP_ID"=3D"WP_ID")
>>  46 - access("WP_ID"=3D"WP_ID")
>>  47 - filter("CLOSED"=3D0 OR "CLOSED"=3D1 AND  EXISTS (SELECT 0 FROM
>> CRMS."ERIF_ORGANISATION_MEMBER"
>>
>> "ERIF_ORGANISATION_MEMBER",CRMS."ERIF_TARGETED_GROUP_MEMBER"
>> "ERIF_TARGETED_GROUP_MEMBER",CRMS."WP_PENDING"
>>              "WP_PENDING",CRMS."WP_PENDING" "WP_PENDING" WHERE
>> "WP_ID"=3D"WP_ID" AND "WP_ID"=3D"WP_ID" AND "TARGETED_GROUP_ID"=3D:B1 AN=
D
>>              "ORGANISATION_CODE"=3D"ORGANISATION_CODE" AND
>> "COUNTRY_CODE"=3D"COUNTRY_CODE" AND ("END_DATE" IS NULL OR
>> "END_DATE">=3DSYSDATE@!)
>>              AND "USER_ID"=3D"RIF_SUPPORT"."GETUSERID"() AND
>> "BEGIN_DATE"<=3DSYSDATE@!))
>>  54 - access("RIF_ID"=3D"RIF_ID")
>>  56 - access("RIF_ID"=3D"RIF_ID")
>>       filter("RIF_ID"=3D"RIF_ID")
>>  57 - access("WP_ID"=3D"WP_ID")
>>  58 - filter("END_DATE" IS NULL OR "END_DATE">=3D"CREATION_DATE")
>>  59 - access("TARGETED_GROUP_ID"=3D"TARGETED_GROUP_ID" AND
>> "BEGIN_DATE"<=3D"CREATION_DATE")
>>  60 - access("WP_ID"=3D"WP_ID")
>>  61 - access("WP_ID"=3D"WP_ID")
>>  62 - access("WP_ID"=3D"WP_ID")
>>  65 - filter("TARGETED_GROUP_ID"=3D:B1)
>>  66 - access("WP_ID"=3D"WP_ID")
>>  67 - filter(("END_DATE" IS NULL OR "END_DATE">=3DSYSDATE@!) AND
>> "USER_ID"=3D"RIF_SUPPORT"."GETUSERID"() AND
>>              "BEGIN_DATE"<=3DSYSDATE@!)
>>  68 - access("COUNTRY_CODE"=3D"COUNTRY_CODE" AND
>> "ORGANISATION_CODE"=3D"ORGANISATION_CODE")
>>  72 - access("RIF_ID"=3D:B1)
>>  73 - access("WP_ID"=3D"WP_ID")
>>
>> Note
>> -----
>>   - dynamic sampling used for this statement (level=3D4)
>>
>> Statistics
>> ----------------------------------------------------------
>>      15863  recursive calls
>>         23  db block gets
>>   62252048  consistent gets
>>       7048  physical reads
>>          0  redo size
>>      14444  bytes sent via SQL*Net to client
>>        434  bytes received via SQL*Net from client
>>         12  SQL*Net roundtrips to/from client
>>      14452  sorts (memory)
>>          0  sorts (disk)
>>        161  rows processed
>>
>>
>>
>>
>> ------------------------------------------
>> 10046 to pa=F0u vien r=E2da.
>> Ja nu viss te satilps, tad, es dom=E2ju, b=FBs interesanti, un varb=FBt =
ar=EE
>> k=E2ds padoms atrad=EEsies.  Es nesaprotu. Pam=E7=ECin=E2ju paskat=EEtie=
s ar=EE
>> 10053 trasi, bet t=E2 =EEsi nem=E2c=E7ju neko b=FBtisku ieraudz=EEt (vai=
 kaut kur
>> ir k=E2da pam=E2c=EEba, k=E2 interpret=E7t optimizatora trases?), ar=EE =
v10053.exe
>> diez ko nel=EEdz=E7ja.
>> Ceru, ka b=FBs interesanti, un ceru ar=EE, ka k=E2da ideja uzrad=EEsies;
>> pie=EFauju, ka =F0aj=E2 sabiedr=EEb=E2 var=E7tu b=FBt =EFaudis, kas uzre=
iz ieraudz=EEs
>> atbildi.
>> Paldies jau iepriek=F0!
>> Uldis P=E2vuls
>>
>> --
>> J=FBs sa=F2=E7m=E2t =F0o zi=F2ojumu, jo abon=E7j=E2t Google grupu "Latvi=
an Oracle User
>> Group" grupa.
>> Lai nos=FBt=EEtu zi=F2ojumu =F0ai grupai, s=FBtiet e-pastu uz
>> lvoug@googlegroups.com
>> Lai redz=E7tu papildiesp=E7jas, apmekl=E7jiet =F0o grupu
>> http://lvoug.lv
>>
>
>  --
> J=FBs sa=F2=E7m=E2t =F0o zi=F2ojumu, jo abon=E7j=E2t Google grupu "Latvia=
n Oracle User
> Group" grupa.
> Lai nos=FBt=EEtu zi=F2ojumu =F0ai grupai, s=FBtiet e-pastu uz
> lvoug@googlegroups.com
> Lai redz=E7tu papildiesp=E7jas, apmekl=E7jiet =F0o grupu
> http://lvoug.lv
>

--20cf307f33eeacd35404c2e4f6c6
Content-Type: text/html; charset=ISO-8859-13
Content-Transfer-Encoding: quoted-printable


TEST<br>var atbild=E7t uz mailu <a href=3D"mailto:lvoug@googlegroups.com">l=
voug@googlegroups.com</a> ar attachmentu.<br><br>Andrejs.<br><br><div class=
=3D"gmail_quote">2012/6/20 Maris Elsins <span dir=3D"ltr">&lt;<a href=3D"ma=
ilto:elma...@gmail.com" target=3D"_blank">elma...@gmail.com</a>&gt;</span><=
br>
<blockquote class=3D"gmail_quote" style=3D"margin:0pt 0pt 0pt 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<div><br></div><div>In=
teresanti ir,<div>bet izpildpl=E2ns tik slikti saformat=E7ts, ka negribas n=
emaz skat=EEties...<br clear=3D"all">
---<div>M=E2ris Elsi=F2=F0</div><br>
<br><br><div class=3D"gmail_quote">2012/6/19 Uldis P=E2vuls <span dir=3D"lt=
r">&lt;<a href=3D"mailto:uldis...@gmail.com" target=3D"_blank">uldis777@gma=
il.com</a>&gt;</span><br><blockquote class=3D"gmail_quote" style=3D"margin:=
0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">

Labvakar!<br>
Vispirms paldies visiem, kas atsauc=E2s - gan =F0eit, gan person=EEgi; =EEp=
a=F0i<br>
Andrey Chervonec par da=FE=E2m man l=EEdz =F0im nezin=E2m=E2m MOS nor=E2d=
=E7m.<br>
Atvainojos ar=EE, ka tik ilgi nevar=E7ju atbild=E7t - vienk=E2r=F0i iekrita=
<br>
slodze, viss san=E2ca kop=E2, neatradu laiku.<br>
Probl=E7ma gan v=E7l p=E7c b=FBt=EEbas nav atrisin=E2jusies. Kol=E7=ECis p=
=E2rrakst=EEja<br>
pras=EEjumu cit=E2di, un t=E2 tas iet griezdamies, bet ar izma=F2=E2m kod=
=E2 ir<br>
liela =ED=E7pa, pirmk=E2rt jau birokr=E2tiska, par papildus test=E7=F0anu n=
emaz<br>
nerun=E2jot. Turkl=E2t gribas ar=EE skaidr=EEbu par to, kas notiek, lai p=
=E7c<br>
tam uz t=E2 pa=F0a gr=E2bek=EFa nek=E2ptu.<br>
Ar to tras=E7=F0anu ir zin=E2mas gr=FBt=EEbas. K=E2 jau teicu, otr=E2 gal=
=E2 ir<br>
weblogic. Test=E7=F0ana ar=EE ir automatiz=E7ta, un =F0aj=E2 konkr=E7taj=E2=
 lietojum=E2<br>
(k=E2 daudzos citos) uzdevumi (un jaunas sesijas) tiek palaistas ar<br>
pogas piespiedienu: iepauz=E7t, lai notvertu vajadz=EEgo sesiju un uzliktu<=
br>
tai 10046 vai 10053, faktiski nav iesp=E7jams. Tiesa, ar AWR un ASH<br>
pal=EEdz=EEbu izdev=E2s izdal=EEt vain=EEgos pras=EEjumus, un te s=E2k=E2s =
br=EEnumi.<br>
Faktiski jau tas ir galvenais, k=E2d=E7=EF rakstu; dom=E2ju, ka ar=EE citie=
m b=FBs<br>
interesanti, un varb=FBt k=E2dam b=FBs k=E2da ideja. (Ceru tikai, ka v=E7st=
ule<br>
neb=FBs p=E2r=E2k gara un ievietosies; aprobe=FEo=F0os ar izteiksm=EEg=E2ko=
 piem=E7ru)<br>
Visu pras=EEjumu es te nelik=F0u, tikai apcirpto vaiantu. Pilnais satur<br>
v=E7l l=E7rumu kolonu, <a href=3D"http://t.sk" target=3D"_blank">t.sk</a>. =
ar apak=F0pras=EEjumiem (subqueries). S=E2ls ir<br>
WHERE, par to es p=E2rliecin=E2jos.<br>
T=E2tad:<br>
SELECT<br>
 =A0/*+ FIRST_ROWS(500) */<br>
 =A0T1.rif_id =A0 =A0 =A0 =A0AS S0,<br>
 =A0T1.rif_id =A0 =A0 =A0 =A0AS S1,<br>
 =A0T1.rif_reference AS S2<br>
FROM erif_rif_risk_category_V T0,<br>
 =A0erif_rif_V T1<br>
WHERE (T0.rif_id(+)=3DT1.rif_id)<br>
AND (T0.wp_id(+) =A0 =3DT1.wp_id)<br>
AND (((EXISTS<br>
 =A0(SELECT 1 FROM erif_rif_accessible_V accv WHERE accv.rif_id =3D<br>
T1.rif_id<br>
 =A0)))<br>
AND(NOT EXISTS<br>
 =A0(SELECT 1 FROM erif_rif_archive_v WHERE rif_id =3D T1.rif_id<br>
 =A0)))<br>
ORDER BY S0 DESC,<br>
 =A0S1 desc<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
J=E2, te ir EXIST/NOT EXIST un paties=EEb=E2 nav nevienas tie=F0i min=E7tas=
<br>
tabulas, tika skati (views), kuros ar=EE ir EXIST.<br>
Tagad at=EFau=F0os ievietot, ko r=E2da autotrace ab=E2s versij=E2s, ceru ka=
<br>
iel=EEd=EEs. Atg=E2din=E2=F0u, ka datu b=E2zes ir vienas izcelsmes, shemas<=
br>
praktiski neat=F0=EDiras (ar=EE s=E2kotn=E7ji no vienas datnes import=E7tas=
).<br>
optimizer_dynamic_sampling=3D4 ; viens no kol=E7=ECiem ierosin=E2ja, bet ta=
s<br>
neko neizmain=EEja, tik vien k=E2 pielika piez=EEmi beig=E2s.<br>
Bet piev=E7rsiet uzman=EEbu starp=EEbai &quot;consistent gets&quot; =A0- t=
=E2p=E7c jau 11G<br>
ar=EE CPU str=E2d=E2 r=FBkdams un liek dom=E2t, ka kaut kas svar=EEgs tiek<=
br>
dar=EEts... 11G tas ir 1066 reizes vair=E2k.<br>
<a href=3D"http://10.2.0.4" target=3D"_blank">10.2.0.4</a>:<br>
161 rows selected.<br>
<br>
<br>
<br>
<br>
Elapsed: 00:00:19.91<br>
<br>
<br>
<br>
<br>
Execution Plan<br>
----------------------------------------------------------<br>
Plan hash value: 1236651934<br>
<br>
<br>
<br>
<br>
---------------------------------------------------------------------------=
----------------------------------------------------<br>
| Id =A0| Operation =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 | Name<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | Rows =A0| Bytes | Cost (%CPU)| Time =A0 =A0 =
|<br>
---------------------------------------------------------------------------=
----------------------------------------------------<br>
| =A0 0 | SELECT STATEMENT =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 2 | =A0 290 | =A0 =A010 =A0(20)| =
00:00:01 |<br>
| =A0 1 | =A0SORT ORDER BY =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 2 | =A0 290 | =A0 =A010 =A0(20)| =
00:00:01 |<br>
| =A0 2 | =A0 NESTED LOOPS OUTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 145 | =A0 =A0 7 =A0(15)| =
00:00:01 |<br>
| =A0 3 | =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 102 | =A0 =A0 5 =A0(20)| =
00:00:01 |<br>
| =A0 4 | =A0 =A0 NESTED LOOPS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A093 | =A0 =A0 5 =A0(20)=
| 00:00:01 |<br>
| =A0 5 | =A0 =A0 =A0SORT UNIQUE =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 2 | =A0 =A066 | =A0 =A0 2 =A0 (0)=
| 00:00:01 |<br>
| =A0 6 | =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0|<br>
ERIF_RIF_ACCESSIBLE_V =A0 =A0 =A0 | =A0 =A0 2 | =A0 =A066 | =A0 =A0 2 =A0 (=
0)| 00:00:01 |<br>
| =A0 7 | =A0 =A0 =A0 =A0UNION-ALL =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A0 8 | =A0 =A0 =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 153 | =A0 482 =A0 (3)| 00=
:00:06 |<br>
|* =A09 | =A0 =A0 =A0 =A0 =A0FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 10 | =A0 =A0 =A0 =A0 =A0 HASH JOIN OUTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 144 | =A0 482 =A0 (3)| 00=
:00:06 |<br>
| =A011 | =A0 =A0 =A0 =A0 =A0 =A0MERGE JOIN CARTESIAN =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 106 | =A0 211 =A0 (3)| 00=
:00:03 |<br>
|* 12 | =A0 =A0 =A0 =A0 =A0 =A0 FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 13 | =A0 =A0 =A0 =A0 =A0 =A0 =A0HASH JOIN RIGHT OUTER =A0 =A0 =A0 =A0 =
=A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A089 | =A0 186 =A0 (3)| =
00:00:03 |<br>
| =A014 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0|<br>
ERIF_RIF_TARGETED_GROUP_V =A0 | =A04118 | =A0 184K| =A0 =A022 =A0(10)| 00:0=
0:01 |<br>
| =A015 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A04118 | =A0 241K| =A0 =A022 =A0(10)| 00=
:00:01 |<br>
| =A016 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
ERIF_RIF_TARGETED_GROUP =A0 =A0 | =A06584 | =A0 327K| =A0 =A020 =A0 (0)| 00=
:00:01 |<br>
|* 17 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 924 | =A08316 | =A0 =A0 0 =
=A0 (0)| 00:00:01 |<br>
| =A018 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0| index$_join<br>
$_026 =A0 =A0 =A0 =A0 =A0 =A0| 11327 | =A0 475K| =A0 163 =A0 (2)| 00:00:02 =
|<br>
|* 19 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A020 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =
=A0 =A0 =A0| ERIF_RIFWPUK<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | 11327 | =A0 475K| =A0 =A073 =A0 (0)| 00:00:0=
1 |<br>
| =A021 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =
=A0 =A0 =A0| ERIF_RIF_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| 11327 | =A0 475K| =A0 =A089 =A0 (0)| 00:0=
0:02 |<br>
| =A022 | =A0 =A0 =A0 =A0 =A0 =A0 BUFFER SORT =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A08168 | =A0 135K| =A0 211 =A0 (3)| 00:0=
0:03 |<br>
| =A023 | =A0 =A0 =A0 =A0 =A0 =A0 =A0VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 | VW_NSO_1<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A08168 | =A0 135K| =A0 =A026 =A0 (8)| 00:00=
:01 |<br>
| =A024 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 HASH UNIQUE =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A08168 | 16336 | =A0 =A026 =A0 (8)| 00:0=
0:01 |<br>
| =A025 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0COLLECTION ITERATOR PICKLER FETCH|=
<br>
GETRISKCATEGORY =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =
=A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A026 | =A0 =A0 =A0 =A0 =A0 =A0VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORY_VH =A0 | =A09336 | =A0 346K| =A0 269 =A0 (3)| 00:00:=
04 |<br>
| =A027 | =A0 =A0 =A0 =A0 =A0 =A0 UNION-ALL =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A028 | =A0 =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A09335 | =A0 519K| =A0 258 =A0 (3)| 00:0=
0:04 |<br>
| =A029 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0| index$_join<br>
$_020 =A0 =A0 =A0 =A0 =A0 =A0| 11933 | =A0 559K| =A0 255 =A0 (2)| 00:00:04 =
|<br>
|* 30 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 31 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A032 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX FAST FULL SCAN =A0 =A0 =
=A0 =A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORY_IDX1 | 11933 | =A0 559K| =A0 =A035 =A0 (0)| 00:00:01=
 |<br>
| =A033 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX FAST FULL SCAN =A0 =A0 =
=A0 =A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORYWPUK =A0| 11933 | =A0 559K| =A0 =A078 =A0 (0)| 00:00:=
01 |<br>
| =A034 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =
=A0 =A0 =A0|<br>
ERIF_RIF_RISK_CATEGORY_PK =A0 | 11933 | =A0 559K| =A0 104 =A0 (0)| 00:00:02=
 |<br>
|* 35 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 537 | =A04833 | =A0 =A0 0 =
=A0 (0)| 00:00:01 |<br>
| =A036 | =A0 =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A057 | =A0 =A012 =A0 (9)=
| 00:00:01 |<br>
| =A037 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORY_H =A0 =A0| =A02594 | =A0 121K| =A0 =A011 =A0 (0)| 00=
:00:01 |<br>
|* 38 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A02465 | 22185 | =A0 =A0 0 =A0=
 (0)| 00:00:01 |<br>
|* 39 | =A0 =A0 =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 537 | =A04833 | =A0 =A0 0 =
=A0 (0)| 00:00:01 |<br>
|* 40 | =A0 =A0 =A0 =A0 FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A041 | =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 162 | =A0 =A026 =A0 (4)| =
00:00:01 |<br>
| =A042 | =A0 =A0 =A0 =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 153 | =A0 =A026 =A0 (4)| =
00:00:01 |<br>
| =A043 | =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 144 | =A0 =A026 =A0 (4)| =
00:00:01 |<br>
|* 44 | =A0 =A0 =A0 =A0 =A0 =A0 HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A093 | =A0 =A024 =A0 (5)=
| 00:00:01 |<br>
| =A045 | =A0 =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A042 | =A0 =A0 3 =A0 (0)=
| 00:00:01 |<br>
| =A046 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
ERIF_TARGETED_GROUP_VP =A0 =A0 =A0| =A0 =A014 | =A0 462 | =A0 =A0 3 =A0 (0)=
| 00:00:01 |<br>
|* 47 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A02466 | 22194 | =A0 =A0 0 =A0=
 (0)| 00:00:01 |<br>
| =A048 | =A0 =A0 =A0 =A0 =A0 =A0 =A0TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
ERIF_RIF_TARGETED_GROUP =A0 =A0 | =A06584 | =A0 327K| =A0 =A020 =A0 (0)| 00=
:00:01 |<br>
|* 49 | =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0 =A0=
 | ERIF_RIF<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A051 | =A0 =A0 2 =A0 (0)| 0=
0:00:01 |<br>
|* 50 | =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 | ERIF_RIF_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 1 =A0 (=
0)| 00:00:01 |<br>
|* 51 | =A0 =A0 =A0 =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 537 | =A04833 | =A0 =A0 0 =
=A0 (0)| 00:00:01 |<br>
|* 52 | =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 924 | =A08316 | =A0 =A0 0 =
=A0 (0)| 00:00:01 |<br>
|* 53 | =A0 =A0 =A0 =A0 =A0FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 =
=A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A054 | =A0 =A0 =A0 =A0 =A0 NESTED LOOPS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A086 | =A0 =A0 5 =A0 (0)=
| 00:00:01 |<br>
| =A055 | =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A033 | =A0 =A0 4 =A0 (0)=
| 00:00:01 |<br>
|* 56 | =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
ERIF_TARGETED_GROUP_MEMBER =A0| =A0 =A072 | =A01728 | =A0 =A0 4 =A0 (0)| 00=
:00:01 |<br>
|* 57 | =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A02466 | 22194 | =A0 =A0 0 =A0=
 (0)| 00:00:01 |<br>
|* 58 | =A0 =A0 =A0 =A0 =A0 =A0TABLE ACCESS CLUSTER =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 |<br>
ERIF_ORGANISATION_MEMBER =A0 =A0| =A0 =A0 1 | =A0 =A053 | =A0 =A0 1 =A0 (0)=
| 00:00:01 |<br>
|* 59 | =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
ERIF_ORGANISATION_CLUST_IDX | =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)| =
00:00:01 |<br>
|* 60 | =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0|<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A0 9 | =A0 =A0=
 3 =A0 (0)| 00:00:01 |<br>
| =A061 | =A0 =A0 =A0TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| ERIF_RIF<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A060 | =A0 =A0 2 =A0 (0)| 0=
0:00:01 |<br>
|* 62 | =A0 =A0 =A0 INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0| ERIF_RIF_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 1 =A0 (=
0)| 00:00:01 |<br>
| =A063 | =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A052 | =A0 =A0 2 =A0 (0)=
| 00:00:01 |<br>
| =A064 | =A0 =A0 =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0 =A0 =A0 =
=A0 |<br>
ERIF_RIF_ARCHIVE =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A043 | =A0 =A0 2=
 =A0 (0)| 00:00:01 |<br>
|* 65 | =A0 =A0 =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
ERIF_RIF_ARCHIVE_PK =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 1 =
=A0 (0)| 00:00:01 |<br>
|* 66 | =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A02466 | 22194 | =A0 =A0 0 =A0=
 (0)| 00:00:01 |<br>
|* 67 | =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 537 | =A04833 | =A0 =A0 0 =
=A0 (0)| 00:00:01 |<br>
|* 68 | =A0 =A0VIEW PUSHED PREDICATE =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0|<br>
ERIF_RIF_RISK_CATEGORY_V =A0 =A0| =A0 =A0 1 | =A0 =A043 | =A0 =A0 2 =A0 (0)=
| 00:00:01 |<br>
| =A069 | =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A052 | =A0 =A0 3 =A0 (0)=
| 00:00:01 |<br>
| =A070 | =A0 =A0 =A0TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0|<br>
ERIF_RIF_RISK_CATEGORY =A0 =A0 =A0| =A0 =A0 1 | =A0 =A043 | =A0 =A0 3 =A0 (=
0)| 00:00:01 |<br>
|* 71 | =A0 =A0 =A0 INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
ERIF_RIF_RISK_CATEGORYWPUK =A0| =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 2 =A0 (0)=
| 00:00:01 |<br>
|* 72 | =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
WP_PENDING_PK =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A02466 | 22194 | =A0 =A0 0 =A0=
 (0)| 00:00:01 |<br>
---------------------------------------------------------------------------=
----------------------------------------------------<br>
<br>
<br>
<br>
<br>
Predicate Information (identified by operation id):<br>
---------------------------------------------------<br>
<br>
<br>
<br>
<br>
 =A0 9 - filter(DECODE(&quot;RIFRC&quot;.&quot;CATEGORY_CODE&quot;,NULL,<br=
>
0,TO_NUMBER(&quot;RIFRC&quot;.&quot;CATEGORY_CODE&quot;))=3DTO_NUMBER(&quot=
;$nso_col_1&quot;))<br>
 =A010 - access(&quot;RIFRC&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot=
;)<br>
 =A012 - filter(&quot;RIFTG&quot;.&quot;TARGETED_GROUP_ID&quot; IS NULL)<br=
>
 =A013 - access(&quot;RIFTG&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot=
;)<br>
 =A017 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A019 - access(ROWID=3DROWID)<br>
 =A030 - access(ROWID=3DROWID)<br>
 =A031 - access(ROWID=3DROWID)<br>
 =A035 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A038 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A039 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A040 - filter(&quot;CLOSED&quot;=3D0 OR &quot;CLOSED&quot;=3D1 AND =A0EXI=
STS (SELECT 0 FROM<br>
CRMS.&quot;ERIF_ORGANISATION_MEMBER&quot;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0&quot;SYS_ALIAS_1&quot;,CRMS.&quot;ERIF_TARGETE=
D_GROUP_MEMBER&quot;<br>
&quot;ERIF_TARGETED_GROUP_MEMBER&quot;,CRMS.&quot;WP_PENDING&quot; &quot;WP=
_PENDING&quot; WHERE =A0NOT<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0EXISTS (SELECT /*+ */ 0 FROM CRMS.&quot;WP_PEND=
ING&quot;<br>
&quot;WP_PENDING&quot; WHERE LNNVL(&quot;WP_ID&quot;&lt;&gt;:B1)) AND &quot=
;WP_ID&quot;=3D&quot;WP_ID&quot; AND<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0&quot;TARGETED_GROUP_ID&quot;=3D:B2 AND<br>
&quot;ORGANISATION_CODE&quot;=3D&quot;ORGANISATION_CODE&quot; AND<br>
&quot;COUNTRY_CODE&quot;=3D&quot;COUNTRY_CODE&quot; AND (&quot;END_DATE&quo=
t;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0IS NULL OR &quot;END_DATE&quot;&gt;=3DSYSDATE@!=
) AND<br>
&quot;USER_ID&quot;=3D&quot;RIF_SUPPORT&quot;.&quot;GETUSERID&quot;() AND &=
quot;BEGIN_DATE&quot;&lt;=3DSYSDATE@!))<br>
 =A044 - access(&quot;TARGETED_GROUP_ID&quot;=3D&quot;TARGETED_GROUP_ID&quo=
t;)<br>
 =A047 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A049 - filter(&quot;BEGIN_DATE&quot;&lt;=3D&quot;CREATION_DATE&quot; AND =
(&quot;END_DATE&quot; IS NULL OR<br>
&quot;END_DATE&quot;&gt;=3D&quot;CREATION_DATE&quot;))<br>
 =A050 - access(&quot;RIF_ID&quot;=3D&quot;RIF_ID&quot;)<br>
 =A051 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A052 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A053 - filter( NOT EXISTS (SELECT /*+ */ 0 FROM CRMS.&quot;WP_PENDING&quo=
t;<br>
&quot;WP_PENDING&quot; WHERE LNNVL(&quot;WP_ID&quot;&lt;&gt;:B1)))<br>
 =A056 - filter(&quot;TARGETED_GROUP_ID&quot;=3D:B1)<br>
 =A057 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A058 - filter((&quot;END_DATE&quot; IS NULL OR &quot;END_DATE&quot;&gt;=
=3DSYSDATE@!) AND<br>
&quot;USER_ID&quot;=3D&quot;RIF_SUPPORT&quot;.&quot;GETUSERID&quot;() AND<b=
r>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0&quot;BEGIN_DATE&quot;&lt;=3DSYSDATE@!)<br>
 =A059 - access(&quot;COUNTRY_CODE&quot;=3D&quot;COUNTRY_CODE&quot; AND<br>
&quot;ORGANISATION_CODE&quot;=3D&quot;ORGANISATION_CODE&quot;)<br>
 =A060 - filter(LNNVL(&quot;WP_ID&quot;&lt;&gt;:B1))<br>
 =A062 - access(&quot;ACCV&quot;.&quot;RIF_ID&quot;=3D&quot;RIF_ID&quot;)<b=
r>
 =A0 =A0 =A0 filter( NOT EXISTS (SELECT /*+ ???)<br>
 =A065 - access(&quot;RIF_ID&quot;=3D:B1)<br>
 =A066 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A067 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A068 - filter(&quot;T0&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot;)<=
br>
 =A071 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A072 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
<br>
<br>
<br>
<br>
Statistics<br>
----------------------------------------------------------<br>
 =A0 =A0 =A020828 =A0recursive calls<br>
 =A0 =A0 =A0 =A0 =A00 =A0db block gets<br>
 =A0 =A0 =A058365 =A0consistent gets<br>
 =A0 =A0 =A0 3710 =A0physical reads<br>
 =A0 =A0 =A0 =A0116 =A0redo size<br>
 =A0 =A0 =A014443 =A0bytes sent via SQL*Net to client<br>
 =A0 =A0 =A0 =A0414 =A0bytes received via SQL*Net from client<br>
 =A0 =A0 =A0 =A0 12 =A0SQL*Net roundtrips to/from client<br>
 =A0 =A0 =A0 =A0416 =A0sorts (memory)<br>
 =A0 =A0 =A0 =A0 =A00 =A0sorts (disk)<br>
 =A0 =A0 =A0 =A0161 =A0rows processed<br>
<br>
<br>
<br>
<br>
-----------------------------------------------<br>
<a href=3D"http://11.2.0.3" target=3D"_blank">11.2.0.3</a>:<br>
161 rows selected.<br>
<br>
<br>
<br>
<br>
Elapsed: 00:06:54.44<br>
<br>
<br>
<br>
<br>
Execution Plan<br>
----------------------------------------------------------<br>
Plan hash value: 627833670<br>
<br>
<br>
<br>
<br>
---------------------------------------------------------------------------=
---------------------------------------------------------<br>
| Id =A0| Operation =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0| Name<br>
 =A0 =A0 =A0 =A0 =A0 =A0 | Rows =A0| Bytes |TempSpc| Cost (%CPU)| Time =A0 =
=A0 |<br>
---------------------------------------------------------------------------=
---------------------------------------------------------<br>
| =A0 0 | SELECT STATEMENT =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A01263K| =A0 =A0 =A0 | 26259 =A0 (=
1)| 00:05:16 |<br>
| =A0 1 | =A0SORT ORDER BY =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A01263K| =A01352K| 26259 =A0 (1)| =
00:05:16 |<br>
|* =A02 | =A0 FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A0 3 | =A0 =A0NESTED LOOPS SEMI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A08861 | =A01263K| =A0 =A0 =A0 | 12086 =A0 (1)| =
00:02:26 |<br>
| =A0 4 | =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A08861 | =A0 977K| =A0 =A0 =A0 | =A03216 =A0 (1)=
| 00:00:39 |<br>
|* =A05 | =A0 =A0 =A0HASH JOIN RIGHT OUTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| 11327 | =A01139K| =A0 =A0 =A0 | =A03213 =A0 (1)| =
00:00:39 |<br>
| =A0 6 | =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORY_V =A0 =A0| =A09335 | =A0 391K| =A0 =A0 =A0 | =A02525=
 =A0 (1)|<br>
00:00:31 |<br>
| =A0 7 | =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A09335 | =A0 483K| =A0 =A0 =A0 | =A0 150 =A0 (4)=
| 00:00:02 |<br>
| =A0 8 | =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 | index$_join<br>
$_007 =A0 =A0 =A0 =A0 =A0 =A0| 11933 | =A0 501K| =A0 =A0 =A0 | =A0 147 =A0 =
(2)| 00:00:02 |<br>
|* =A09 | =A0 =A0 =A0 =A0 =A0HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A010 | =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 |<br>
ERIF_RIF_RISK_CATEGORYWPUK =A0| 11933 | =A0 501K| =A0 =A0 =A0 | =A0 =A078 =
=A0 (0)|<br>
00:00:01 |<br>
| =A011 | =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 |<br>
ERIF_RIF_RISK_CATEGORY_PK =A0 | 11933 | =A0 501K| =A0 =A0 =A0 | =A0 104 =A0=
 (0)|<br>
00:00:02 |<br>
|* 12 | =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 537 | =A05370 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (=
0)| 00:00:01 |<br>
| =A013 | =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0| ERIF_RIF<br>
 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 641 | 38460 | =A0 =A0 =A0 | =A0 687 =A0 (1)|=
 00:00:09 |<br>
|* 14 | =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 | WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 537 | =A05370 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (=
0)| 00:00:01 |<br>
| =A015 | =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
ERIF_RIF_ACCESSIBLE_V =A0 =A0 =A0 | =A03387M| =A0 104G| =A0 =A0 =A0 | =A0 =
=A0 1 =A0 (0)|<br>
00:00:01 |<br>
| =A016 | =A0 =A0 =A0UNION-ALL PARTITION =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 17 | =A0 =A0 =A0 FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 18 | =A0 =A0 =A0 =A0HASH JOIN OUTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A03823 | =A0 574K| =A0 =A0 =A0 | =A0 270 =A0 (5)=
| 00:00:04 |<br>
| =A019 | =A0 =A0 =A0 =A0 MERGE JOIN CARTESIAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 116 | =A0 =A0 =A0 | =A0 =A050 =A0=
 (8)| 00:00:01 |<br>
| =A020 | =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A099 | =A0 =A0 =A0 | =A0 =A024 =
=A0 (9)| 00:00:01 |<br>
|* 21 | =A0 =A0 =A0 =A0 =A0 FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 22 | =A0 =A0 =A0 =A0 =A0 =A0HASH JOIN OUTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A089 | =A0 =A0 =A0 | =A0 =A024 =
=A0 (9)| 00:00:01 |<br>
| =A023 | =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0| =
ERIF_RIF<br>
 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A043 | =A0 =A0 =A0 | =A0 =A0 2 =
=A0 (0)| 00:00:01 |<br>
|* 24 | =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0| ERIF_RIF_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 1=
 =A0 (0)| 00:00:01 |<br>
|* 25 | =A0 =A0 =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
ERIF_RIF_TARGETED_GROUP_V =A0 | =A04118 | =A0 184K| =A0 =A0 =A0 | =A0 =A022=
 =A0(10)|<br>
00:00:01 |<br>
| =A026 | =A0 =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A04118 | =A0 245K| =A0 =A0 =A0 | =A0 =A022 =A0(1=
0)| 00:00:01 |<br>
| =A027 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
ERIF_RIF_TARGETED_GROUP =A0 =A0 | =A06584 | =A0 327K| =A0 =A0 =A0 | =A0 =A0=
20 =A0 (0)|<br>
00:00:01 |<br>
|* 28 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 924 | =A09240 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (=
0)| 00:00:01 |<br>
|* 29 | =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02466 | 24660 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
| =A030 | =A0 =A0 =A0 =A0 =A0BUFFER SORT =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A08168 | =A0 135K| =A0 =A0 =A0 | =A0 =A050 =A0 (=
8)| 00:00:01 |<br>
| =A031 | =A0 =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 | VW_NSO_1<br>
 =A0 =A0 =A0 =A0 =A0 =A0 | =A08168 | =A0 135K| =A0 =A0 =A0 | =A0 =A026 =A0 =
(8)| 00:00:01 |<br>
| =A032 | =A0 =A0 =A0 =A0 =A0 =A0SORT UNIQUE =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A08168 | 16336 | =A0 =A0 =A0 | =A0 =A026 =A0 (8)=
| 00:00:01 |<br>
| =A033 | =A0 =A0 =A0 =A0 =A0 =A0 COLLECTION ITERATOR PICKLER FETCH| GETRIS=
KCATEGORY<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A08168 | 16336 | =A0 =A0 =A0 | =A0 =A024 =A0 (0)=
| 00:00:01 |<br>
|* 34 | =A0 =A0 =A0 =A0 VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORY_VH =A0 | =A09361 | =A0 347K| =A0 =A0 =A0 | =A0 219 =
=A0 (4)|<br>
00:00:03 |<br>
| =A035 | =A0 =A0 =A0 =A0 =A0UNION-ALL =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A036 | =A0 =A0 =A0 =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A09335 | =A0 528K| =A0 =A0 =A0 | =A0 207 =A0 (3)=
| 00:00:03 |<br>
| =A037 | =A0 =A0 =A0 =A0 =A0 =A0VIEW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0| index$_join<br>
$_020 =A0 =A0 =A0 =A0 =A0 =A0| 11933 | =A0 559K| =A0 =A0 =A0 | =A0 204 =A0 =
(2)| 00:00:03 |<br>
|* 38 | =A0 =A0 =A0 =A0 =A0 =A0 HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
|* 39 | =A0 =A0 =A0 =A0 =A0 =A0 =A0HASH JOIN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A040 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =
=A0 |<br>
ERIF_RIF_RISK_CATEGORY_IDX1 | 11933 | =A0 559K| =A0 =A0 =A0 | =A0 =A035 =A0=
 (0)|<br>
00:00:01 |<br>
| =A041 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =
=A0 |<br>
ERIF_RIF_RISK_CATEGORYWPUK =A0| 11933 | =A0 559K| =A0 =A0 =A0 | =A0 =A078 =
=A0 (0)|<br>
00:00:01 |<br>
| =A042 | =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =
=A0 =A0|<br>
ERIF_RIF_RISK_CATEGORY_PK =A0 | 11933 | =A0 559K| =A0 =A0 =A0 | =A0 104 =A0=
 (0)|<br>
00:00:02 |<br>
|* 43 | =A0 =A0 =A0 =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 | WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 537 | =A05370 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (=
0)| 00:00:01 |<br>
| =A044 | =A0 =A0 =A0 =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A026 | =A01508 | =A0 =A0 =A0 | =A0 =A012 =A0=
 (9)| 00:00:01 |<br>
| =A045 | =A0 =A0 =A0 =A0 =A0 =A0TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
ERIF_RIF_RISK_CATEGORY_H =A0 =A0| =A02594 | =A0 121K| =A0 =A0 =A0 | =A0 =A0=
11 =A0 (0)|<br>
00:00:01 |<br>
|* 46 | =A0 =A0 =A0 =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 | WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02465 | 24650 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
|* 47 | =A0 =A0 =A0 FILTER =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0=
 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0|<br>
| =A048 | =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 165 | =A0 =A0 =A0 | =A0 =A0 6 =A0=
 (0)| 00:00:01 |<br>
| =A049 | =A0 =A0 =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 155 | =A0 =A0 =A0 | =A0 =A0 6 =A0=
 (0)| 00:00:01 |<br>
| =A050 | =A0 =A0 =A0 =A0 =A0NESTED LOOPS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 145 | =A0 =A0 =A0 | =A0 =A0 6 =A0=
 (0)| 00:00:01 |<br>
| =A051 | =A0 =A0 =A0 =A0 =A0 NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 112 | =A0 =A0 =A0 | =A0 =A0 4 =A0=
 (0)| 00:00:01 |<br>
| =A052 | =A0 =A0 =A0 =A0 =A0 =A0NESTED LOOPS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 102 | =A0 =A0 =A0 | =A0 =A0 4 =A0=
 (0)| 00:00:01 |<br>
| =A053 | =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0| =
ERIF_RIF<br>
 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A051 | =A0 =A0 =A0 | =A0 =A0 2 =
=A0 (0)| 00:00:01 |<br>
|* 54 | =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0| ERIF_RIF_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =A0 1=
 =A0 (0)| 00:00:01 |<br>
| =A055 | =A0 =A0 =A0 =A0 =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0|<=
br>
ERIF_RIF_TARGETED_GROUP =A0 =A0 | =A0 =A0 1 | =A0 =A051 | =A0 =A0 =A0 | =A0=
 =A0 2 =A0 (0)|<br>
00:00:01 |<br>
|* 56 | =A0 =A0 =A0 =A0 =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
ERIF_RIF_TARGETED_GROUP_PK =A0| =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0=
 =A0 1 =A0 (0)|<br>
00:00:01 |<br>
|* 57 | =A0 =A0 =A0 =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 | WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02466 | 24660 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
|* 58 | =A0 =A0 =A0 =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0 =A0|<br=
>
ERIF_TARGETED_GROUP_VP =A0 =A0 =A0| =A0 =A0 1 | =A0 =A033 | =A0 =A0 =A0 | =
=A0 =A0 2 =A0 (0)|<br>
00:00:01 |<br>
|* 59 | =A0 =A0 =A0 =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
ERIF_TARGETED_GROUP_VP_PK =A0 | =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0=
 =A0 1 =A0 (0)|<br>
00:00:01 |<br>
|* 60 | =A0 =A0 =A0 =A0 =A0INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 | WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02466 | 24660 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
|* 61 | =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02290 | 22900 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
|* 62 | =A0 =A0 =A0 =A0HASH JOIN ANTI SNA =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0|<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A097 | =A0 =A0 =A0 | =A0 =A0 9 =
=A0(12)| 00:00:01 |<br>
| =A063 | =A0 =A0 =A0 =A0 NESTED LOOPS =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A087 | =A0 =A0 =A0 | =A0 =A0 5 =
=A0 (0)| 00:00:01 |<br>
| =A064 | =A0 =A0 =A0 =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A034 | =A0 =A0 =A0 | =A0 =A0 4 =
=A0 (0)| 00:00:01 |<br>
|* 65 | =A0 =A0 =A0 =A0 =A0 TABLE ACCESS FULL =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0|<br>
ERIF_TARGETED_GROUP_MEMBER =A0| =A0 =A072 | =A01728 | =A0 =A0 =A0 | =A0 =A0=
 4 =A0 (0)|<br>
00:00:01 |<br>
|* 66 | =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02466 | 24660 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
|* 67 | =A0 =A0 =A0 =A0 =A0TABLE ACCESS CLUSTER =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0|<br>
ERIF_ORGANISATION_MEMBER =A0 =A0| =A0 =A0 1 | =A0 =A053 | =A0 =A0 =A0 | =A0=
 =A0 1 =A0 (0)|<br>
00:00:01 |<br>
|* 68 | =A0 =A0 =A0 =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0|<br>
ERIF_ORGANISATION_CLUST_IDX | =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 =A0 | =A0 =
=A0 0 =A0 (0)|<br>
00:00:01 |<br>
| =A069 | =A0 =A0 =A0 =A0 INDEX FAST FULL SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 | WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02466 | 24660 | =A0 =A0 =A0 | =A0 =A0 3 =A0 (0)=
| 00:00:01 |<br>
| =A070 | =A0 =A0NESTED LOOPS ANTI =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 |<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A053 | =A0 =A0 =A0 | =A0 =A0 2 =
=A0 (0)| 00:00:01 |<br>
| =A071 | =A0 =A0 TABLE ACCESS BY INDEX ROWID =A0 =A0 =A0 =A0 =A0 =A0 =A0|<=
br>
ERIF_RIF_ARCHIVE =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 1 | =A0 =A043 | =A0 =A0 =
=A0 | =A0 =A0 2 =A0 (0)|<br>
00:00:01 |<br>
|* 72 | =A0 =A0 =A0INDEX RANGE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0|<br>
ERIF_RIF_ARCHIVE_PK =A0 =A0 =A0 =A0 | =A0 =A0 1 | =A0 =A0 =A0 | =A0 =A0 =A0=
 | =A0 =A0 1 =A0 (0)|<br>
00:00:01 |<br>
|* 73 | =A0 =A0 INDEX UNIQUE SCAN =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0| WP_PENDING_PK<br>
 =A0 =A0 =A0 =A0 =A0 =A0| =A02466 | 24660 | =A0 =A0 =A0 | =A0 =A0 0 =A0 (0)=
| 00:00:01 |<br>
---------------------------------------------------------------------------=
---------------------------------------------------------<br>
<br>
<br>
<br>
<br>
Predicate Information (identified by operation id):<br>
---------------------------------------------------<br>
 =A0 2 - filter( NOT EXISTS (SELECT /*+ &lt;not feasible&gt;)<br>
 =A0 5 - access(&quot;T0&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot; A=
ND &quot;T0&quot;.&quot;WP_ID&quot;(+)=3D&quot;WP_ID&quot;)<br>
 =A0 9 - access(ROWID=3DROWID)<br>
 =A012 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A014 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A017 - filter(DECODE(&quot;RIFRC&quot;.&quot;CATEGORY_CODE&quot;,NULL,<br=
>
0,TO_NUMBER(&quot;RIFRC&quot;.&quot;CATEGORY_CODE&quot;))=3DTO_NUMBER(&quot=
;$kkqu_col_1&quot;))<br>
 =A018 - access(&quot;RIFRC&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot=
;)<br>
 =A021 - filter(&quot;RIFTG&quot;.&quot;TARGETED_GROUP_ID&quot; IS NULL)<br=
>
 =A022 - access(&quot;RIFTG&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot=
;)<br>
 =A024 - access(&quot;RIF_ID&quot;=3D&quot;RIF_ID&quot;)<br>
 =A025 - filter(&quot;RIFTG&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot=
;)<br>
 =A028 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A029 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A034 - filter(&quot;RIFRC&quot;.&quot;RIF_ID&quot;(+)=3D&quot;RIF_ID&quot=
;)<br>
 =A038 - access(ROWID=3DROWID)<br>
 =A039 - access(ROWID=3DROWID)<br>
 =A043 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A046 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A047 - filter(&quot;CLOSED&quot;=3D0 OR &quot;CLOSED&quot;=3D1 AND =A0EXI=
STS (SELECT 0 FROM<br>
CRMS.&quot;ERIF_ORGANISATION_MEMBER&quot;<br>
<br>
&quot;ERIF_ORGANISATION_MEMBER&quot;,CRMS.&quot;ERIF_TARGETED_GROUP_MEMBER&=
quot;<br>
&quot;ERIF_TARGETED_GROUP_MEMBER&quot;,CRMS.&quot;WP_PENDING&quot;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0&quot;WP_PENDING&quot;,CRMS.&quot;WP_PENDING&qu=
ot; &quot;WP_PENDING&quot; WHERE<br>
&quot;WP_ID&quot;=3D&quot;WP_ID&quot; AND &quot;WP_ID&quot;=3D&quot;WP_ID&q=
uot; AND &quot;TARGETED_GROUP_ID&quot;=3D:B1 AND<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0&quot;ORGANISATION_CODE&quot;=3D&quot;ORGANISAT=
ION_CODE&quot; AND<br>
&quot;COUNTRY_CODE&quot;=3D&quot;COUNTRY_CODE&quot; AND (&quot;END_DATE&quo=
t; IS NULL OR<br>
&quot;END_DATE&quot;&gt;=3DSYSDATE@!)<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0AND &quot;USER_ID&quot;=3D&quot;RIF_SUPPORT&quo=
t;.&quot;GETUSERID&quot;() AND<br>
&quot;BEGIN_DATE&quot;&lt;=3DSYSDATE@!))<br>
 =A054 - access(&quot;RIF_ID&quot;=3D&quot;RIF_ID&quot;)<br>
 =A056 - access(&quot;RIF_ID&quot;=3D&quot;RIF_ID&quot;)<br>
 =A0 =A0 =A0 filter(&quot;RIF_ID&quot;=3D&quot;RIF_ID&quot;)<br>
 =A057 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A058 - filter(&quot;END_DATE&quot; IS NULL OR &quot;END_DATE&quot;&gt;=3D=
&quot;CREATION_DATE&quot;)<br>
 =A059 - access(&quot;TARGETED_GROUP_ID&quot;=3D&quot;TARGETED_GROUP_ID&quo=
t; AND<br>
&quot;BEGIN_DATE&quot;&lt;=3D&quot;CREATION_DATE&quot;)<br>
 =A060 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A061 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A062 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A065 - filter(&quot;TARGETED_GROUP_ID&quot;=3D:B1)<br>
 =A066 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
 =A067 - filter((&quot;END_DATE&quot; IS NULL OR &quot;END_DATE&quot;&gt;=
=3DSYSDATE@!) AND<br>
&quot;USER_ID&quot;=3D&quot;RIF_SUPPORT&quot;.&quot;GETUSERID&quot;() AND<b=
r>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0&quot;BEGIN_DATE&quot;&lt;=3DSYSDATE@!)<br>
 =A068 - access(&quot;COUNTRY_CODE&quot;=3D&quot;COUNTRY_CODE&quot; AND<br>
&quot;ORGANISATION_CODE&quot;=3D&quot;ORGANISATION_CODE&quot;)<br>
 =A072 - access(&quot;RIF_ID&quot;=3D:B1)<br>
 =A073 - access(&quot;WP_ID&quot;=3D&quot;WP_ID&quot;)<br>
<br>
Note<br>
-----<br>
 =A0 - dynamic sampling used for this statement (level=3D4)<br>
<br>
Statistics<br>
----------------------------------------------------------<br>
 =A0 =A0 =A015863 =A0recursive calls<br>
 =A0 =A0 =A0 =A0 23 =A0db block gets<br>
 =A0 62252048 =A0consistent gets<br>
 =A0 =A0 =A0 7048 =A0physical reads<br>
 =A0 =A0 =A0 =A0 =A00 =A0redo size<br>
 =A0 =A0 =A014444 =A0bytes sent via SQL*Net to client<br>
 =A0 =A0 =A0 =A0434 =A0bytes received via SQL*Net from client<br>
 =A0 =A0 =A0 =A0 12 =A0SQL*Net roundtrips to/from client<br>
 =A0 =A0 =A014452 =A0sorts (memory)<br>
 =A0 =A0 =A0 =A0 =A00 =A0sorts (disk)<br>
 =A0 =A0 =A0 =A0161 =A0rows processed<br>
<br>
<br>
<br>
<br>
------------------------------------------<br>
10046 to pa=F0u vien r=E2da.<br>
Ja nu viss te satilps, tad, es dom=E2ju, b=FBs interesanti, un varb=FBt ar=
=EE<br>
k=E2ds padoms atrad=EEsies. =A0Es nesaprotu. Pam=E7=ECin=E2ju paskat=EEties=
 ar=EE<br>
10053 trasi, bet t=E2 =EEsi nem=E2c=E7ju neko b=FBtisku ieraudz=EEt (vai ka=
ut kur<br>
ir k=E2da pam=E2c=EEba, k=E2 interpret=E7t optimizatora trases?), ar=EE v10=
053.exe<br>
diez ko nel=EEdz=E7ja.<br>
Ceru, ka b=FBs interesanti, un ceru ar=EE, ka k=E2da ideja uzrad=EEsies;<br=
>
pie=EFauju, ka =F0aj=E2 sabiedr=EEb=E2 var=E7tu b=FBt =EFaudis, kas uzreiz =
ieraudz=EEs<br>
atbildi.<br>
Paldies jau iepriek=F0!<br>
<span><font color=3D"#888888">Uldis P=E2vuls<span class=3D"HOEnZb"><font co=
lor=3D"#888888"><br>
</font></span></font></span><span class=3D"HOEnZb"><font color=3D"#888888">=
<div><div><br>
--<br>
J=FBs sa=F2=E7m=E2t =F0o zi=F2ojumu, jo abon=E7j=E2t Google grupu &quot;Lat=
vian Oracle User<br>
Group&quot; grupa.<br>
Lai nos=FBt=EEtu zi=F2ojumu =F0ai grupai, s=FBtiet e-pastu uz<br>
<a href=3D"mailto:lvoug@googlegroups.com" target=3D"_blank">lvoug@googlegro=
ups.com</a><br>
Lai redz=E7tu papildiesp=E7jas, apmekl=E7jiet =F0o grupu<br>
<a href=3D"http://lvoug.lv" target=3D"_blank">http://lvoug.lv</a><br>
</div></div></font></span></blockquote></div><span class=3D"HOEnZb"><font c=
olor=3D"#888888"><br></font></span></div></div><span class=3D"HOEnZb"><font=
 color=3D"#888888">

<p></p>

-- <br>
J=FBs sa=F2=E7m=E2t =F0o zi=F2ojumu, jo abon=E7j=E2t Google grupu &quot;Lat=
vian Oracle User<br>
Group&quot; grupa.<br>
Lai nos=FBt=EEtu zi=F2ojumu =F0ai grupai, s=FBtiet e-pastu uz<br>
<a href=3D"mailto:lvoug@googlegroups.com" target=3D"_blank">lvoug@googlegro=
ups.com</a><br>
Lai redz=E7tu papildiesp=E7jas, apmekl=E7jiet =F0o grupu<br>
<a href=3D"http://lvoug.lv" target=3D"_blank">http://lvoug.lv</a><br>
</font></span></blockquote></div><br>

--20cf307f33eeacd35404c2e4f6c6--
--20cf307f33eeacd35904c2e4f6c8
Content-Type: application/octet-stream; name="DAV_ora_12957.trc"
Content-Disposition: attachment; filename="DAV_ora_12957.trc"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_h3o9n4xa0

VHJhY2UgZmlsZSAvb3B0L29yYWNsZS8xMTIvZGlhZy9yZGJtcy9kYXYvREFWL3RyYWNlL0RBVl9v
cmFfMTI5NTcudHJjCk9yYWNsZSBEYXRhYmFzZSAxMWcgRW50ZXJwcmlzZSBFZGl0aW9uIFJlbGVh
c2UgMTEuMi4wLjIuMCAtIDY0Yml0IFByb2R1Y3Rpb24KV2l0aCB0aGUgUGFydGl0aW9uaW5nIGFu
ZCBPcmFjbGUgTGFiZWwgU2VjdXJpdHkgb3B0aW9ucwpPUkFDTEVfSE9NRSA9IC9vcHQvb3JhY2xl
LzExMi9wcm9kdWN0LzExLjIuMC9kYmhvbWVfMQpTeXN0ZW0gbmFtZToJTGludXgKTm9kZSBuYW1l
Oglsdi1kYXZhbnUtZGIubmUuMWRjLmNvbQpSZWxlYXNlOgkyLjYuOS0xMDMuRUxzbXAKVmVyc2lv
bjoJIzEgU01QIEZyaSBOb3YgMTEgMTQ6Mjg6MTYgRVNUIDIwMTEKTWFjaGluZToJeDg2XzY0Cklu
c3RhbmNlIG5hbWU6IERBVgpSZWRvIHRocmVhZCBtb3VudGVkIGJ5IHRoaXMgaW5zdGFuY2U6IDEK
T3JhY2xlIHByb2Nlc3MgbnVtYmVyOiA0NQpVbml4IHByb2Nlc3MgcGlkOiAxMjk1NywgaW1hZ2U6
IG9yYWNsZUBsdi1kYXZhbnUtZGIubmUuMWRjLmNvbQoKCioqKiAyMDEyLTA1LTA3IDE0OjM1OjUx
LjA2NQoqKiogU0VTU0lPTiBJRDooNjQ5LjEwNDExKSAyMDEyLTA1LTA3IDE0OjM1OjUxLjA2NQoq
KiogQ0xJRU5UIElEOigpIDIwMTItMDUtMDcgMTQ6MzU6NTEuMDY1CioqKiBTRVJWSUNFIE5BTUU6
KFNZUyRVU0VSUykgMjAxMi0wNS0wNyAxNDozNTo1MS4wNjUKKioqIE1PRFVMRSBOQU1FOigpIDIw
MTItMDUtMDcgMTQ6MzU6NTEuMDY1CioqKiBBQ1RJT04gTkFNRTooKSAyMDEyLTA1LTA3IDE0OjM1
OjUxLjA2NQogCnVwZHJvdzogQ1IgZXJyb3IgdGFibGUgMCAtIHJvd2lkOiAwMDAyOThjYi4wMTY3
M2I4Ni5hIGNvZGUgMjAKdXBkUlQgZnJhbWUgQDB4YThmN2FkYjgKa2NjQXJyX3FlZG1EbWwgMHhh
OGY3YTkzMApuS2Njc19xZWRtRG1sIDE0MgprYWZfcWVkbURtbCAweGFlZmIyY2MwCm5LYWZfcWVk
bURtbCAxNDIKa2N0X3FlZG1EbWwgMHg4YWJmMjJiOApyb3dpZF9xZWRtRG1sIDB4OWQ1MjUwYzgK
a2F1X3FlZG1EbWwgKG5pbCkKZGVsYXllZEthdV9xZWRtRG1sIChuaWwpCnJldHVybl9xZWRtRG1s
IChuaWwpCnRyaWdnZXJfcWVkbURtbCAweDhhYmY0M2MwCm9sY19xZWRtRG1sIChuaWwpCm50YkN0
eF9xZWRtRG1sIChuaWwpCmluc1RyaWdfcWVkbURtbCAobmlsKQpoaWVyX3FlZG1EbWwgKG5pbCkK
ZHluQ29uX3FlZG1EbWwgKG5pbCkKY2hlY2tfcWVkbURtbCAobmlsKQpybHNDaGVja19xZWRtRG1s
IChuaWwpCmZnYV9xZWRtRG1sIChuaWwpCmNzZXNfcWVkbURtbCAobmlsKQplbHJ0eF9xZWRtRG1s
IChuaWwpCnBtYXBfcWVkbURtbCAobmlsKQpsYm5yIChuaWwpCnVwZXNfcWVkbVVwZCAweGE4Zjdh
OGU4Cm5Db2xzX3FlZG1VcGQgMjUKa2R1X3FlZG1VcGQgMHhhOGY3OWFhOAprYXV4dV9xZWRtVXBk
IDB4YThmNzkxMzAKcmhzQ29sc19xZWRtVXBkIDB4OWQ1MjYxYzAKblJoc0NvbHNfcWVkbVVwZCAy
MVJIUyBDb2x1bW5zOgoJa2NjY2lkPTEsIGtjY3R5cD0xLCBrY2NmbGc9MHg4MDIwCglrY2NjaWQ9
Miwga2NjdHlwPTEsIGtjY2ZsZz0weDgwYTgKCWtjY2NpZD0zLCBrY2N0eXA9MSwga2NjZmxnPTB4
ODBhOAoJa2NjY2lkPTUsIGtjY3R5cD0xLCBrY2NmbGc9MHg4MGE4CglrY2NjaWQ9Nywga2NjdHlw
PTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD0xMiwga2NjdHlwPTEsIGtjY2ZsZz0weDgwYTgKCWtj
Y2NpZD0xOSwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD0yMCwga2NjdHlwPTEsIGtj
Y2ZsZz0weDgwMjAKCWtjY2NpZD0yMSwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD0z
OCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD00MSwga2NjdHlwPTEsIGtjY2ZsZz0w
eDgwMjAKCWtjY2NpZD00Mywga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD00Niwga2Nj
dHlwPTIsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD02MCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAK
CWtjY2NpZD03MCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMDA4MDIyCglrY2NjaWQ9NzEsIGtjY3R5
cD0xMiwga2NjZmxnPTB4ODAwMDgwMjIKCWtjY2NpZD03Mywga2NjdHlwPTEsIGtjY2ZsZz0weDgw
MjAKCWtjY2NpZD03NCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD04MCwga2NjdHlw
PTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD04MSwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtj
Y2NpZD05NCwga2NjdHlwPTIsIGtjY2ZsZz0weDgwYTgKaGlMb2dDb2xfcWVkbVVwZCAwCmhpQ21w
Q29sX3FlZG1VcGQgMTQxCmhpQ3B5Q29sX3FlZG1VcGQgMTQxCmhpVXBkQ29sX3FlZG1VcGQgOTQK
a2FmX3FlZG1VcGQgKG5pbCkKbkthZl9xZWRtVXBkIDAKaW90S2V5c19xZWRtVXBkIChuaWwpCm50
YWJPcG5fcWVkbVVwZCAobmlsKQpyaGNfcWVkbVVwZCAobmlsKQpjcHlrYWZpZHhfcWVkbVVwZCAw
eGE4Zjc5NjY4CmNweWthZmlkeGNjX3FlZG1VcGQgMTAKY3B5a2NjaWR4X3FlZG1VcGQgMHhhOGY3
OTZhOApjcHlrY2NpZHhjY19xZWRtVXBkIDEwCmZsYWdzX3FlZG1VcGQgMHgxMDA4MDgwOApycGtL
YXV4dV9xZWRtVXBkIChuaWwpCgoqKiogMjAxMi0wNS0wNyAxNDozNTo1MS45MjgKSW5jaWRlbnQg
MzcxNjEgY3JlYXRlZCwgZHVtcCBmaWxlOiAvb3B0L29yYWNsZS8xMTIvZGlhZy9yZGJtcy9kYXYv
REFWL2luY2lkZW50L2luY2Rpcl8zNzE2MS9EQVZfb3JhXzEyOTU3X2kzNzE2MS50cmMKT1JBLTAw
NjAwOiBpbnRlcm5hbCBlcnJvciBjb2RlLCBhcmd1bWVudHM6IFsxMzAzMF0sIFsyMF0sIFtdLCBb
XSwgW10sIFtdLCBbXSwgW10sIFtdLCBbXSwgW10sIFtdCgp1cGRyb3c6IENSIGVycm9yIHRhYmxl
IDAgLSByb3dpZDogMDAwMjk4Y2IuMDE2NzNiODYuYSBjb2RlIDIwCgoqKiogMjAxMi0wNS0wNyAx
NToxNzoyMy41MDIKdXBkUlQgZnJhbWUgQDB4YThmN2FkYjgKa2NjQXJyX3FlZG1EbWwgMHhhOGY3
YTkzMApuS2Njc19xZWRtRG1sIDE0MgprYWZfcWVkbURtbCAweGFlZmIyY2MwCm5LYWZfcWVkbURt
bCAxNDIKa2N0X3FlZG1EbWwgMHg4YWJmMjJiOApyb3dpZF9xZWRtRG1sIDB4OWQ1MjUwYzgKa2F1
X3FlZG1EbWwgKG5pbCkKZGVsYXllZEthdV9xZWRtRG1sIChuaWwpCnJldHVybl9xZWRtRG1sIChu
aWwpCnRyaWdnZXJfcWVkbURtbCAweDhhYmY0M2MwCm9sY19xZWRtRG1sIChuaWwpCm50YkN0eF9x
ZWRtRG1sIChuaWwpCmluc1RyaWdfcWVkbURtbCAobmlsKQpoaWVyX3FlZG1EbWwgKG5pbCkKZHlu
Q29uX3FlZG1EbWwgKG5pbCkKY2hlY2tfcWVkbURtbCAobmlsKQpybHNDaGVja19xZWRtRG1sIChu
aWwpCmZnYV9xZWRtRG1sIChuaWwpCmNzZXNfcWVkbURtbCAobmlsKQplbHJ0eF9xZWRtRG1sIChu
aWwpCnBtYXBfcWVkbURtbCAobmlsKQpsYm5yIChuaWwpCnVwZXNfcWVkbVVwZCAweGE4ZjdhOGU4
Cm5Db2xzX3FlZG1VcGQgMjUKa2R1X3FlZG1VcGQgMHhhOGY3OWFhOAprYXV4dV9xZWRtVXBkIDB4
YThmNzkxMzAKcmhzQ29sc19xZWRtVXBkIDB4OWQ1MjYxYzAKblJoc0NvbHNfcWVkbVVwZCAyMVJI
UyBDb2x1bW5zOgoJa2NjY2lkPTEsIGtjY3R5cD0xLCBrY2NmbGc9MHg4MDIwCglrY2NjaWQ9Miwg
a2NjdHlwPTEsIGtjY2ZsZz0weDgwYTgKCWtjY2NpZD0zLCBrY2N0eXA9MSwga2NjZmxnPTB4ODBh
OAoJa2NjY2lkPTUsIGtjY3R5cD0xLCBrY2NmbGc9MHg4MGE4CglrY2NjaWQ9Nywga2NjdHlwPTEs
IGtjY2ZsZz0weDgwMjAKCWtjY2NpZD0xMiwga2NjdHlwPTEsIGtjY2ZsZz0weDgwYTgKCWtjY2Np
ZD0xOSwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD0yMCwga2NjdHlwPTEsIGtjY2Zs
Zz0weDgwMjAKCWtjY2NpZD0yMSwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD0zOCwg
a2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD00MSwga2NjdHlwPTEsIGtjY2ZsZz0weDgw
MjAKCWtjY2NpZD00Mywga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD00Niwga2NjdHlw
PTIsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD02MCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtj
Y2NpZD03MCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMDA4MDIyCglrY2NjaWQ9NzEsIGtjY3R5cD0x
Miwga2NjZmxnPTB4ODAwMDgwMjIKCWtjY2NpZD03Mywga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAK
CWtjY2NpZD03NCwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2NpZD04MCwga2NjdHlwPTEs
IGtjY2ZsZz0weDgwMjAKCWtjY2NpZD04MSwga2NjdHlwPTEsIGtjY2ZsZz0weDgwMjAKCWtjY2Np
ZD05NCwga2NjdHlwPTIsIGtjY2ZsZz0weDgwYTgKaGlMb2dDb2xfcWVkbVVwZCAwCmhpQ21wQ29s
X3FlZG1VcGQgMTQxCmhpQ3B5Q29sX3FlZG1VcGQgMTQxCmhpVXBkQ29sX3FlZG1VcGQgOTQKa2Fm
X3FlZG1VcGQgKG5pbCkKbkthZl9xZWRtVXBkIDAKaW90S2V5c19xZWRtVXBkIChuaWwpCm50YWJP
cG5fcWVkbVVwZCAobmlsKQpyaGNfcWVkbVVwZCAobmlsKQpjcHlrYWZpZHhfcWVkbVVwZCAweGE4
Zjc5NjY4CmNweWthZmlkeGNjX3FlZG1VcGQgMTAKY3B5a2NjaWR4X3FlZG1VcGQgMHhhOGY3OTZh
OApjcHlrY2NpZHhjY19xZWRtVXBkIDEwCmZsYWdzX3FlZG1VcGQgMHgxMDA4MDgwOApycGtLYXV4
dV9xZWRtVXBkIChuaWwpCgoqKiogMjAxMi0wNS0wNyAxNToxNzoyNC42NDEKSW5jaWRlbnQgMzcx
NjIgY3JlYXRlZCwgZHVtcCBmaWxlOiAvb3B0L29yYWNsZS8xMTIvZGlhZy9yZGJtcy9kYXYvREFW
L2luY2lkZW50L2luY2Rpcl8zNzE2Mi9EQVZfb3JhXzEyOTU3X2kzNzE2Mi50cmMKT1JBLTAwNjAw
OiBpbnRlcm5hbCBlcnJvciBjb2RlLCBhcmd1bWVudHM6IFsxMzAzMF0sIFsyMF0sIFtdLCBbXSwg
W10sIFtdLCBbXSwgW10sIFtdLCBbXSwgW10sIFtdCgo=
--20cf307f33eeacd35904c2e4f6c8--