一点深入研究：这个参数究竟如何影响Oracle/OS

文件系统：Veritas VXFS With QuickIO

bash-2.03$ qiomkfile -s 200m yong.dbf

bash-2.03$ sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 18 14:52:47 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Connected to:

Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production

With the Partitioning option

JServer Release 8.1.7.2.0 - 64bit Production

SQL> create tablespace yong datafile '/oradata/standby/backup/yong.dbf' reuse

   2  extent management local uniform size 1m;

Tablespace created.

SQL> SQL>

SQL> alter table bidder.t move tablespace yong;

Table altered.

SQL> conn internal

Connected.

SQL> alter tablespace yong offline;

Tablespace altered.

SQL> alter tablespace yong online;

Tablespace altered.

SQL> conn bidder/bidder

Connected.

SQL> alter session set  db_file_multiblock_read_count=128;

Session altered.

SQL> ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER,LEVEL 12';

Session altered.

SQL> select count(*) from t;

   COUNT(*)

----------

     196736

Elapsed: 00:00:01.71

SQL> exit

Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production

With the Partitioning option

JServer Release 8.1.7.2.0 - 64bit Production