Autotrace a large table
SQL> SQL> create table my_all_objects 2 nologging 3 as 4 select * from all_objects 5 union all 6 select * from all_objects 7 union all 8 select * from all_objects 9 / Table created. SQL> SQL> SQL> set autotrace traceonly SQL> SQL> select owner, count(*) 2 from my_all_objects 3 group by owner; 13 rows selected. Execution Plan ---------------------------------------------------------- Plan hash value: 2509106709 ------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 33589 | 557K| 136 (6)| 00:00:02 | | 1 | HASH GROUP BY | | 33589 | 557K| 136 (6)| 00:00:02 | | 2 | TABLE ACCESS FULL| MY_ALL_OBJECTS | 33589 | 557K| 130 (2)| 00:00:02 | ------------------------------------------------------------------------------------- Note ----- - dynamic sampling used for this statement Statistics ---------------------------------------------------------- 48 recursive calls 0 db block gets 537 consistent gets 466 physical reads 0 redo size 694 bytes sent via SQL*Net to client 380 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 13 rows processed SQL> SQL> set autotrace off SQL> SQL> SQL> drop table my_all_objects; Table dropped. SQL> SQL> SQL>