Session altered. Elapsed: 00:00:00.00 Sequence dropped. Elapsed: 00:00:00.09 Table dropped. Elapsed: 00:00:00.47 Table created. Elapsed: 00:00:00.04 PL/SQL procedure successfully completed. Elapsed: 00:00:00.39 Table altered. Elapsed: 00:00:00.02 Index created. Elapsed: 00:00:00.02 Sequence created. Elapsed: 00:00:00.01 PL/SQL procedure successfully completed. Elapsed: 00:06:14.94 PL/SQL procedure successfully completed. Elapsed: 00:00:52.84 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050501 0 TSP_20050502 0 TSP_20050503 0 TSP_20050504 0 TSP_20050505 0 TSP_20050506 0 TSP_20050507 0 TSP_20050508 0 TSP_20050509 50000 TSP_20050510 50000 TSP_20050511 50000 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050512 50000 TSP_20050513 50000 TSP_20050514 50000 TSP_20050515 50000 TSP_20050516 50000 TSP_20050517 50000 TSP_20050518 50000 TSP_20050519 50000 TSP_20050520 50000 TSP_20050521 50000 TSP_20050522 50000 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050523 50000 TSP_20050524 50000 TSP_20050525 50000 TSP_20050526 50000 TSP_20050527 50000 TSP_20050528 50000 TSP_20050529 50000 TSP_20050530 50000 TSP_20050531 50000 TSP_20050601 50000 TSP_20050602 50000 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050603 50000 TSP_20050604 50000 TSP_20050605 50000 TSP_20050606 50000 TSP_20050607 50000 TSP_20050608 50000 TSP_20050609 50000 TSP_20050610 50000 TSP_20050611 50000 TSP_20050612 50000 TSP_20050613 50000 44 rows selected. Elapsed: 00:00:00.38 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (ORDER BY) 2 1 VIEW OF 'USER_TAB_PARTITIONS' 3 2 UNION-ALL 4 3 NESTED LOOPS 5 4 NESTED LOOPS 6 5 NESTED LOOPS 7 6 TABLE ACCESS (FULL) OF 'TABPART$' 8 6 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' 9 8 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) 10 5 TABLE ACCESS (CLUSTER) OF 'SEG$' 11 10 INDEX (UNIQUE SCAN) OF 'I_FILE#_BLOCK#' (NON-U NIQUE) 12 4 TABLE ACCESS (CLUSTER) OF 'TS$' 13 12 INDEX (UNIQUE SCAN) OF 'I_TS#' (NON-UNIQUE) 14 3 NESTED LOOPS 15 14 TABLE ACCESS (FULL) OF 'TABPART$' 16 14 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' 17 16 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) 18 3 NESTED LOOPS 19 18 NESTED LOOPS 20 19 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' 21 20 INDEX (RANGE SCAN) OF 'I_OBJ2' (UNIQUE) 22 19 TABLE ACCESS (BY INDEX ROWID) OF 'TABCOMPART$' 23 22 INDEX (UNIQUE SCAN) OF 'I_TABCOMPART$' (UNIQUE ) 24 18 TABLE ACCESS (CLUSTER) OF 'TS$' 25 24 INDEX (UNIQUE SCAN) OF 'I_TS#' (NON-UNIQUE) Statistics ---------------------------------------------------------- 7 recursive calls 0 db block gets 349 consistent gets 0 physical reads 0 redo size 1786 bytes sent via SQL*Net to client 673 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 44 rows processed COUNT(*) ---------- 1800000 Elapsed: 00:00:01.03 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE (Cost=281 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE_PARTITIONED' (Cos t=281 Card=1800000) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4760 consistent gets 4592 physical reads 0 redo size 492 bytes sent via SQL*Net to client 651 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed CREATE_DA COUNT(TXN_ID) --------- ------------- 08-MAY-05 50000 09-MAY-05 50000 10-MAY-05 50000 11-MAY-05 50000 12-MAY-05 50000 13-MAY-05 50000 14-MAY-05 50000 15-MAY-05 50000 16-MAY-05 50000 17-MAY-05 50000 18-MAY-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 19-MAY-05 50000 20-MAY-05 50000 21-MAY-05 50000 22-MAY-05 50000 23-MAY-05 50000 24-MAY-05 50000 25-MAY-05 50000 26-MAY-05 50000 27-MAY-05 50000 28-MAY-05 50000 29-MAY-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 30-MAY-05 50000 31-MAY-05 50000 01-JUN-05 50000 02-JUN-05 50000 03-JUN-05 50000 04-JUN-05 50000 05-JUN-05 50000 06-JUN-05 50000 07-JUN-05 50000 08-JUN-05 50000 09-JUN-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 10-JUN-05 50000 11-JUN-05 50000 12-JUN-05 50000 36 rows selected. Elapsed: 00:00:02.72 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE (Cost=2526 Card=36 Bytes=288 ) 1 0 PARTITION RANGE (ALL) 2 1 SORT (GROUP BY) (Cost=2526 Card=36 Bytes=288) 3 2 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE_PARTITIONED' (Cos t=281 Card=1800000 Bytes=14400000) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4760 consistent gets 4592 physical reads 0 redo size 1462 bytes sent via SQL*Net to client 673 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 44 sorts (memory) 0 sorts (disk) 36 rows processed PL/SQL procedure successfully completed. Elapsed: 00:00:04.42 PL/SQL procedure successfully completed. Elapsed: 00:00:42.75 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050501 0 TSP_20050502 0 TSP_20050503 0 TSP_20050504 0 TSP_20050505 0 TSP_20050506 0 TSP_20050507 0 TSP_20050508 0 TSP_20050509 0 TSP_20050510 0 TSP_20050511 0 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050512 0 TSP_20050513 0 TSP_20050514 50000 TSP_20050515 50000 TSP_20050516 50000 TSP_20050517 50000 TSP_20050518 50000 TSP_20050519 50000 TSP_20050520 50000 TSP_20050521 50000 TSP_20050522 50000 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050523 50000 TSP_20050524 50000 TSP_20050525 50000 TSP_20050526 50000 TSP_20050527 50000 TSP_20050528 50000 TSP_20050529 50000 TSP_20050530 50000 TSP_20050531 50000 TSP_20050601 50000 TSP_20050602 50000 PARTITION_NAME NUM_ROWS ------------------------------ ---------- TSP_20050603 50000 TSP_20050604 50000 TSP_20050605 50000 TSP_20050606 50000 TSP_20050607 50000 TSP_20050608 50000 TSP_20050609 50000 TSP_20050610 50000 TSP_20050611 50000 TSP_20050612 50000 TSP_20050613 50000 44 rows selected. Elapsed: 00:00:00.89 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE 1 0 SORT (ORDER BY) 2 1 VIEW OF 'USER_TAB_PARTITIONS' 3 2 UNION-ALL 4 3 NESTED LOOPS 5 4 NESTED LOOPS 6 5 NESTED LOOPS 7 6 TABLE ACCESS (FULL) OF 'TABPART$' 8 6 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' 9 8 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) 10 5 TABLE ACCESS (CLUSTER) OF 'SEG$' 11 10 INDEX (UNIQUE SCAN) OF 'I_FILE#_BLOCK#' (NON-U NIQUE) 12 4 TABLE ACCESS (CLUSTER) OF 'TS$' 13 12 INDEX (UNIQUE SCAN) OF 'I_TS#' (NON-UNIQUE) 14 3 NESTED LOOPS 15 14 TABLE ACCESS (FULL) OF 'TABPART$' 16 14 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' 17 16 INDEX (UNIQUE SCAN) OF 'I_OBJ1' (UNIQUE) 18 3 NESTED LOOPS 19 18 NESTED LOOPS 20 19 TABLE ACCESS (BY INDEX ROWID) OF 'OBJ$' 21 20 INDEX (RANGE SCAN) OF 'I_OBJ2' (UNIQUE) 22 19 TABLE ACCESS (BY INDEX ROWID) OF 'TABCOMPART$' 23 22 INDEX (UNIQUE SCAN) OF 'I_TABCOMPART$' (UNIQUE ) 24 18 TABLE ACCESS (CLUSTER) OF 'TS$' 25 24 INDEX (UNIQUE SCAN) OF 'I_TS#' (NON-UNIQUE) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 347 consistent gets 1 physical reads 0 redo size 1786 bytes sent via SQL*Net to client 673 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 44 rows processed COUNT(*) ---------- 1550000 Elapsed: 00:00:01.39 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE (Cost=244 Card=1) 1 0 SORT (AGGREGATE) 2 1 INDEX (FAST FULL SCAN) OF 'TRANS_SAMPLE_PARTITIONED_PK' (NON-UNIQUE) (Cost=244 Card=1550000) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4636 consistent gets 4195 physical reads 0 redo size 492 bytes sent via SQL*Net to client 651 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed CREATE_DA COUNT(TXN_ID) --------- ------------- 13-MAY-05 50000 14-MAY-05 50000 15-MAY-05 50000 16-MAY-05 50000 17-MAY-05 50000 18-MAY-05 50000 19-MAY-05 50000 20-MAY-05 50000 21-MAY-05 50000 22-MAY-05 50000 23-MAY-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 24-MAY-05 50000 25-MAY-05 50000 26-MAY-05 50000 27-MAY-05 50000 28-MAY-05 50000 29-MAY-05 50000 30-MAY-05 50000 31-MAY-05 50000 01-JUN-05 50000 02-JUN-05 50000 03-JUN-05 50000 CREATE_DA COUNT(TXN_ID) --------- ------------- 04-JUN-05 50000 05-JUN-05 50000 06-JUN-05 50000 07-JUN-05 50000 08-JUN-05 50000 09-JUN-05 50000 10-JUN-05 50000 11-JUN-05 50000 12-JUN-05 50000 31 rows selected. Elapsed: 00:00:02.35 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=RULE (Cost=2177 Card=31 Bytes=248 ) 1 0 PARTITION RANGE (ALL) 2 1 SORT (GROUP BY) (Cost=2177 Card=31 Bytes=248) 3 2 TABLE ACCESS (FULL) OF 'TRANS_SAMPLE_PARTITIONED' (Cos t=244 Card=1550000 Bytes=12400000) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 4135 consistent gets 3972 physical reads 0 redo size 1350 bytes sent via SQL*Net to client 673 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 44 sorts (memory) 0 sorts (disk) 31 rows processed