SQL> @test
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.24
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.18
SQL> alter session set events '10046 trace name context off';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.72
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.24
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.15
SQL> alter session set events '10046 trace name context forever,level 12';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.69
SQL>
SQL> set timing on
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.29
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.18
SQL> alter session set events '10046 trace name context off';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.79
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.25
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.16
SQL> alter session set events '10046 trace name context forever,level 12';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.70
SQL>
SQL> set timing on
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.31
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.15
SQL> alter session set events '10046 trace name context off';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.69
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.25
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.19
SQL> alter session set events '10046 trace name context forever,level 12';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.67
SQL>
SQL> set timing on
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.26
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.16
SQL> alter session set events '10046 trace name context off';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.67
SQL> alter tablespace rawtest offline;
Tablespace altered.
Elapsed: 00:00:00.26
SQL> alter tablespace rawtest online;
Tablespace altered.
Elapsed: 00:00:00.16
SQL> alter session set events '10046 trace name context forever,level 12';
Session altered.
Elapsed: 00:00:00.00
SQL> select /*+FULL(A)*/ count(*) from account.testbig a;
COUNT(*)
----------
1707754
1 row selected.
Elapsed: 00:00:20.76
SQL>