Oracle parallel principles (next)

Statistics Statistical information

----------------------------------------------------------

197 Recursive calls

185 db block gets

Consistent gets

Physical Reads

37128 Redo Size 37128 Redo Amount

664 Bytes sent via sql*net to client

571 Bytes received via sql*net from client

4 sql*net roundtrips To/from Client

3 Sorts (memory)

0 Sorts (disk)

10340 rows processed

ls@leo> rollback; Rolling back

Rollback complete.

ls@leo> Insert/*+ append/into LEO_T5 select * from Leo_t6; Load directly

10340 rows created.

Statistics

----------------------------------------------------------

Recursive calls

180 db block gets

Consistent gets

Physical Reads

36640 Redo Size 36640 Redo Amount

664 Bytes sent via sql*net to client

585 Bytes received via sql*net from client

4 sql*net roundtrips To/from Client

2 Sorts (memory)

0 Sorts (disk)

10340 rows processed

Summary: We see that there is not much difference in the amount of redo that is produced by traditional loading and direct loading, because redo information is generated as long as the underlying block of data is changed,

Both traditional and direct modifications to data blocks are used to restore the basis, so there is not much difference.

(10) Direct loading and indexing

ls@leo> set Autotrace trace stat;

ls@leo> Insert/*+ append/into LEO_T5 select * from Leo_t6; Load directly, but no index on the table

10340 rows created.

Statistics Statistical information

----------------------------------------------------------

Recursive calls

175 db block gets

Bayi consistent gets

Physical Reads

36816 Redo Size 36816 Redo Amount

664 Bytes sent via sql*net to client

585 Bytes received via sql*net from client

4 sql*net roundtrips To/from Client

2 Sorts (memory)

0 Sorts (disk)

10340 rows processed

Ls@leo> CREATE index Leo_t5_index on LEO_T5 (object_id); To create an index on a table

Index created.

ls@leo> rollback; Rolling back

Rollback complete.

ls@leo> Insert/*+ append/into LEO_T5 select * from Leo_t6; Load directly, but with indexes on the table

10340 rows created.

Statistics Statistical information

----------------------------------------------------------

Recursive calls

193 db Block gets

Consistent gets

Physical Reads

37344 Redo Size 37344 Redo Amount

664 Bytes sent via sql*net to client

585 Bytes received via sql*net from client

4 sql*net roundtrips To/from Client

3 Sorts (memory)