16:52:42 SQL> connect crb/crb
Connected.
16:52:48 SQL> alter session set events '10046 trace name context forever, level 12';
 
Session altered.
 
Elapsed: 00:00:00.02
16:52:56 SQL> analyze table a compute statistics ;
 
Table analyzed.
 
Elapsed: 00:00:13.85
16:53:22 SQL> exit

                                                                                                                
Rows     Row Source Operation
-------  ---------------------------------------------------
      1  SORT ORDER BY (cr=7 pr=1 pw=0 time=23243 us)
      1   HASH JOIN OUTER (cr=7 pr=1 pw=0 time=23123 us)
      1    NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=238 us)
      1     TABLE ACCESS CLUSTER IND$ (cr=4 pr=0 pw=0 time=174 us)
      1      INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=74 us)(object id 3)
      0     TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=50 us)
      0      INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=43 us)(object id 711)
      0    VIEW  (cr=2 pr=1 pw=0 time=19871 us)
      0     SORT GROUP BY (cr=2 pr=1 pw=0 time=19862 us)
      0      TABLE ACCESS BY INDEX ROWID CDEF$ (cr=2 pr=1 pw=0 time=19641 us)
      0       INDEX RANGE SCAN I_CDEF2 (cr=2 pr=1 pw=0 time=19634 us)(object id 51)