SQL Monitoring Report


SQL Text

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

Global Information: DONE (ALL ROWS)
Instance ID : 1
Buffer Gets Database Time Wait Activity

.

48

.

.

0s
Session : DMS (55:53271)
SQL ID : 0b2vmgwsxx9m3
SQL Execution ID : 16777218
Execution Started : 07/29/2013 18:17:33
First Refresh Time : 07/29/2013 18:17:33
Last Refresh Time : 07/29/2013 18:17:33
Duration : .002051s
Module/Action : sqltxadmin.sqlt$a (xecute)/29544 10398 ALTER SESSION SET EV
Service : SYS$USERS
Program : sqlplus@epdb2.katastr.int (TNS V1-V3)
Fetch Calls : 1

Binds
Name Position Type Value
:B5 1 NUMBER 3636688
:B4 2 NUMBER 7
:B3 3 NUMBER 29440
:B2 4 NUMBER 177
:B6 5 NUMBER 5179
:B1 8 NUMBER 15096


SQL Plan Monitoring Details (Plan Hash Value=3915546322)
Id Operation Name Estimated
Rows
Cost Active Period
(.002051s)
Execs Rows Memory
(Max)
Temp
(Max)
IO Requests CPU Activity Wait Activity

.

0 SELECT STATEMENT

.

.

.

.

.

.

.

.

.

.

.

1 . SORT AGGREGATE

.

1

.

.

.

.

.

.

.

.

.

2 .. INDEX RANGE SCAN PI_DATTR__DI_TA_3V 1 4

.

.

.

.

.

.

.

.

3 . SORT ORDER BY

.

1 65

.

1

.

.

.

.

.

.

4 .. FILTER

.

.

.

.

1

.

.

.

.

.

.

5 ... NESTED LOOPS ANTI

.

1 63

.

1

.

.

.

.

.

.

6 .... NESTED LOOPS SEMI

.

1 59

.

1

.

.

.

.

.

.

7 ..... NESTED LOOPS

.

1 58

.

1

.

.

.

.

.

.

8 ...... SORT UNIQUE

.

1 38

.

1

.

.

.

.

.

.

9 ....... PARTITION RANGE SINGLE

.

1 38

.

1

.

.

.

.

.

.

10 ........ PARTITION RANGE ALL

.

1 38

.

1

.

.

.

.

.

.

11 ......... TABLE ACCESS BY LOCAL INDEX ROWID DOC_ATTR 1 38

.

18

.

.

.

.

.

.

12 .......... INDEX RANGE SCAN PI_DATTR__TI_PI_DM_TA_3V 1 37

.

18

.

.

.

.

.

.

13 ...... PARTITION RANGE SINGLE

.

2 19

.

.

.

.

.

.

.

.

14 ....... PARTITION RANGE ALL

.

2 19

.

.

.

.

.

.

.

.

15 ........ TABLE ACCESS BY LOCAL INDEX ROWID DOC_RELATIONS 2 19

.

.

.

.

.

.

.

.

16 ......... INDEX RANGE SCAN PI_DRELS__DI_RI_FD_2RT 1 18

.

.

.

.

.

.

.

.

17 ..... INDEX UNIQUE SCAN UQ_DOC_TEMPLATES__TID_DID_IID 1 1

.

.

.

.

.

.

.

.

18 .... TABLE ACCESS BY GLOBAL INDEX ROWID DOC_ATTR 1 4

.

.

.

.

.

.

.

.

19 ..... INDEX RANGE SCAN PI_DATTR__DI_TA_3V 1 3

.

.

.

.

.

.

.

.

20 ... FILTER

.

.

.

.

.

.

.

.

.

.

.

21 .... TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS 1 3

.

.

.

.

.

.

.

.

22 ..... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT 1 2

.

.

.

.

.

.

.

.

23 .... INDEX UNIQUE SCAN UQ_GR_MBRS__UI_II_GI 1 1

.

.

.

.

.

.

.

.

24 ... TABLE ACCESS BY INDEX ROWID DOC_MEMBERS 1 1

.

.

.

.

.

.

.

.

25 .... INDEX RANGE SCAN I_DOC_MBRS__DI_UI_II 1 1

.

.

.

.

.

.

.

.

26 ... TABLE ACCESS BY INDEX ROWID ACMTT_ACL_MEMBERS 1 3

.

.

.

.

.

.

.

.

27 .... INDEX RANGE SCAN I_ACL_MBRS__AI_II_OI_OT 1 2

.

.

.

.

.

.

.