wgz7747147820的博客

禁用direct io read *._serial_direct_read='FALSE' *._small_table_threshold=1000000000 在11g中，全表扫描可能使用direct path read方式，绕过buffer cache，这样的全表扫描就是物理读了。 在10g中，都是通过gc buffer来读的，所以不存在direct path read的问题。 dire...

create bigfile tablespace tbs_1 datafile size 50g autoextend on next 2g extent management local uniform size 128m segment space management auto;

SQL> create table my_objs_query_low compress for query low as select * from my_objs; Table created. SQL> create table my_objs_query_high compress for query high as select * from my_objs; Tabl...