215187.1 SQLT XECUTE 11.4.5.10 Report: sqlt_s29544_lite.html


Plans Summary

                           Avg
                          User   Avg
                     AVG   I/O Other
               Avg   CPU  Wait  Wait
           Elapsed  Time  Time  Time    Avg   Avg    Avg                                Total
 Plan Hash Time in    in    in    in Buffer  Disk Direct  Avg Rows      Total   Total Version Total         Total
     Value    secs  secs  secs  secs   Gets Reads Writes Processed Executions Fetches   Count Loads Invalidations Src Source
---------- ------- ----- ----- ----- ------ ----- ------ --------- ---------- ------- ------- ----- ------------- --- --------------------
3915546322   0.263 0.170 0.152 0.000     74     7      0         0          3       3       1     1             0 MEM GV$SQLAREA_PLAN_HASH
1957132478                                                                                                        XPL EXPLAIN PLAN FOR

Plans

#SourcePlan
Hash Value
SQL
Handle
Plan
Name
Inst
ID
Child
Number
ExecutionsFormat
1 GV$SQL_PLAN 3915546322 1 0 3 ADVANCED ALLSTATS LAST
2 GV$SQL_PLAN 3915546322 1 0 3 ADVANCED ALLSTATS
3 PLAN_TABLE 1957132478 ADVANCED
Display of child plans is restricted up to 300 per phv as per tool parameter "r_rows_table_m".

GV$SQL_PLAN  phv:3915546322  inst:1  child:0  execs:3  format:ADVANCED ALLSTATS LAST

Plan hash value: 3915546322

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                 | Name                          | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time   | Pstart| Pstop | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                          |                               |      1 |        |       |    65 (100)|          |       |       |      0 |00:00:00.01 |      48 |       |       |          |
|   1 |  SORT AGGREGATE                           |                               |      0 |      1 |    39 |            |          |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|*  2 |   INDEX RANGE SCAN                        | PI_DATTR__DI_TA_3V            |      0 |      1 |    39 |     4   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|   3 |  SORT ORDER BY                            |                               |      1 |      1 |   146 |    65   (4)| 00:00:01 |       |       |      0 |00:00:00.01 |      48 |  1024 |  1024 |          |
|*  4 |   FILTER                                  |                               |      1 |        |       |            |          |       |       |      0 |00:00:00.01 |      48 |       |       |          |
|   5 |    NESTED LOOPS ANTI                      |                               |      1 |      1 |   146 |    63   (2)| 00:00:01 |       |       |      0 |00:00:00.01 |      48 |       |       |          |
|   6 |     NESTED LOOPS SEMI                     |                               |      1 |      1 |   105 |    59   (2)| 00:00:01 |       |       |      0 |00:00:00.01 |      48 |       |       |          |
|   7 |      NESTED LOOPS                         |                               |      1 |      1 |    90 |    58   (2)| 00:00:01 |       |       |      0 |00:00:00.01 |      48 |       |       |          |
|   8 |       SORT UNIQUE                         |                               |      1 |      1 |    41 |    38   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |      48 |  1024 |  1024 |          |
|   9 |        PARTITION RANGE SINGLE             |                               |      1 |      1 |    41 |    38   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |      48 |       |       |          |
|  10 |         PARTITION RANGE ALL               |                               |      1 |      1 |    41 |    38   (0)| 00:00:01 |     1 |    18 |      0 |00:00:00.01 |      48 |       |       |          |
|* 11 |          TABLE ACCESS BY LOCAL INDEX ROWID| DOC_ATTR                      |     18 |      1 |    41 |    38   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |      48 |       |       |          |
|* 12 |           INDEX RANGE SCAN                | PI_DATTR__TI_PI_DM_TA_3V      |     18 |      1 |       |    37   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |      48 |       |       |          |
|  13 |       PARTITION RANGE SINGLE              |                               |      0 |      2 |    98 |    19   (0)| 00:00:01 |KEY(AP)|KEY(AP)|      0 |00:00:00.01 |       0 |       |       |          |
|  14 |        PARTITION RANGE ALL                |                               |      0 |      2 |    98 |    19   (0)| 00:00:01 |     1 |    18 |      0 |00:00:00.01 |       0 |       |       |          |
|* 15 |         TABLE ACCESS BY LOCAL INDEX ROWID | DOC_RELATIONS                 |      0 |      2 |    98 |    19   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |       0 |       |       |          |
|* 16 |          INDEX RANGE SCAN                 | PI_DRELS__DI_RI_FD_2RT        |      0 |      1 |       |    18   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |       0 |       |       |          |
|* 17 |      INDEX UNIQUE SCAN                    | UQ_DOC_TEMPLATES__TID_DID_IID |      0 |      1 |    15 |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 18 |     TABLE ACCESS BY GLOBAL INDEX ROWID    | DOC_ATTR                      |      0 |      1 |    41 |     4   (0)| 00:00:01 | ROWID | ROWID |      0 |00:00:00.01 |       0 |       |       |          |
|* 19 |      INDEX RANGE SCAN                     | PI_DATTR__DI_TA_3V            |      0 |      1 |       |     3   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 20 |    FILTER                                 |                               |      0 |        |       |            |          |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 21 |     TABLE ACCESS BY INDEX ROWID           | ACMTT_ACL_MEMBERS             |      0 |      1 |    19 |     3   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 22 |      INDEX RANGE SCAN                     | I_ACL_MBRS__AI_II_OI_OT       |      0 |      1 |       |     2   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 23 |     INDEX UNIQUE SCAN                     | UQ_GR_MBRS__UI_II_GI          |      0 |      1 |    14 |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 24 |    TABLE ACCESS BY INDEX ROWID            | DOC_MEMBERS                   |      0 |      1 |    47 |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 25 |     INDEX RANGE SCAN                      | I_DOC_MBRS__DI_UI_II          |      0 |      1 |       |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 26 |    TABLE ACCESS BY INDEX ROWID            | ACMTT_ACL_MEMBERS             |      0 |      1 |    17 |     3   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
|* 27 |     INDEX RANGE SCAN                      | I_ACL_MBRS__AI_II_OI_OT       |      0 |      1 |       |     2   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |       |       |          |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$2
   2 - SEL$2        / DA@SEL$2
   3 - SEL$E86218C0
  11 - SEL$E86218C0 / DOC_ATTR@SEL$4
  12 - SEL$E86218C0 / DOC_ATTR@SEL$4
  15 - SEL$E86218C0 / R@SEL$1
  16 - SEL$E86218C0 / R@SEL$1
  17 - SEL$E86218C0 / DOC_TEMPLATES@SEL$3
  18 - SEL$E86218C0 / DOC_ATTR@SEL$5
  19 - SEL$E86218C0 / DOC_ATTR@SEL$5
  20 - SEL$68B588A0
  21 - SEL$68B588A0 / ACMTT_ACL_MEMBERS@SEL$7
  22 - SEL$68B588A0 / ACMTT_ACL_MEMBERS@SEL$7
  23 - SEL$8        / GROUP_MEMBERS@SEL$8
  24 - SEL$11       / DOC_MEMBERS@SEL$11
  25 - SEL$11       / DOC_MEMBERS@SEL$11
  26 - SEL$0EE6DB63 / ACMTT_ACL_MEMBERS@SEL$10
  27 - SEL$0EE6DB63 / ACMTT_ACL_MEMBERS@SEL$10

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
      DB_VERSION('11.2.0.3')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$2")
      OUTLINE_LEAF(@"SEL$8")
      OUTLINE_LEAF(@"SEL$68B588A0")
      MERGE(@"SEL$7")
      OUTLINE_LEAF(@"SEL$0EE6DB63")
      MERGE(@"SEL$10")
      OUTLINE_LEAF(@"SEL$11")
      OUTLINE_LEAF(@"SEL$E86218C0")
      UNNEST(@"SEL$3")
      UNNEST(@"SEL$4")
      UNNEST(@"SEL$5")
      OUTLINE(@"SEL$6")
      OUTLINE(@"SEL$7")
      OUTLINE(@"SEL$9")
      OUTLINE(@"SEL$10")
      OUTLINE(@"SEL$1")
      OUTLINE(@"SEL$3")
      OUTLINE(@"SEL$4")
      OUTLINE(@"SEL$5")
      INDEX_RS_ASC(@"SEL$E86218C0" "DOC_ATTR"@"SEL$4" ("DOC_ATTR"."TEMPLATE_ID" "DOC_ATTR"."PARENT_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"
              "DOC_ATTR"."DOC_ID"))
      INDEX_RS_ASC(@"SEL$E86218C0" "R"@"SEL$1" ("DOC_RELATIONS"."DOC_ID" "DOC_RELATIONS"."RELATED_ID" "DOC_RELATIONS"."FLG_DEL" "DOC_RELATIONS"."RELATED_TYPE" "DOC_RELATIONS"."REL_TYPE"))
      INDEX(@"SEL$E86218C0" "DOC_TEMPLATES"@"SEL$3" ("DOC_TEMPLATES"."TEMPLATE_ID" "DOC_TEMPLATES"."DOC_ID" "DOC_TEMPLATES"."INSTANCE_ID"))
      INDEX_RS_ASC(@"SEL$E86218C0" "DOC_ATTR"@"SEL$5" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      LEADING(@"SEL$E86218C0" "DOC_ATTR"@"SEL$4" "R"@"SEL$1" "DOC_TEMPLATES"@"SEL$3" "DOC_ATTR"@"SEL$5")
      USE_NL(@"SEL$E86218C0" "R"@"SEL$1")
      USE_NL(@"SEL$E86218C0" "DOC_TEMPLATES"@"SEL$3")
      USE_NL(@"SEL$E86218C0" "DOC_ATTR"@"SEL$5")
      INDEX_RS_ASC(@"SEL$11" "DOC_MEMBERS"@"SEL$11" ("DOC_MEMBERS"."DOC_ID" "DOC_MEMBERS"."USER_ID" "DOC_MEMBERS"."INSTANCE_ID"))
      INDEX_RS_ASC(@"SEL$0EE6DB63" "ACMTT_ACL_MEMBERS"@"SEL$10" ("ACMTT_ACL_MEMBERS"."ACL_ID" "ACMTT_ACL_MEMBERS"."INSTANCE_ID" "ACMTT_ACL_MEMBERS"."OBJECT_ID" "ACMTT_ACL_MEMBERS"."OBJECT_TYPE"))
      INDEX_RS_ASC(@"SEL$68B588A0" "ACMTT_ACL_MEMBERS"@"SEL$7" ("ACMTT_ACL_MEMBERS"."ACL_ID" "ACMTT_ACL_MEMBERS"."INSTANCE_ID" "ACMTT_ACL_MEMBERS"."OBJECT_ID" "ACMTT_ACL_MEMBERS"."OBJECT_TYPE"))
      INDEX(@"SEL$2" "DA"@"SEL$2" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      INDEX(@"SEL$8" "GROUP_MEMBERS"@"SEL$8" ("GROUP_MEMBERS"."USER_ID" "GROUP_MEMBERS"."INSTANCE_ID" "GROUP_MEMBERS"."GROUP_ID"))
      END_OUTLINE_DATA
  */

Peeked Binds (identified by position):
--------------------------------------

   1 - (NUMBER): 3636688
   2 - (NUMBER): 7
   3 - (NUMBER): 29440
   4 - (NUMBER): 177
   5 - (NUMBER): 5179
   6 - (NUMBER, Primary=5)
   7 - (NUMBER, Primary=5)
   8 - (NUMBER): 15096
   9 - (NUMBER, Primary=8)
  10 - (NUMBER, Primary=4)
  11 - (NUMBER, Primary=4)
  12 - (NUMBER, Primary=8)
  13 - (NUMBER, Primary=4)
  14 - (NUMBER, Primary=8)
  15 - (NUMBER, Primary=4)

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("DOC_ID"=:B1 AND "TA_ID"=:B5)
   4 - filter(( IS NOT NULL OR  IS NOT NULL OR ("R"."ID_OWNER"=:B1 AND  IS NOT NULL)))
  11 - filter("INSTANCE_ID"=:B2)
  12 - access("TEMPLATE_ID"=:B6 AND "PARENT_ID"=23224 AND "CVALUE"='v pr??b??hu')
       filter("CVALUE"='v pr??b??hu')
  15 - filter(("R"."CHANGED">SYSDATE@!-:B4 AND INTERNAL_FUNCTION("R"."FLG") AND "INSTANCE_ID"=:B2 AND "INSTANCE_ID"="R"."INSTANCE_ID"))
  16 - access("R"."DOC_ID"=:B3 AND "DOC_ID"="R"."RELATED_ID" AND "FLG_DEL" IS NULL)
       filter(("REL_TYPE"<>'X' AND "R"."RELATED_TYPE"<>(-1)))
  17 - access("TEMPLATE_ID"=:B6 AND "DOC_ID"="R"."RELATED_ID" AND "INSTANCE_ID"=:B2)
       filter("INSTANCE_ID"="R"."INSTANCE_ID")
  18 - filter(("PARENT_ID"=23188 AND "TEMPLATE_ID"=:B6 AND "INSTANCE_ID"=:B2))
  19 - access("DOC_ID"="R"."RELATED_ID" AND "CVALUE"='storno')
       filter("CVALUE"='storno')
  20 - filter(("OBJECT_ID"=:B1 OR  IS NOT NULL))
  21 - filter(("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE '0__1%'))
  22 - access("ACL_ID"=:B1 AND "INSTANCE_ID"=:B2)
  23 - access("USER_ID"=:B1 AND "INSTANCE_ID"=:B2 AND "GROUP_ID"=:B1)
  24 - filter(("ACCESS_MASK" LIKE '1%' OR "ACCESS_MASK" LIKE '0__1%'))
  25 - access("DOC_ID"=:B1 AND "USER_ID"=:B1 AND "INSTANCE_ID"=:B2)
  26 - filter(("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE '0__1%'))
  27 - access("ACL_ID"=:B1 AND "INSTANCE_ID"=:B2 AND "OBJECT_TYPE"='O')
       filter("OBJECT_TYPE"='O')

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - (#keys=0) MIN(SUBSTR("DA"."CVALUE",-6)||"DA"."CVALUE")[4000]
   2 - "DA"."CVALUE"[VARCHAR2,4000]
   3 - (#keys=1) [4000], "R"."ID"[NUMBER,22]
   4 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22]
   5 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   6 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   7 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   8 - (#keys=2) "INSTANCE_ID"[NUMBER,22], "DOC_ID"[NUMBER,22]
   9 - "DOC_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22]
  10 - "DOC_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22]
  11 - "DOC_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22]
  12 - "DOC_ATTR".ROWID[ROWID,10], "DOC_ID"[NUMBER,22]
  13 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
  14 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
  15 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
  16 - "R".ROWID[ROWID,10], "R"."RELATED_ID"[NUMBER,22]
  19 - "DOC_ATTR".ROWID[ROWID,10]
  21 - "OBJECT_ID"[NUMBER,22]
  22 - "ACMTT_ACL_MEMBERS".ROWID[ROWID,10], "OBJECT_ID"[NUMBER,22]
  25 - "DOC_MEMBERS".ROWID[ROWID,10]
  27 - "ACMTT_ACL_MEMBERS".ROWID[ROWID,10]


GV$SQL_PLAN  phv:3915546322  inst:1  child:0  execs:3  format:ADVANCED ALLSTATS

Plan hash value: 3915546322

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                 | Name                          | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time   | Pstart| Pstop | A-Rows |   A-Time   | Buffers | Reads  |  OMem |  1Mem |  O/1/M   |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                          |                               |      3 |        |       |    65 (100)|          |       |       |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|   1 |  SORT AGGREGATE                           |                               |      0 |      1 |    39 |            |          |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|*  2 |   INDEX RANGE SCAN                        | PI_DATTR__DI_TA_3V            |      0 |      1 |    39 |     4   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|   3 |  SORT ORDER BY                            |                               |      3 |      1 |   146 |    65   (4)| 00:00:01 |       |       |      0 |00:00:00.45 |     144 |     18 |  1024 |  1024 |     3/0/0|
|*  4 |   FILTER                                  |                               |      3 |        |       |            |          |       |       |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|   5 |    NESTED LOOPS ANTI                      |                               |      3 |      1 |   146 |    63   (2)| 00:00:01 |       |       |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|   6 |     NESTED LOOPS SEMI                     |                               |      3 |      1 |   105 |    59   (2)| 00:00:01 |       |       |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|   7 |      NESTED LOOPS                         |                               |      3 |      1 |    90 |    58   (2)| 00:00:01 |       |       |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|   8 |       SORT UNIQUE                         |                               |      3 |      1 |    41 |    38   (0)| 00:00:01 |       |       |      0 |00:00:00.45 |     144 |     18 |  1024 |  1024 |     3/0/0|
|   9 |        PARTITION RANGE SINGLE             |                               |      3 |      1 |    41 |    38   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|  10 |         PARTITION RANGE ALL               |                               |      3 |      1 |    41 |    38   (0)| 00:00:01 |     1 |    18 |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|* 11 |          TABLE ACCESS BY LOCAL INDEX ROWID| DOC_ATTR                      |     54 |      1 |    41 |    38   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.45 |     144 |     18 |       |       |          |
|* 12 |           INDEX RANGE SCAN                | PI_DATTR__TI_PI_DM_TA_3V      |     54 |      1 |       |    37   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.44 |     144 |     18 |       |       |          |
|  13 |       PARTITION RANGE SINGLE              |                               |      0 |      2 |    98 |    19   (0)| 00:00:01 |KEY(AP)|KEY(AP)|      0 |00:00:00.01 |       0 |      0 |       |       |          |
|  14 |        PARTITION RANGE ALL                |                               |      0 |      2 |    98 |    19   (0)| 00:00:01 |     1 |    18 |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 15 |         TABLE ACCESS BY LOCAL INDEX ROWID | DOC_RELATIONS                 |      0 |      2 |    98 |    19   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 16 |          INDEX RANGE SCAN                 | PI_DRELS__DI_RI_FD_2RT        |      0 |      1 |       |    18   (0)| 00:00:01 |   KEY |   KEY |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 17 |      INDEX UNIQUE SCAN                    | UQ_DOC_TEMPLATES__TID_DID_IID |      0 |      1 |    15 |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 18 |     TABLE ACCESS BY GLOBAL INDEX ROWID    | DOC_ATTR                      |      0 |      1 |    41 |     4   (0)| 00:00:01 | ROWID | ROWID |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 19 |      INDEX RANGE SCAN                     | PI_DATTR__DI_TA_3V            |      0 |      1 |       |     3   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 20 |    FILTER                                 |                               |      0 |        |       |            |          |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 21 |     TABLE ACCESS BY INDEX ROWID           | ACMTT_ACL_MEMBERS             |      0 |      1 |    19 |     3   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 22 |      INDEX RANGE SCAN                     | I_ACL_MBRS__AI_II_OI_OT       |      0 |      1 |       |     2   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 23 |     INDEX UNIQUE SCAN                     | UQ_GR_MBRS__UI_II_GI          |      0 |      1 |    14 |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 24 |    TABLE ACCESS BY INDEX ROWID            | DOC_MEMBERS                   |      0 |      1 |    47 |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 25 |     INDEX RANGE SCAN                      | I_DOC_MBRS__DI_UI_II          |      0 |      1 |       |     1   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 26 |    TABLE ACCESS BY INDEX ROWID            | ACMTT_ACL_MEMBERS             |      0 |      1 |    17 |     3   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
|* 27 |     INDEX RANGE SCAN                      | I_ACL_MBRS__AI_II_OI_OT       |      0 |      1 |       |     2   (0)| 00:00:01 |       |       |      0 |00:00:00.01 |       0 |      0 |       |       |          |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$2
   2 - SEL$2        / DA@SEL$2
   3 - SEL$E86218C0
  11 - SEL$E86218C0 / DOC_ATTR@SEL$4
  12 - SEL$E86218C0 / DOC_ATTR@SEL$4
  15 - SEL$E86218C0 / R@SEL$1
  16 - SEL$E86218C0 / R@SEL$1
  17 - SEL$E86218C0 / DOC_TEMPLATES@SEL$3
  18 - SEL$E86218C0 / DOC_ATTR@SEL$5
  19 - SEL$E86218C0 / DOC_ATTR@SEL$5
  20 - SEL$68B588A0
  21 - SEL$68B588A0 / ACMTT_ACL_MEMBERS@SEL$7
  22 - SEL$68B588A0 / ACMTT_ACL_MEMBERS@SEL$7
  23 - SEL$8        / GROUP_MEMBERS@SEL$8
  24 - SEL$11       / DOC_MEMBERS@SEL$11
  25 - SEL$11       / DOC_MEMBERS@SEL$11
  26 - SEL$0EE6DB63 / ACMTT_ACL_MEMBERS@SEL$10
  27 - SEL$0EE6DB63 / ACMTT_ACL_MEMBERS@SEL$10

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
      DB_VERSION('11.2.0.3')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$2")
      OUTLINE_LEAF(@"SEL$8")
      OUTLINE_LEAF(@"SEL$68B588A0")
      MERGE(@"SEL$7")
      OUTLINE_LEAF(@"SEL$0EE6DB63")
      MERGE(@"SEL$10")
      OUTLINE_LEAF(@"SEL$11")
      OUTLINE_LEAF(@"SEL$E86218C0")
      UNNEST(@"SEL$3")
      UNNEST(@"SEL$4")
      UNNEST(@"SEL$5")
      OUTLINE(@"SEL$6")
      OUTLINE(@"SEL$7")
      OUTLINE(@"SEL$9")
      OUTLINE(@"SEL$10")
      OUTLINE(@"SEL$1")
      OUTLINE(@"SEL$3")
      OUTLINE(@"SEL$4")
      OUTLINE(@"SEL$5")
      INDEX_RS_ASC(@"SEL$E86218C0" "DOC_ATTR"@"SEL$4" ("DOC_ATTR"."TEMPLATE_ID" "DOC_ATTR"."PARENT_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"
              "DOC_ATTR"."DOC_ID"))
      INDEX_RS_ASC(@"SEL$E86218C0" "R"@"SEL$1" ("DOC_RELATIONS"."DOC_ID" "DOC_RELATIONS"."RELATED_ID" "DOC_RELATIONS"."FLG_DEL" "DOC_RELATIONS"."RELATED_TYPE" "DOC_RELATIONS"."REL_TYPE"))
      INDEX(@"SEL$E86218C0" "DOC_TEMPLATES"@"SEL$3" ("DOC_TEMPLATES"."TEMPLATE_ID" "DOC_TEMPLATES"."DOC_ID" "DOC_TEMPLATES"."INSTANCE_ID"))
      INDEX_RS_ASC(@"SEL$E86218C0" "DOC_ATTR"@"SEL$5" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      LEADING(@"SEL$E86218C0" "DOC_ATTR"@"SEL$4" "R"@"SEL$1" "DOC_TEMPLATES"@"SEL$3" "DOC_ATTR"@"SEL$5")
      USE_NL(@"SEL$E86218C0" "R"@"SEL$1")
      USE_NL(@"SEL$E86218C0" "DOC_TEMPLATES"@"SEL$3")
      USE_NL(@"SEL$E86218C0" "DOC_ATTR"@"SEL$5")
      INDEX_RS_ASC(@"SEL$11" "DOC_MEMBERS"@"SEL$11" ("DOC_MEMBERS"."DOC_ID" "DOC_MEMBERS"."USER_ID" "DOC_MEMBERS"."INSTANCE_ID"))
      INDEX_RS_ASC(@"SEL$0EE6DB63" "ACMTT_ACL_MEMBERS"@"SEL$10" ("ACMTT_ACL_MEMBERS"."ACL_ID" "ACMTT_ACL_MEMBERS"."INSTANCE_ID" "ACMTT_ACL_MEMBERS"."OBJECT_ID" "ACMTT_ACL_MEMBERS"."OBJECT_TYPE"))
      INDEX_RS_ASC(@"SEL$68B588A0" "ACMTT_ACL_MEMBERS"@"SEL$7" ("ACMTT_ACL_MEMBERS"."ACL_ID" "ACMTT_ACL_MEMBERS"."INSTANCE_ID" "ACMTT_ACL_MEMBERS"."OBJECT_ID" "ACMTT_ACL_MEMBERS"."OBJECT_TYPE"))
      INDEX(@"SEL$2" "DA"@"SEL$2" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      INDEX(@"SEL$8" "GROUP_MEMBERS"@"SEL$8" ("GROUP_MEMBERS"."USER_ID" "GROUP_MEMBERS"."INSTANCE_ID" "GROUP_MEMBERS"."GROUP_ID"))
      END_OUTLINE_DATA
  */

Peeked Binds (identified by position):
--------------------------------------

   1 - (NUMBER): 3636688
   2 - (NUMBER): 7
   3 - (NUMBER): 29440
   4 - (NUMBER): 177
   5 - (NUMBER): 5179
   6 - (NUMBER, Primary=5)
   7 - (NUMBER, Primary=5)
   8 - (NUMBER): 15096
   9 - (NUMBER, Primary=8)
  10 - (NUMBER, Primary=4)
  11 - (NUMBER, Primary=4)
  12 - (NUMBER, Primary=8)
  13 - (NUMBER, Primary=4)
  14 - (NUMBER, Primary=8)
  15 - (NUMBER, Primary=4)

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("DOC_ID"=:B1 AND "TA_ID"=:B5)
   4 - filter(( IS NOT NULL OR  IS NOT NULL OR ("R"."ID_OWNER"=:B1 AND  IS NOT NULL)))
  11 - filter("INSTANCE_ID"=:B2)
  12 - access("TEMPLATE_ID"=:B6 AND "PARENT_ID"=23224 AND "CVALUE"='v pr??b??hu')
       filter("CVALUE"='v pr??b??hu')
  15 - filter(("R"."CHANGED">SYSDATE@!-:B4 AND INTERNAL_FUNCTION("R"."FLG") AND "INSTANCE_ID"=:B2 AND "INSTANCE_ID"="R"."INSTANCE_ID"))
  16 - access("R"."DOC_ID"=:B3 AND "DOC_ID"="R"."RELATED_ID" AND "FLG_DEL" IS NULL)
       filter(("REL_TYPE"<>'X' AND "R"."RELATED_TYPE"<>(-1)))
  17 - access("TEMPLATE_ID"=:B6 AND "DOC_ID"="R"."RELATED_ID" AND "INSTANCE_ID"=:B2)
       filter("INSTANCE_ID"="R"."INSTANCE_ID")
  18 - filter(("PARENT_ID"=23188 AND "TEMPLATE_ID"=:B6 AND "INSTANCE_ID"=:B2))
  19 - access("DOC_ID"="R"."RELATED_ID" AND "CVALUE"='storno')
       filter("CVALUE"='storno')
  20 - filter(("OBJECT_ID"=:B1 OR  IS NOT NULL))
  21 - filter(("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE '0__1%'))
  22 - access("ACL_ID"=:B1 AND "INSTANCE_ID"=:B2)
  23 - access("USER_ID"=:B1 AND "INSTANCE_ID"=:B2 AND "GROUP_ID"=:B1)
  24 - filter(("ACCESS_MASK" LIKE '1%' OR "ACCESS_MASK" LIKE '0__1%'))
  25 - access("DOC_ID"=:B1 AND "USER_ID"=:B1 AND "INSTANCE_ID"=:B2)
  26 - filter(("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE '0__1%'))
  27 - access("ACL_ID"=:B1 AND "INSTANCE_ID"=:B2 AND "OBJECT_TYPE"='O')
       filter("OBJECT_TYPE"='O')

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - (#keys=0) MIN(SUBSTR("DA"."CVALUE",-6)||"DA"."CVALUE")[4000]
   2 - "DA"."CVALUE"[VARCHAR2,4000]
   3 - (#keys=1) [4000], "R"."ID"[NUMBER,22]
   4 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22]
   5 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   6 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   7 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   8 - (#keys=2) "INSTANCE_ID"[NUMBER,22], "DOC_ID"[NUMBER,22]
   9 - "DOC_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22]
  10 - "DOC_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22]
  11 - "DOC_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22]
  12 - "DOC_ATTR".ROWID[ROWID,10], "DOC_ID"[NUMBER,22]
  13 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
  14 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
  15 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
  16 - "R".ROWID[ROWID,10], "R"."RELATED_ID"[NUMBER,22]
  19 - "DOC_ATTR".ROWID[ROWID,10]
  21 - "OBJECT_ID"[NUMBER,22]
  22 - "ACMTT_ACL_MEMBERS".ROWID[ROWID,10], "OBJECT_ID"[NUMBER,22]
  25 - "DOC_MEMBERS".ROWID[ROWID,10]
  27 - "ACMTT_ACL_MEMBERS".ROWID[ROWID,10]


PLAN_TABLE  phv:1957132478  format:ADVANCED

 SELECT /*+ gather_plan_statistics monitor bind_aware */
       /* sqlt_s29544 */
       R.ID AJDI,(SELECT MIN(SUBSTR(DA.CVALUE,-6)||DA.CVALUE) FROM DMS.DOC_ATTR DA WHERE DOC_ID=R.RELATED_ID AND TA_ID=:B5 ) VAL FROM DMS.DOC_RELATIONS R WHERE R.CHANGED>(SYSDATE-:B4 )
 AND R.DOC_ID=:B3 AND R.RELATED_TYPE<>-1 AND INSTANCE_ID=:B2 AND FLG_DEL IS NULL AND REL_TYPE<>'X' AND R.FLG IN ('P','K','A','E')
 AND EXISTS( SELECT DOC_ID FROM DMS.DOC_TEMPLATES WHERE DOC_ID=R.RELATED_ID AND INSTANCE_ID=R.INSTANCE_ID AND TEMPLATE_ID=:B6 )
 AND EXISTS ( SELECT 1 FROM DMS.DOC_ATTR WHERE DOC_ID=R.RELATED_ID AND INSTANCE_ID=R.INSTANCE_ID AND TEMPLATE_ID=:B6 AND CVALUE='v pr??b??hu' AND PARENT_ID=23224)
 AND NOT EXISTS ( SELECT 1 FROM DOC_ATTR WHERE DOC_ID=R.RELATED_ID AND INSTANCE_ID=R.INSTANCE_ID AND TEMPLATE_ID=:B6 AND CVALUE='storno' AND PARENT_ID=23188)
 AND ( EXISTS ( SELECT 1 FROM DMS.ACL_MEMBERS WHERE ( OBJECT_ID=:B1 OR EXISTS ( SELECT GROUP_ID FROM DMS.GROUP_MEMBERS WHERE USER_ID=:B1 AND GROUP_ID=OBJECT_ID AND INSTANCE_ID=:B2 ))
 AND INSTANCE_ID=:B2 AND ACL_ID=R.ID_ACL AND ( ACCESS_MASK LIKE '1%' OR ACCESS_MASK LIKE '0__1%' ))
 OR ( R.ID_OWNER=:B1 AND EXISTS( SELECT 1 FROM DMS.ACL_MEMBERS WHERE ACL_ID=R.ID_ACL AND INSTANCE_ID=:B2 AND (ACCESS_MASK LIKE '1%' OR ACCESS_MASK LIKE '0__1%' ) AND OBJECT_TYPE = 'O'))
 OR ( EXISTS( SELECT 1 FROM DMS.DOC_MEMBERS WHERE USER_ID=:B1 AND INSTANCE_ID=:B2 AND DOC_ID=R.RELATED_ID AND (ACCESS_MASK LIKE '1%' OR ACCESS_MASK LIKE '0__1%' )))) ORDER BY 2 DESC

Plan hash value: 1957132478

------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                | Name                          | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
------------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                         |                               |     1 |   158 |    32   (4)| 00:00:01 |       |       |
|   1 |  SORT AGGREGATE                          |                               |     1 |    39 |            |          |       |       |
|*  2 |   INDEX RANGE SCAN                       | PI_DATTR__DI_TA_3V            |     1 |    39 |     4   (0)| 00:00:01 |       |       |
|   3 |  SORT ORDER BY                           |                               |     1 |   158 |    32   (4)| 00:00:01 |       |       |
|*  4 |   FILTER                                 |                               |       |       |            |          |       |       |
|   5 |    NESTED LOOPS SEMI                     |                               |     1 |   158 |    30   (0)| 00:00:01 |       |       |
|   6 |     NESTED LOOPS ANTI                    |                               |     1 |   111 |    26   (0)| 00:00:01 |       |       |
|   7 |      NESTED LOOPS SEMI                   |                               |     1 |    64 |    22   (0)| 00:00:01 |       |       |
|   8 |       PARTITION RANGE SINGLE             |                               |     1 |    49 |    21   (0)| 00:00:01 |   KEY |   KEY |
|   9 |        PARTITION RANGE ALL               |                               |     1 |    49 |    21   (0)| 00:00:01 |     1 |    18 |
|* 10 |         TABLE ACCESS BY LOCAL INDEX ROWID| DOC_RELATIONS                 |     1 |    49 |    21   (0)| 00:00:01 |   KEY |   KEY |
|* 11 |          INDEX RANGE SCAN                | PI_DRELS__DI_RI_FD_2RT        |     2 |       |    19   (0)| 00:00:01 |   KEY |   KEY |
|* 12 |       INDEX UNIQUE SCAN                  | UQ_DOC_TEMPLATES__TID_DID_IID |  2012 | 30180 |     1   (0)| 00:00:01 |       |       |
|* 13 |      TABLE ACCESS BY GLOBAL INDEX ROWID  | DOC_ATTR                      |     1 |    47 |     4   (0)| 00:00:01 | ROWID | ROWID |
|* 14 |       INDEX RANGE SCAN                   | PI_DATTR__DI_TA_3V            |     1 |       |     3   (0)| 00:00:01 |       |       |
|* 15 |     TABLE ACCESS BY GLOBAL INDEX ROWID   | DOC_ATTR                      |     1 |    47 |     4   (0)| 00:00:01 | ROWID | ROWID |
|* 16 |      INDEX RANGE SCAN                    | PI_DATTR__DI_TA_3V            |     1 |       |     3   (0)| 00:00:01 |       |       |
|* 17 |    FILTER                                |                               |       |       |            |          |       |       |
|* 18 |     TABLE ACCESS BY INDEX ROWID          | ACMTT_ACL_MEMBERS             |     1 |    19 |     3   (0)| 00:00:01 |       |       |
|* 19 |      INDEX RANGE SCAN                    | I_ACL_MBRS__AI_II_OI_OT       |     1 |       |     2   (0)| 00:00:01 |       |       |
|* 20 |     INDEX UNIQUE SCAN                    | UQ_GR_MBRS__UI_II_GI          |     1 |    14 |     1   (0)| 00:00:01 |       |       |
|* 21 |    TABLE ACCESS BY INDEX ROWID           | DOC_MEMBERS                   |     1 |    47 |     1   (0)| 00:00:01 |       |       |
|* 22 |     INDEX RANGE SCAN                     | I_DOC_MBRS__DI_UI_II          |     1 |       |     1   (0)| 00:00:01 |       |       |
|* 23 |    TABLE ACCESS BY INDEX ROWID           | ACMTT_ACL_MEMBERS             |     1 |    17 |     3   (0)| 00:00:01 |       |       |
|* 24 |     INDEX RANGE SCAN                     | I_ACL_MBRS__AI_II_OI_OT       |     1 |       |     2   (0)| 00:00:01 |       |       |
------------------------------------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$2
   2 - SEL$2        / DA@SEL$2
   3 - SEL$E86218C0
  10 - SEL$E86218C0 / R@SEL$1
  11 - SEL$E86218C0 / R@SEL$1
  12 - SEL$E86218C0 / DOC_TEMPLATES@SEL$3
  13 - SEL$E86218C0 / DOC_ATTR@SEL$5
  14 - SEL$E86218C0 / DOC_ATTR@SEL$5
  15 - SEL$E86218C0 / DOC_ATTR@SEL$4
  16 - SEL$E86218C0 / DOC_ATTR@SEL$4
  17 - SEL$68B588A0
  18 - SEL$68B588A0 / ACMTT_ACL_MEMBERS@SEL$7
  19 - SEL$68B588A0 / ACMTT_ACL_MEMBERS@SEL$7
  20 - SEL$8        / GROUP_MEMBERS@SEL$8
  21 - SEL$11       / DOC_MEMBERS@SEL$11
  22 - SEL$11       / DOC_MEMBERS@SEL$11
  23 - SEL$0EE6DB63 / ACMTT_ACL_MEMBERS@SEL$10
  24 - SEL$0EE6DB63 / ACMTT_ACL_MEMBERS@SEL$10

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      INDEX(@"SEL$8" "GROUP_MEMBERS"@"SEL$8" ("GROUP_MEMBERS"."USER_ID" "GROUP_MEMBERS"."INSTANCE_ID" "GROUP_MEMBERS"."GROUP_ID"))
      INDEX(@"SEL$2" "DA"@"SEL$2" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID" "DOC_ATTR"."CVALUE"
              "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      INDEX_RS_ASC(@"SEL$68B588A0" "ACMTT_ACL_MEMBERS"@"SEL$7" ("ACMTT_ACL_MEMBERS"."ACL_ID" "ACMTT_ACL_MEMBERS"."INSTANCE_ID"
              "ACMTT_ACL_MEMBERS"."OBJECT_ID" "ACMTT_ACL_MEMBERS"."OBJECT_TYPE"))
      INDEX_RS_ASC(@"SEL$0EE6DB63" "ACMTT_ACL_MEMBERS"@"SEL$10" ("ACMTT_ACL_MEMBERS"."ACL_ID" "ACMTT_ACL_MEMBERS"."INSTANCE_ID"
              "ACMTT_ACL_MEMBERS"."OBJECT_ID" "ACMTT_ACL_MEMBERS"."OBJECT_TYPE"))
      INDEX_RS_ASC(@"SEL$11" "DOC_MEMBERS"@"SEL$11" ("DOC_MEMBERS"."DOC_ID" "DOC_MEMBERS"."USER_ID" "DOC_MEMBERS"."INSTANCE_ID"))
      USE_NL(@"SEL$E86218C0" "DOC_ATTR"@"SEL$4")
      USE_NL(@"SEL$E86218C0" "DOC_ATTR"@"SEL$5")
      USE_NL(@"SEL$E86218C0" "DOC_TEMPLATES"@"SEL$3")
      LEADING(@"SEL$E86218C0" "R"@"SEL$1" "DOC_TEMPLATES"@"SEL$3" "DOC_ATTR"@"SEL$5" "DOC_ATTR"@"SEL$4")
      INDEX_RS_ASC(@"SEL$E86218C0" "DOC_ATTR"@"SEL$4" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID"
              "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      INDEX_RS_ASC(@"SEL$E86218C0" "DOC_ATTR"@"SEL$5" ("DOC_ATTR"."DOC_ID" "DOC_ATTR"."TA_ID" "DOC_ATTR"."DOMAIN_ID"
              "DOC_ATTR"."CVALUE" "DOC_ATTR"."DVALUE" "DOC_ATTR"."NVALUE"))
      INDEX(@"SEL$E86218C0" "DOC_TEMPLATES"@"SEL$3" ("DOC_TEMPLATES"."TEMPLATE_ID" "DOC_TEMPLATES"."DOC_ID"
              "DOC_TEMPLATES"."INSTANCE_ID"))
      INDEX_RS_ASC(@"SEL$E86218C0" "R"@"SEL$1" ("DOC_RELATIONS"."DOC_ID" "DOC_RELATIONS"."RELATED_ID" "DOC_RELATIONS"."FLG_DEL"
              "DOC_RELATIONS"."RELATED_TYPE" "DOC_RELATIONS"."REL_TYPE"))
      OUTLINE(@"SEL$5")
      OUTLINE(@"SEL$4")
      OUTLINE(@"SEL$3")
      OUTLINE(@"SEL$1")
      OUTLINE(@"SEL$10")
      OUTLINE(@"SEL$9")
      OUTLINE(@"SEL$7")
      OUTLINE(@"SEL$6")
      UNNEST(@"SEL$5")
      UNNEST(@"SEL$4")
      UNNEST(@"SEL$3")
      OUTLINE_LEAF(@"SEL$E86218C0")
      OUTLINE_LEAF(@"SEL$11")
      MERGE(@"SEL$10")
      OUTLINE_LEAF(@"SEL$0EE6DB63")
      MERGE(@"SEL$7")
      OUTLINE_LEAF(@"SEL$68B588A0")
      OUTLINE_LEAF(@"SEL$8")
      OUTLINE_LEAF(@"SEL$2")
      ALL_ROWS
      DB_VERSION('11.2.0.3')
      OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
      IGNORE_OPTIM_EMBEDDED_HINTS
      END_OUTLINE_DATA
  */

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("DOC_ID"=:B1 AND "TA_ID"=TO_NUMBER(:B5))
   4 - filter( EXISTS (SELECT 0 FROM DMS."ACMTT_ACL_MEMBERS" "ACMTT_ACL_MEMBERS" WHERE ("OBJECT_ID"=TO_NUMBER(:B1) OR  EXISTS
              (SELECT 0 FROM "DMS"."GROUP_MEMBERS" "GROUP_MEMBERS" WHERE "GROUP_ID"=:B1 AND "INSTANCE_ID"=TO_NUMBER(:B2) AND
              "USER_ID"=TO_NUMBER(:B1))) AND "INSTANCE_ID"=TO_NUMBER(:B2) AND "ACL_ID"=:B2 AND ("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR
              "GETSECMASK"("ACCESS_MASK") LIKE '0__1%')) OR  EXISTS (SELECT 0 FROM "DMS"."DOC_MEMBERS" "DOC_MEMBERS" WHERE
              "INSTANCE_ID"=TO_NUMBER(:B2) AND "USER_ID"=TO_NUMBER(:B1) AND "DOC_ID"=:B3 AND ("ACCESS_MASK" LIKE '1%' OR "ACCESS_MASK" LIKE
              '0__1%')) OR "R"."ID_OWNER"=TO_NUMBER(:B1) AND  EXISTS (SELECT 0 FROM DMS."ACMTT_ACL_MEMBERS" "ACMTT_ACL_MEMBERS" WHERE
              "INSTANCE_ID"=TO_NUMBER(:B2) AND "ACL_ID"=:B4 AND ("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE
              '0__1%') AND "OBJECT_TYPE"='O'))
  10 - filter("R"."CHANGED">SYSDATE@!-:B4 AND "INSTANCE_ID"=TO_NUMBER(:B2) AND ("R"."FLG"='A' OR "R"."FLG"='E' OR "R"."FLG"='K'
              OR "R"."FLG"='P'))
  11 - access("R"."DOC_ID"=TO_NUMBER(:B3) AND "FLG_DEL" IS NULL)
       filter("REL_TYPE"<>'X' AND "FLG_DEL" IS NULL AND "R"."RELATED_TYPE"<>(-1))
  12 - access("TEMPLATE_ID"=TO_NUMBER(:B6) AND "DOC_ID"="R"."RELATED_ID" AND "INSTANCE_ID"=TO_NUMBER(:B2))
       filter("INSTANCE_ID"="R"."INSTANCE_ID")
  13 - filter("PARENT_ID"=23188 AND "TEMPLATE_ID"=TO_NUMBER(:B6) AND "INSTANCE_ID"=TO_NUMBER(:B2))
  14 - access("DOC_ID"="R"."RELATED_ID" AND "CVALUE"='storno')
       filter("CVALUE"='storno')
  15 - filter("PARENT_ID"=23224 AND "TEMPLATE_ID"=TO_NUMBER(:B6) AND "INSTANCE_ID"=TO_NUMBER(:B2) AND
              "INSTANCE_ID"="R"."INSTANCE_ID")
  16 - access("DOC_ID"="R"."RELATED_ID" AND "CVALUE"='v pr??b??hu')
       filter("CVALUE"='v pr??b??hu')
  17 - filter("OBJECT_ID"=TO_NUMBER(:B1) OR  EXISTS (SELECT 0 FROM "DMS"."GROUP_MEMBERS" "GROUP_MEMBERS" WHERE "GROUP_ID"=:B1 AND
              "INSTANCE_ID"=TO_NUMBER(:B2) AND "USER_ID"=TO_NUMBER(:B1)))
  18 - filter("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE '0__1%')
  19 - access("ACL_ID"=:B1 AND "INSTANCE_ID"=TO_NUMBER(:B2))
  20 - access("USER_ID"=TO_NUMBER(:B1) AND "INSTANCE_ID"=TO_NUMBER(:B2) AND "GROUP_ID"=:B1)
  21 - filter("ACCESS_MASK" LIKE '1%' OR "ACCESS_MASK" LIKE '0__1%')
  22 - access("DOC_ID"=:B1 AND "USER_ID"=TO_NUMBER(:B1) AND "INSTANCE_ID"=TO_NUMBER(:B2))
  23 - filter("GETSECMASK"("ACCESS_MASK") LIKE '1%' OR "GETSECMASK"("ACCESS_MASK") LIKE '0__1%')
  24 - access("ACL_ID"=:B1 AND "INSTANCE_ID"=TO_NUMBER(:B2) AND "OBJECT_TYPE"='O')
       filter("OBJECT_TYPE"='O')

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - (#keys=0) MIN(SUBSTR("DA"."CVALUE",-6)||"DA"."CVALUE")[4000]
   2 - "DA"."CVALUE"[VARCHAR2,4000]
   3 - (#keys=1)  (SELECT MIN(SUBSTR("DA"."CVALUE",-6)||"DA"."CVALUE") FROM "DMS"."DOC_ATTR" "DA" WHERE "TA_ID"=TO_NUMBER(:B5)
       AND "DOC_ID"=:B1)[4000], "R"."ID"[NUMBER,22]
   4 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22]
   5 - (#keys=0) "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22], "R"."ID_ACL"[NUMBER,22]
   6 - (#keys=0) "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22],
       "R"."ID_ACL"[NUMBER,22]
   7 - (#keys=0) "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22],
       "R"."ID_ACL"[NUMBER,22]
   8 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22],
       "R"."ID_ACL"[NUMBER,22]
   9 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22],
       "R"."ID_ACL"[NUMBER,22]
  10 - "R"."ID"[NUMBER,22], "R"."RELATED_ID"[NUMBER,22], "INSTANCE_ID"[NUMBER,22], "R"."ID_OWNER"[NUMBER,22],
       "R"."ID_ACL"[NUMBER,22]
  11 - "R".ROWID[ROWID,10], "R"."RELATED_ID"[NUMBER,22]
  14 - "DOC_ATTR".ROWID[ROWID,10]
  16 - "DOC_ATTR".ROWID[ROWID,10]
  18 - "OBJECT_ID"[NUMBER,22]
  19 - "ACMTT_ACL_MEMBERS".ROWID[ROWID,10], "OBJECT_ID"[NUMBER,22]
  22 - "DOC_MEMBERS".ROWID[ROWID,10]
  24 - "ACMTT_ACL_MEMBERS".ROWID[ROWID,10]


Tables

                                                                                                                               Avg                    Stat
                                                  Num    Sample                           Segment Segment          Empty   Avg Row Chain Global User  Type   Stale
Table Name        Owner Part Temp     Count      Rows      Size  Perc Last Analyzed       Extents  Blocks  Blocks Blocks Space Len   Cnt Stats  Stats Locked Stats
----------------- ----- ---- ---- --------- --------- --------- ----- ------------------- ------- ------- ------- ------ ----- --- ----- ------ ----- ------ -----
ACMTT_ACL_MEMBERS DMS   NO   N        14100     14079     14079 100.0 2013-07-26/14:15:03       7      32      32      0     0  21     0 YES    NO           NO
DOC_ATTR          DMS   YES  N    323900000 317078196 317078196 100.0 2013-07-25/19:46:33                 2416604 176117  1799 102     0 YES    NO           NO
DOC_MEMBERS       DMS   NO   N            0         0         0       2013-07-25/17:01:38       2      12       0      0     0   0     0 YES    NO           NO
DOC_RELATIONS     DMS   YES  N     16590000  17181186  17181186 100.0 2013-07-25/17:27:03                  169732 187176  2643  99     0 YES    NO           NO
DOC_TEMPLATES     DMS   NO   N     18920000  19609772  19609772 100.0 2013-07-25/17:03:04     130   30720   30712      0     0  17     0 YES    NO           NO
GROUP_MEMBERS     DMS   NO   N        34140     33911     33911 100.0 2013-07-25/17:01:49      12      52      51      0     0  15     0 YES    NO           NO

Table Columns

                                                                                Fluctuatin                                                                                                                                               Avg                                        Fluctuatin
                               Col       Num       Num    Sample            Num NDV                                                                                                                                                      Col                    Num                 Endpoint   Global User
Table Name        Column Name   ID      Rows     Nulls      Size  Perc Distinct Count      Low Value                                                                                          High Value             Last Analyzed       Len        Density Buckets Histogram       Count      Stats  Stats
----------------- ------------ --- --------- --------- --------- ----- -------- ---------- -------------------------------------------------------------------------------------------------- ---------------------- ------------------- --- -------------- ------- --------------- ---------- ------ -----
ACMTT_ACL_MEMBERS ACCESS_MASK    4     14079         0     14079 100.0       13 FALSE      "000000"                                                                                           "111111"               2013-07-26/14:15:03   7   7.692308e-02       1 NONE            FALSE      YES    NO
ACMTT_ACL_MEMBERS ACL_ID         1     14079         0     14079 100.0     1827 FALSE      "-36"                                                                                              "5010"                 2013-07-26/14:15:03   4   1.251319e-03     254 HEIGHT BALANCED FALSE      YES    NO
ACMTT_ACL_MEMBERS INSTANCE_ID    5     14079         0     14079 100.0       29 FALSE      "0"                                                                                                "597"                  2013-07-26/14:15:03   4   3.551389e-05      29 FREQUENCY       FALSE      YES    NO
ACMTT_ACL_MEMBERS OBJECT_ID      3     14079      1360     12719 100.0     1773 FALSE      "-23"                                                                                              "17976"                2013-07-26/14:15:03   4   1.157510e-03     254 HEIGHT BALANCED FALSE      YES    NO
ACMTT_ACL_MEMBERS OBJECT_TYPE    2     14079         0     14079 100.0        3 FALSE      "G"                                                                                                "U"                    2013-07-26/14:15:03   2   3.551389e-05       3 FREQUENCY       FALSE      YES    NO
ACMTT_ACL_MEMBERS ROLE           6     14079     14079           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-26/14:15:03   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_ATTR          CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_ATTR          DOMAIN_ID      4 317078196         0 317078405 100.0     7572 FALSE      "-16002"                                                                                           "70669"                2013-07-25/19:46:33   5   1.228481e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          DVALUE         6 317078196 270459645  46618596 100.0 12944853 FALSE      " 0001/01/31 00:00:00"                                                                             " 2030/04/07 11:21:02" 2013-07-25/19:46:33   3   1.170646e-05     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          INSTANCE_ID    8 317078196         0 317078405 100.0       29 FALSE      "0"                                                                                                "597"                  2013-07-25/19:46:33   4   1.576897e-09      29 FREQUENCY       FALSE      YES    NO
DOC_ATTR          NVALUE         7 317078196 309833463   7244742 100.0    96589 TRUE       "-1302"                                                                                            "26119134010"          2013-07-25/19:46:33   2   7.320047e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PARENT_ID      3 317078196         0 317078198 100.0     1838 FALSE      "-16000"                                                                                           "70354"                2013-07-25/19:46:33   5   1.267479e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          TA_ID          9 317078196         0 317078405 100.0     9973 FALSE      "1001"                                                                                             "3645182"              2013-07-25/19:46:33   6   1.121297e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          TEMPLATE_ID    2 317078196         0 317078198 100.0      333 FALSE      "-1120"                                                                                            "8368"                 2013-07-25/19:46:33   5   1.951303e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_MEMBERS       ACCESS_MASK    3         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_MEMBERS       DOC_ID         1         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_MEMBERS       INSTANCE_ID    4         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_MEMBERS       USER_ID        2         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_RELATIONS     CAPTION       15  17181186      7769  17173417 100.0  9151330 FALSE      "
















" "urady a instituce" 2013-07-25/17:27:03 35 3.057750e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS CHANGED 14 17181186 6869 17174316 100.0 9885481 FALSE " 2009/11/04 15:03:28" " 2013/07/25 17:24:35" 2013-07-25/17:27:03 8 1.011585e-07 1 NONE FALSE YES NO DOC_RELATIONS DOC_ID 2 17181186 0 17181185 100.0 8513862 FALSE "0" "61543009" 2013-07-25/17:27:03 6 2.647872e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS FLG 17 17181186 248871 16932314 100.0 4 FALSE "E" "T" 2013-07-25/17:27:03 2 2.952934e-08 4 FREQUENCY FALSE YES NO DOC_RELATIONS FLG_DEL 7 17181186 17177247 3939 100.0 2 FALSE "O" "o" 2013-07-25/17:27:03 2 1.269358e-04 2 FREQUENCY FALSE YES NO DOC_RELATIONS ID 1 17181186 0 17181186 100.0 17181186 FALSE "10002" "61543015" 2013-07-25/17:27:03 6 5.820320e-08 1 NONE FALSE YES NO DOC_RELATIONS ID_ACL 13 17181186 6869 17174316 100.0 479 FALSE "-27" "5010" 2013-07-25/17:27:03 4 3.287619e-03 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS ID_AREA 16 17181186 6869 17174316 100.0 10 FALSE "0" "7000" 2013-07-25/17:27:03 3 2.911324e-08 10 FREQUENCY TRUE YES NO DOC_RELATIONS ID_OWNER 12 17181186 6869 17174316 100.0 1687 FALSE "1" "17978" 2013-07-25/17:27:03 5 2.016500e-03 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS INSTANCE_ID 5 17181186 0 17181185 100.0 29 FALSE "0" "597" 2013-07-25/17:27:03 4 2.910160e-08 29 FREQUENCY FALSE YES NO DOC_RELATIONS RELATED_ID 3 17181186 0 17181185 100.0 16002454 FALSE "8" "61543014" 2013-07-25/17:27:03 6 6.249042e-08 1 NONE FALSE YES NO DOC_RELATIONS RELATED_TYPE 9 17181186 0 17181185 100.0 62 FALSE "-666" "501" 2013-07-25/17:27:03 4 2.910160e-08 62 FREQUENCY FALSE YES NO DOC_RELATIONS REL_TYPE 8 17181186 0 17181185 100.0 6 FALSE "B" "X" 2013-07-25/17:27:03 2 2.910160e-08 6 FREQUENCY FALSE YES NO DOC_TEMPLATES DOC_ID 1 19609772 1 19609771 100.0 14863305 FALSE "3" "61542965" 2013-07-25/17:03:04 6 6.727979e-08 1 NONE FALSE YES NO DOC_TEMPLATES INSTANCE_ID 4 19609772 0 19609772 100.0 29 FALSE "0" "597" 2013-07-25/17:03:04 4 2.549749e-08 29 FREQUENCY FALSE YES NO DOC_TEMPLATES TEMPLATE_ID 2 19609772 0 19609772 100.0 336 FALSE "-1120" "8368" 2013-07-25/17:03:04 5 2.091483e-03 254 HEIGHT BALANCED FALSE YES NO GROUP_MEMBERS FLG_INDIRECT 4 33911 16306 17605 100.0 1 FALSE "Y" "Y" 2013-07-25/17:01:49 2 1.000000e+00 1 NONE FALSE YES NO GROUP_MEMBERS GROUP_ID 1 33911 0 33911 100.0 1764 FALSE "-50" "17985" 2013-07-25/17:01:49 5 1.004860e-03 254 HEIGHT BALANCED FALSE YES NO GROUP_MEMBERS INSTANCE_ID 3 33911 0 33911 100.0 29 FALSE "0" "597" 2013-07-25/17:01:49 4 1.474448e-05 29 FREQUENCY FALSE YES NO GROUP_MEMBERS USER_ID 2 33911 0 33911 100.0 4610 FALSE "1" "18039" 2013-07-25/17:01:49 5 3.382573e-04 254 HEIGHT BALANCED FALSE YES NO

Indexes

                                                                                                                                                                  Avg    Avg
                                                                                                                                                                 Leaf   Data
                                                                                                                                                               Blocks Blocks                         Stat
                                                       Index                  Num    Sample                            Distinct        Segment Segment    Leaf    per    per Clustering Global User  Type   Stale
Table Name        Index Name                     Owner Type   Part Temp      Rows      Size  Perc Last Analyzed            Keys BLevel Extents  Blocks  Blocks    Key    Key     Factor Stats  Stats Locked Stats
----------------- ------------------------------ ----- ------ ---- ---- --------- --------- ----- ------------------- --------- ------ ------- ------- ------- ------ ------ ---------- ------ ----- ------ -----
ACMTT_ACL_MEMBERS I_ACL_MBRS__AI_II_OI_OT        DMS   NORMAL NO   N        14079     14079 100.0 2013-07-26/14:15:05     14079      1       6      28      23      1      1       4550 YES    NO           NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__RL_OT_OI_II        DMS   NORMAL NO   N        14079     14079 100.0 2013-07-26/14:15:04      2278      1       6      28      22      1      1       4150 YES    NO           NO
DOC_ATTR          PI_DATTR__DI_TA_3V             DMS   NORMAL NO   N    317078788 317078788 100.0 2013-07-25/19:52:52 317078671      3     573 1540864 1529239      1      1   14406569 YES    NO           NO
DOC_ATTR          PI_DATTR__DM_3V_DI             DMS   NORMAL YES  N    317078788 317078788 100.0 2013-07-25/20:03:18 312079751      3                 1309818      1      1  197437584 YES    NO           NO
DOC_ATTR          PI_DATTR__FCV_TI_DI            DMS   NORMAL YES  N    317079807 317079807 100.0 2013-07-25/20:13:21 317077378      3                 1247510      1      1  189367618 YES    NO           NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI          DMS   NORMAL YES  N    317081842 317081842 100.0 2013-07-25/20:38:26 313706197      3                 1425049      1      1  198289609 YES    NO           NO
DOC_ATTR          PI_DATTR__TA_3V_DI             DMS   NORMAL YES  N    317081865 317081865 100.0 2013-07-25/20:49:52 317081748      3                 1327845      1      1  197752160 YES    NO           NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V       DMS   NORMAL YES  N    317079807 317079807 100.0 2013-07-25/20:26:22 317079690      3                 1672200      1      1  198017865 YES    NO           NO
DOC_MEMBERS       I_DOC_MBRS__DI_UI_II           DMS   NORMAL NO   N            0         0       2013-07-25/17:01:39         0      0       2      12       0      0      0          0 YES    NO           NO
DOC_RELATIONS     I_DRELS__CA_DI_2F_AR_AI_OI     DMS   NORMAL NO   N     17181185  17181185 100.0 2013-07-25/17:27:33  15646432      2     204   90112   86912      1      1   14847418 YES    NO           NO
DOC_RELATIONS     I_DRELS__CH_DI_ID_II           DMS   NORMAL NO   N     17181185  17181185 100.0 2013-07-25/17:27:10  17181185      2     174   53248   52221      1      1   11202487 YES    NO           NO
DOC_RELATIONS     PI_DRELS__CH_CA_DI_2F_AR_AI_OI DMS   NORMAL YES  N     17181185  17181185 100.0 2013-07-25/17:28:17  16695251      2                  115342      1      1    8183787 YES    NO           NO
DOC_RELATIONS     PI_DRELS__DI_RI_FD_2RT         DMS   NORMAL YES  N     17181199  17181199 100.0 2013-07-25/17:28:38  17177409      1                   38030      1      1    9580663 YES    NO           NO
DOC_RELATIONS     PI_DRELS__FD_RI                DMS   NORMAL YES  N     17181202  17181202 100.0 2013-07-25/17:28:52  16002477      1                   24489      1      1    9623903 YES    NO           NO
DOC_RELATIONS     PI_DRELS__RI_2RT_FD            DMS   NORMAL YES  N     17181209  17181209 100.0 2013-07-25/17:29:30  17045933      1                   32033      1      1    9630832 YES    NO           NO
DOC_RELATIONS     PI_DRELS__RT_RT                DMS   NORMAL YES  N     17181209  17181209 100.0 2013-07-25/17:29:57       135      1                   21473    159   1796     242579 YES    NO           NO
DOC_RELATIONS     PPK_DRELS__ID_II               DMS   NORMAL NO   N     17181209  17181209 100.0 2013-07-25/17:30:07  17181209      2     135   33280   32475      1      1   11607048 YES    NO           NO
DOC_TEMPLATES     UQ_DOC_TEMPLATES__DID_TID_IID  DMS   NORMAL NO   N     19609772  19609772 100.0 2013-07-25/17:03:08  19609772      2     141   36160   35503      1      1    7035648 YES    NO           NO
DOC_TEMPLATES     UQ_DOC_TEMPLATES__TID_DID_IID  DMS   NORMAL NO   N     19609772  19609772 100.0 2013-07-25/17:03:12  19609772      2     139   35328   34700      1      1    6469524 YES    NO           NO
GROUP_MEMBERS     I_GR_MBRS__GI_II_UI_FL         DMS   NORMAL NO   N        33911     33911 100.0 2013-07-25/17:01:50     33911      1      16     128      61      1      1      12882 YES    NO           NO
GROUP_MEMBERS     UQ_GR_MBRS__UI_II_GI           DMS   NORMAL NO   N        33911     33911 100.0 2013-07-25/17:01:50     33911      1      15      64      54      1      1       9105 YES    NO           NO

Index Columns

                                                                                                                   Fluctuatin                                                                                                                                               Avg                                        Fluctuatin
                                                 Col              Col       Num       Num    Sample            Num NDV                                                                                                                                                      Col                    Num                 Endpoint   Global User
Table Name        Index Name                     Pos Column Name   ID      Rows     Nulls      Size  Perc Distinct Count      Low Value                                                                                          High Value             Last Analyzed       Len        Density Buckets Histogram       Count      Stats  Stats
----------------- ------------------------------ --- ------------ --- --------- --------- --------- ----- -------- ---------- -------------------------------------------------------------------------------------------------- ---------------------- ------------------- --- -------------- ------- --------------- ---------- ------ -----
ACMTT_ACL_MEMBERS I_ACL_MBRS__AI_II_OI_OT          1 ACL_ID         1     14079         0     14079 100.0     1827 FALSE      "-36"                                                                                              "5010"                 2013-07-26/14:15:03   4   1.251319e-03     254 HEIGHT BALANCED FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__AI_II_OI_OT          2 INSTANCE_ID    5     14079         0     14079 100.0       29 FALSE      "0"                                                                                                "597"                  2013-07-26/14:15:03   4   3.551389e-05      29 FREQUENCY       FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__AI_II_OI_OT          3 OBJECT_ID      3     14079      1360     12719 100.0     1773 FALSE      "-23"                                                                                              "17976"                2013-07-26/14:15:03   4   1.157510e-03     254 HEIGHT BALANCED FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__AI_II_OI_OT          4 OBJECT_TYPE    2     14079         0     14079 100.0        3 FALSE      "G"                                                                                                "U"                    2013-07-26/14:15:03   2   3.551389e-05       3 FREQUENCY       FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__RL_OT_OI_II          1 ROLE           6     14079     14079           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-26/14:15:03   0   0.000000e+00       0 NONE            FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__RL_OT_OI_II          2 OBJECT_TYPE    2     14079         0     14079 100.0        3 FALSE      "G"                                                                                                "U"                    2013-07-26/14:15:03   2   3.551389e-05       3 FREQUENCY       FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__RL_OT_OI_II          3 OBJECT_ID      3     14079      1360     12719 100.0     1773 FALSE      "-23"                                                                                              "17976"                2013-07-26/14:15:03   4   1.157510e-03     254 HEIGHT BALANCED FALSE      YES    NO
ACMTT_ACL_MEMBERS I_ACL_MBRS__RL_OT_OI_II          4 INSTANCE_ID    5     14079         0     14079 100.0       29 FALSE      "0"                                                                                                "597"                  2013-07-26/14:15:03   4   3.551389e-05      29 FREQUENCY       FALSE      YES    NO
DOC_ATTR          PI_DATTR__DI_TA_3V               1 DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_ATTR          PI_DATTR__DI_TA_3V               2 TA_ID          9 317078196         0 317078405 100.0     9973 FALSE      "1001"                                                                                             "3645182"              2013-07-25/19:46:33   6   1.121297e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DI_TA_3V               3 DOMAIN_ID      4 317078196         0 317078405 100.0     7572 FALSE      "-16002"                                                                                           "70669"                2013-07-25/19:46:33   5   1.228481e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DI_TA_3V               4 CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DI_TA_3V               5 DVALUE         6 317078196 270459645  46618596 100.0 12944853 FALSE      " 0001/01/31 00:00:00"                                                                             " 2030/04/07 11:21:02" 2013-07-25/19:46:33   3   1.170646e-05     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DI_TA_3V               6 NVALUE         7 317078196 309833463   7244742 100.0    96589 TRUE       "-1302"                                                                                            "26119134010"          2013-07-25/19:46:33   2   7.320047e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DM_3V_DI               1 DOMAIN_ID      4 317078196         0 317078405 100.0     7572 FALSE      "-16002"                                                                                           "70669"                2013-07-25/19:46:33   5   1.228481e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DM_3V_DI               2 CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DM_3V_DI               3 DVALUE         6 317078196 270459645  46618596 100.0 12944853 FALSE      " 0001/01/31 00:00:00"                                                                             " 2030/04/07 11:21:02" 2013-07-25/19:46:33   3   1.170646e-05     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DM_3V_DI               4 NVALUE         7 317078196 309833463   7244742 100.0    96589 TRUE       "-1302"                                                                                            "26119134010"          2013-07-25/19:46:33   2   7.320047e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__DM_3V_DI               5 DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_ATTR          PI_DATTR__FCV_TI_DI              1 CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__FCV_TI_DI              2 TA_ID          9 317078196         0 317078405 100.0     9973 FALSE      "1001"                                                                                             "3645182"              2013-07-25/19:46:33   6   1.121297e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__FCV_TI_DI              3 DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI            1 PARENT_ID      3 317078196         0 317078198 100.0     1838 FALSE      "-16000"                                                                                           "70354"                2013-07-25/19:46:33   5   1.267479e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI            2 DOMAIN_ID      4 317078196         0 317078405 100.0     7572 FALSE      "-16002"                                                                                           "70669"                2013-07-25/19:46:33   5   1.228481e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI            3 CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI            4 DVALUE         6 317078196 270459645  46618596 100.0 12944853 FALSE      " 0001/01/31 00:00:00"                                                                             " 2030/04/07 11:21:02" 2013-07-25/19:46:33   3   1.170646e-05     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI            5 NVALUE         7 317078196 309833463   7244742 100.0    96589 TRUE       "-1302"                                                                                            "26119134010"          2013-07-25/19:46:33   2   7.320047e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__PI_DM_3V_DI            6 DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_ATTR          PI_DATTR__TA_3V_DI               1 TA_ID          9 317078196         0 317078405 100.0     9973 FALSE      "1001"                                                                                             "3645182"              2013-07-25/19:46:33   6   1.121297e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TA_3V_DI               2 CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TA_3V_DI               3 DVALUE         6 317078196 270459645  46618596 100.0 12944853 FALSE      " 0001/01/31 00:00:00"                                                                             " 2030/04/07 11:21:02" 2013-07-25/19:46:33   3   1.170646e-05     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TA_3V_DI               4 NVALUE         7 317078196 309833463   7244742 100.0    96589 TRUE       "-1302"                                                                                            "26119134010"          2013-07-25/19:46:33   2   7.320047e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TA_3V_DI               5 DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         1 TEMPLATE_ID    2 317078196         0 317078198 100.0      333 FALSE      "-1120"                                                                                            "8368"                 2013-07-25/19:46:33   5   1.951303e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         2 PARENT_ID      3 317078196         0 317078198 100.0     1838 FALSE      "-16000"                                                                                           "70354"                2013-07-25/19:46:33   5   1.267479e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         3 DOMAIN_ID      4 317078196         0 317078405 100.0     7572 FALSE      "-16002"                                                                                           "70669"                2013-07-25/19:46:33   5   1.228481e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         4 TA_ID          9 317078196         0 317078405 100.0     9973 FALSE      "1001"                                                                                             "3645182"              2013-07-25/19:46:33   6   1.121297e-03     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         5 CVALUE         5 317078196  60403704 256674492 100.0 18409878 FALSE      "	PD-30007/2011-702-06000/705"                                                                     "yvzva "               2013-07-25/19:46:33  27   4.534163e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         6 DVALUE         6 317078196 270459645  46618596 100.0 12944853 FALSE      " 0001/01/31 00:00:00"                                                                             " 2030/04/07 11:21:02" 2013-07-25/19:46:33   3   1.170646e-05     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         7 NVALUE         7 317078196 309833463   7244742 100.0    96589 TRUE       "-1302"                                                                                            "26119134010"          2013-07-25/19:46:33   2   7.320047e-04     254 HEIGHT BALANCED FALSE      YES    NO
DOC_ATTR          PI_DATTR__TI_PI_DM_TA_3V         8 DOC_ID         1 317078196         0 317078198 100.0 12162987 FALSE      "19"                                                                                               "61543105"             2013-07-25/19:46:33   6   8.221665e-08       1 NONE            FALSE      YES    NO
DOC_MEMBERS       I_DOC_MBRS__DI_UI_II             1 DOC_ID         1         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_MEMBERS       I_DOC_MBRS__DI_UI_II             2 USER_ID        2         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_MEMBERS       I_DOC_MBRS__DI_UI_II             3 INSTANCE_ID    4         0         0           100.0        0 FALSE      ""                                                                                                 ""                     2013-07-25/17:01:38   0   0.000000e+00       0 NONE            FALSE      YES    NO
DOC_RELATIONS     I_DRELS__CA_DI_2F_AR_AI_OI       1 CAPTION       15  17181186      7769  17173417 100.0  9151330 FALSE      "
















" "urady a instituce" 2013-07-25/17:27:03 35 3.057750e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS I_DRELS__CA_DI_2F_AR_AI_OI 2 DOC_ID 2 17181186 0 17181185 100.0 8513862 FALSE "0" "61543009" 2013-07-25/17:27:03 6 2.647872e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS I_DRELS__CA_DI_2F_AR_AI_OI 3 FLG_DEL 7 17181186 17177247 3939 100.0 2 FALSE "O" "o" 2013-07-25/17:27:03 2 1.269358e-04 2 FREQUENCY FALSE YES NO DOC_RELATIONS I_DRELS__CA_DI_2F_AR_AI_OI 4 FLG 17 17181186 248871 16932314 100.0 4 FALSE "E" "T" 2013-07-25/17:27:03 2 2.952934e-08 4 FREQUENCY FALSE YES NO DOC_RELATIONS I_DRELS__CA_DI_2F_AR_AI_OI 5 ID_AREA 16 17181186 6869 17174316 100.0 10 FALSE "0" "7000" 2013-07-25/17:27:03 3 2.911324e-08 10 FREQUENCY TRUE YES NO DOC_RELATIONS I_DRELS__CA_DI_2F_AR_AI_OI 6 ID_ACL 13 17181186 6869 17174316 100.0 479 FALSE "-27" "5010" 2013-07-25/17:27:03 4 3.287619e-03 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS I_DRELS__CA_DI_2F_AR_AI_OI 7 ID_OWNER 12 17181186 6869 17174316 100.0 1687 FALSE "1" "17978" 2013-07-25/17:27:03 5 2.016500e-03 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS I_DRELS__CH_DI_ID_II 1 CHANGED 14 17181186 6869 17174316 100.0 9885481 FALSE " 2009/11/04 15:03:28" " 2013/07/25 17:24:35" 2013-07-25/17:27:03 8 1.011585e-07 1 NONE FALSE YES NO DOC_RELATIONS I_DRELS__CH_DI_ID_II 2 DOC_ID 2 17181186 0 17181185 100.0 8513862 FALSE "0" "61543009" 2013-07-25/17:27:03 6 2.647872e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS I_DRELS__CH_DI_ID_II 3 ID 1 17181186 0 17181186 100.0 17181186 FALSE "10002" "61543015" 2013-07-25/17:27:03 6 5.820320e-08 1 NONE FALSE YES NO DOC_RELATIONS I_DRELS__CH_DI_ID_II 4 INSTANCE_ID 5 17181186 0 17181185 100.0 29 FALSE "0" "597" 2013-07-25/17:27:03 4 2.910160e-08 29 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 1 CHANGED 14 17181186 6869 17174316 100.0 9885481 FALSE " 2009/11/04 15:03:28" " 2013/07/25 17:24:35" 2013-07-25/17:27:03 8 1.011585e-07 1 NONE FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 2 CAPTION 15 17181186 7769 17173417 100.0 9151330 FALSE "















" "urady a instituce" 2013-07-25/17:27:03 35 3.057750e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 3 DOC_ID 2 17181186 0 17181185 100.0 8513862 FALSE "0" "61543009" 2013-07-25/17:27:03 6 2.647872e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 4 FLG_DEL 7 17181186 17177247 3939 100.0 2 FALSE "O" "o" 2013-07-25/17:27:03 2 1.269358e-04 2 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 5 FLG 17 17181186 248871 16932314 100.0 4 FALSE "E" "T" 2013-07-25/17:27:03 2 2.952934e-08 4 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 6 ID_AREA 16 17181186 6869 17174316 100.0 10 FALSE "0" "7000" 2013-07-25/17:27:03 3 2.911324e-08 10 FREQUENCY TRUE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 7 ID_ACL 13 17181186 6869 17174316 100.0 479 FALSE "-27" "5010" 2013-07-25/17:27:03 4 3.287619e-03 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS PI_DRELS__CH_CA_DI_2F_AR_AI_OI 8 ID_OWNER 12 17181186 6869 17174316 100.0 1687 FALSE "1" "17978" 2013-07-25/17:27:03 5 2.016500e-03 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS PI_DRELS__DI_RI_FD_2RT 1 DOC_ID 2 17181186 0 17181185 100.0 8513862 FALSE "0" "61543009" 2013-07-25/17:27:03 6 2.647872e-04 254 HEIGHT BALANCED FALSE YES NO DOC_RELATIONS PI_DRELS__DI_RI_FD_2RT 2 RELATED_ID 3 17181186 0 17181185 100.0 16002454 FALSE "8" "61543014" 2013-07-25/17:27:03 6 6.249042e-08 1 NONE FALSE YES NO DOC_RELATIONS PI_DRELS__DI_RI_FD_2RT 3 FLG_DEL 7 17181186 17177247 3939 100.0 2 FALSE "O" "o" 2013-07-25/17:27:03 2 1.269358e-04 2 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__DI_RI_FD_2RT 4 RELATED_TYPE 9 17181186 0 17181185 100.0 62 FALSE "-666" "501" 2013-07-25/17:27:03 4 2.910160e-08 62 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__DI_RI_FD_2RT 5 REL_TYPE 8 17181186 0 17181185 100.0 6 FALSE "B" "X" 2013-07-25/17:27:03 2 2.910160e-08 6 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__FD_RI 1 FLG_DEL 7 17181186 17177247 3939 100.0 2 FALSE "O" "o" 2013-07-25/17:27:03 2 1.269358e-04 2 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__FD_RI 2 RELATED_ID 3 17181186 0 17181185 100.0 16002454 FALSE "8" "61543014" 2013-07-25/17:27:03 6 6.249042e-08 1 NONE FALSE YES NO DOC_RELATIONS PI_DRELS__RI_2RT_FD 1 RELATED_ID 3 17181186 0 17181185 100.0 16002454 FALSE "8" "61543014" 2013-07-25/17:27:03 6 6.249042e-08 1 NONE FALSE YES NO DOC_RELATIONS PI_DRELS__RI_2RT_FD 2 RELATED_TYPE 9 17181186 0 17181185 100.0 62 FALSE "-666" "501" 2013-07-25/17:27:03 4 2.910160e-08 62 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__RI_2RT_FD 3 REL_TYPE 8 17181186 0 17181185 100.0 6 FALSE "B" "X" 2013-07-25/17:27:03 2 2.910160e-08 6 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__RI_2RT_FD 4 FLG_DEL 7 17181186 17177247 3939 100.0 2 FALSE "O" "o" 2013-07-25/17:27:03 2 1.269358e-04 2 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__RT_RT 1 REL_TYPE 8 17181186 0 17181185 100.0 6 FALSE "B" "X" 2013-07-25/17:27:03 2 2.910160e-08 6 FREQUENCY FALSE YES NO DOC_RELATIONS PI_DRELS__RT_RT 2 RELATED_TYPE 9 17181186 0 17181185 100.0 62 FALSE "-666" "501" 2013-07-25/17:27:03 4 2.910160e-08 62 FREQUENCY FALSE YES NO DOC_RELATIONS PPK_DRELS__ID_II 1 ID 1 17181186 0 17181186 100.0 17181186 FALSE "10002" "61543015" 2013-07-25/17:27:03 6 5.820320e-08 1 NONE FALSE YES NO DOC_RELATIONS PPK_DRELS__ID_II 2 INSTANCE_ID 5 17181186 0 17181185 100.0 29 FALSE "0" "597" 2013-07-25/17:27:03 4 2.910160e-08 29 FREQUENCY FALSE YES NO DOC_TEMPLATES UQ_DOC_TEMPLATES__DID_TID_IID 1 DOC_ID 1 19609772 1 19609771 100.0 14863305 FALSE "3" "61542965" 2013-07-25/17:03:04 6 6.727979e-08 1 NONE FALSE YES NO DOC_TEMPLATES UQ_DOC_TEMPLATES__DID_TID_IID 2 TEMPLATE_ID 2 19609772 0 19609772 100.0 336 FALSE "-1120" "8368" 2013-07-25/17:03:04 5 2.091483e-03 254 HEIGHT BALANCED FALSE YES NO DOC_TEMPLATES UQ_DOC_TEMPLATES__DID_TID_IID 3 INSTANCE_ID 4 19609772 0 19609772 100.0 29 FALSE "0" "597" 2013-07-25/17:03:04 4 2.549749e-08 29 FREQUENCY FALSE YES NO DOC_TEMPLATES UQ_DOC_TEMPLATES__TID_DID_IID 1 TEMPLATE_ID 2 19609772 0 19609772 100.0 336 FALSE "-1120" "8368" 2013-07-25/17:03:04 5 2.091483e-03 254 HEIGHT BALANCED FALSE YES NO DOC_TEMPLATES UQ_DOC_TEMPLATES__TID_DID_IID 2 DOC_ID 1 19609772 1 19609771 100.0 14863305 FALSE "3" "61542965" 2013-07-25/17:03:04 6 6.727979e-08 1 NONE FALSE YES NO DOC_TEMPLATES UQ_DOC_TEMPLATES__TID_DID_IID 3 INSTANCE_ID 4 19609772 0 19609772 100.0 29 FALSE "0" "597" 2013-07-25/17:03:04 4 2.549749e-08 29 FREQUENCY FALSE YES NO GROUP_MEMBERS I_GR_MBRS__GI_II_UI_FL 1 GROUP_ID 1 33911 0 33911 100.0 1764 FALSE "-50" "17985" 2013-07-25/17:01:49 5 1.004860e-03 254 HEIGHT BALANCED FALSE YES NO GROUP_MEMBERS I_GR_MBRS__GI_II_UI_FL 2 INSTANCE_ID 3 33911 0 33911 100.0 29 FALSE "0" "597" 2013-07-25/17:01:49 4 1.474448e-05 29 FREQUENCY FALSE YES NO GROUP_MEMBERS I_GR_MBRS__GI_II_UI_FL 3 USER_ID 2 33911 0 33911 100.0 4610 FALSE "1" "18039" 2013-07-25/17:01:49 5 3.382573e-04 254 HEIGHT BALANCED FALSE YES NO GROUP_MEMBERS I_GR_MBRS__GI_II_UI_FL 4 FLG_INDIRECT 4 33911 16306 17605 100.0 1 FALSE "Y" "Y" 2013-07-25/17:01:49 2 1.000000e+00 1 NONE FALSE YES NO GROUP_MEMBERS UQ_GR_MBRS__UI_II_GI 1 USER_ID 2 33911 0 33911 100.0 4610 FALSE "1" "18039" 2013-07-25/17:01:49 5 3.382573e-04 254 HEIGHT BALANCED FALSE YES NO GROUP_MEMBERS UQ_GR_MBRS__UI_II_GI 2 INSTANCE_ID 3 33911 0 33911 100.0 29 FALSE "0" "597" 2013-07-25/17:01:49 4 1.474448e-05 29 FREQUENCY FALSE YES NO GROUP_MEMBERS UQ_GR_MBRS__UI_II_GI 3 GROUP_ID 1 33911 0 33911 100.0 1764 FALSE "-50" "17985" 2013-07-25/17:01:49 5 1.004860e-03 254 HEIGHT BALANCED FALSE YES NO

215187.1 sqlt_s29544_lite.html 2013-07-29/18:27:11