SQL Tuning - Expert Oracle RAC Performance Diagnostics and Tuning - page 209

Rows Row Source Operation
------- ---------------------------------------------------
87 SORT ORDER BY (cr=3176 r=66 w=66 time=346886 us)
87 TABLE ACCESS BY GLOBAL INDEX ROWID USER_SECURITY PARTITION: 1 1
(cr=3176 r=66 w=66 time=338109 us)
78 NESTED LOOPS (cr=3088 r=66 w=66 time=334551 us)
90 NESTED LOOPS (cr=2596 r=66 w=66 time=322337 us)
90 NESTED LOOPS (cr=1614 r=66 w=66 time=309393 us)
90 VIEW (cr=632 r=66 w=66 time=293827 us)
48390 HASH JOIN (cr=632 r=66 w=66 time=292465 us)
6556373 TABLE ACCESS FULL USER_LOGIN (cr=190 r=0 w=0 time=38776 us)(object id 24891)
970 TABLE ACCESS FULL EL_USER (cr=442 r=0 w=0 time=56947 us)(object id 24706)
90 INDEX UNIQUE SCAN PK_EUSR PARTITION: 1 1 (cr=492 r=0 w=0 time=6055 us)
(object id 24741)
90 TABLE ACCESS BY LOCAL INDEX ROWID COMPANY PARTITION: 1 1
(cr=982 r=0 w=0 time=10135 us)
90 INDEX UNIQUE SCAN PK_COMP PARTITION: 1 1 (cr=492 r=0 w=0 time=4905 us)
(object id 24813)
87 INDEX RANGE SCAN USEC_INDX1 (cr=492 r=0 w=0 time=9115 us)(object id 24694)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
87 SORT (ORDER BY)
87 TABLE ACCESS GOAL: ANALYZED (BY GLOBAL INDEX ROWID) OF
'USER_SECURITY' PARTITION: START=1 STOP=1
78 NESTED LOOPS
90 NESTED LOOPS
90 NESTED LOOPS
90 VIEW OF 'index$_join$_003'
90 HASH JOIN
6556373 INDEX GOAL: ANALYZED (FAST FULL SCAN) OF
'PK_USRLI' (UNIQUE) PARTITION: START=1 STOP=1
90 INDEX GOAL: ANALYZED (FAST FULL SCAN) OF
'USRLI_INDX1' (NON-UNIQUE)
90 TABLE ACCESS GOAL: ANALYZED (BY LOCAL INDEX ROWID)
OF 'ELOGEX_USER' PARTITION: START=1 STOP=1
90 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_EUSR'
(UNIQUE) PARTITION: START=1 STOP=1
90 TABLE ACCESS GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF
'COMPANY' PARTITION: START=1 STOP=1
90 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_COMP'
(UNIQUE) PARTITION: START=1 STOP=1
87 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'USEC_INDX1'
(NON-UNIQUE)