SQL> select /*+ full(t) */count(*) from atg_sys.GOME_INF_DRAGON_DATA t;
2131432
Execution Plan
----------------------------------------------------------
Plan hash value: 3845749618
-----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2054K (1)| 06:50:48 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| GOME_INF_DRAGON_DATA | 18M| 2054K (1)| 06:50:48 |
-----------------------------------------------------------------------------------
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
873602 consistent gets
873594 physical reads
0 redo size
529 bytes sent via SQL*Net to client
520 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
alter table atg_sys.GOME_INF_DRAGON_DATA move comress;
SQL> select /*+ full(t) */count(*) from atg_sys.GOME_INF_DRAGON_DATA t;
2131432
Execution Plan
----------------------------------------------------------
Plan hash value: 3845749618
-----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2054K (1)| 06:50:48 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| GOME_INF_DRAGON_DATA | 18M| 2054K (1)| 06:50:48 |
-----------------------------------------------------------------------------------
Statistics
----------------------------------------------------------
7 recursive calls
0 db block gets
782847 consistent gets
782830 physical reads
0 redo size
529 bytes sent via SQL*Net to client
520 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
2131432
Execution Plan
----------------------------------------------------------
Plan hash value: 3845749618
-----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2054K (1)| 06:50:48 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| GOME_INF_DRAGON_DATA | 18M| 2054K (1)| 06:50:48 |
-----------------------------------------------------------------------------------
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
873602 consistent gets
873594 physical reads
0 redo size
529 bytes sent via SQL*Net to client
520 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
alter table atg_sys.GOME_INF_DRAGON_DATA move comress;
SQL> select /*+ full(t) */count(*) from atg_sys.GOME_INF_DRAGON_DATA t;
2131432
Execution Plan
----------------------------------------------------------
Plan hash value: 3845749618
-----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2054K (1)| 06:50:48 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| GOME_INF_DRAGON_DATA | 18M| 2054K (1)| 06:50:48 |
-----------------------------------------------------------------------------------
Statistics
----------------------------------------------------------
7 recursive calls
0 db block gets
782847 consistent gets
782830 physical reads
0 redo size
529 bytes sent via SQL*Net to client
520 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed