svk
I've never seen INACTIVE redo groups.
We have 5 members per group, each member 256MB. Average log switch time every 10 to 15 minutes during the day.


Here are the results of the CTAS test just before the users arrive (the reading rooms open at 9:30 BST) - this would of upset a few internet web users tho!


This is the SQLPLUS script

Code:
SQL> @lf0
Connected.
[email protected]-datasrv>
[email protected]-datasrv>
[email protected]-datasrv> SELECT MAX( snap_id ) FROM perfstat.stats$snapshot;

MAX(SNAP_ID)
------------
        8128

Elapsed: 00:00:00.00
[email protected]-datasrv> DROP TABLE gwicks.z02_full3;

Table dropped.

Elapsed: 00:00:00.62
[email protected]-datasrv>
[email protected]-datasrv> exec perfstat.statspack.snap

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.19
[email protected]-datasrv> CREATE TABLE gwicks.z02_full3
  2  NOLOGGING
  3  AS
  4  SELECT     *
  5  FROM       bll10.z02
  6  WHERE      z02_doc_number LIKE '005%';

Table created.

Elapsed: 00:02:166.40
[email protected]-datasrv> exec perfstat.statspack.snap

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.72
[email protected]-datasrv> SELECT MAX( snap_id ) FROM perfstat.stats$snapshot;

MAX(SNAP_ID)
------------
        8130

Elapsed: 00:00:00.00
[email protected]-datasrv>
[email protected]-datasrv>
[email protected]-datasrv>
[email protected]-datasrv>
[email protected]-datasrv>
[email protected]-datasrv> SELECT MAX( snap_id ) FROM perfstat.stats$snapshot;

MAX(SNAP_ID)
------------
        8130

Elapsed: 00:00:00.00
[email protected]-datasrv> DROP TABLE gwicks.z02_full3;

Table dropped.

Elapsed: 00:00:00.81
[email protected]-datasrv>
[email protected]-datasrv> exec perfstat.statspack.snap

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.41
[email protected]-datasrv> CREATE TABLE gwicks.z02_full3
  2  --NOLOGGING
  3  AS
  4  SELECT     *
  5  FROM       bll10.z02
  6  WHERE      z02_doc_number LIKE '005%';

Table created.

Elapsed: 00:02:167.59
[email protected]-datasrv> exec perfstat.statspack.snap

PL/SQL procedure successfully completed.

Elapsed: 00:00:01.88
[email protected]-datasrv> SELECT MAX( snap_id ) FROM perfstat.stats$snapshot;

MAX(SNAP_ID)
------------
        8133

Elapsed: 00:00:00.00
[email protected]-datasrv>
[email protected]-datasrv>
[email protected]-datasrv>