Re: Growing table

John,

Interesting idea, one I hadn't thought of. Sadly, degree = 1, though.

Thanks,

Terry

• Original Message ----- From: <john_clarke8_at_non.agilent.com> To: <terrysutton_at_usa.net> Sent: Friday, November 12, 2004 10:35 AM Subject: RE: Growing table

Terry,

Does SESSION_DATA have a parallel degree > 0 and is parallel DML enabled for the session that does the inserts? This will give you the same result as insert/append - parallel slaves insert into new blocks. Or at least my tests (and the documentation) suggest that.

SQL> set feed on
SQL> set term on
SQL> set echo on
SQL> select blocks from dba_tables where table_name='TEST_DBA_TABLES';

    BLOCKS

      1151

1 row selected.

SQL> SELECT DEGREE FROM DBA_TABLES WHERE TABLE_NAME='TEST_DBA_TABLES'; DEGREE

         3

1 row selected.

SQL> alter session enable parallel dml;

Session altered.

SQL> @ins
SQL> insert into test_dba_tables
  2 select * from dba_tables;

729 rows created.

SQL> commit;

Commit complete.

SQL> delete from test_dba_tables;

729 rows deleted.

SQL> commit;

Commit complete.

SQL> insert into test_dba_tables
  2 select * from dba_tables;

729 rows created.

SQL> commit;

Commit complete.

SQL> delete from test_dba_tables;

729 rows deleted.

SQL> commit;

Commit complete.

John

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 12 2004 - 12:40:13 CST