alter session set db_file_multiblock_read_count
SQL> create table myTable
2 as
3 select rownum id, a.*
4 from all_objects a
5 where 1=0
6 /
SQL>
SQL>
SQL>
SQL> set autotrace traceonly explain
SQL> select * from myTable;
Execution Plan
----------------------------------------------------------
Plan hash value: 1015944200
-------------------------------------
| Id | Operation | Name |
-------------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL| MYTABLE |
-------------------------------------
Note
-----
- rule based optimizer used (consider using cbo)
SQL>
SQL> alter session set db_file_multiblock_read_count = 32;
SQL>
SQL> select * from myTable;
Execution Plan
----------------------------------------------------------
Plan hash value: 1015944200
-------------------------------------
| Id | Operation | Name |
-------------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL| MYTABLE |
-------------------------------------
Note
-----
- rule based optimizer used (consider using cbo)
SQL>
SQL> alter session set db_file_multiblock_read_count = 64;
SQL>
SQL> select * from myTable;
Execution Plan
----------------------------------------------------------
Plan hash value: 1015944200
-------------------------------------
| Id | Operation | Name |
-------------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL| MYTABLE |
-------------------------------------
Note
-----
- rule based optimizer used (consider using cbo)
SQL>
SQL>
SQL> set autotrace off
SQL>
SQL>
SQL> drop table myTable;
SQL>
SQL>
Related examples in the same category