Mega Code Archive

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>