about-oracle-parallel-insert-performance

alter session enable parallel dml;

18:28:14 SQL> insert /*+ append parallel(6) */ into mytable_tst
18:28:21   2  select * from MYTABLE_BCK;

1240808 rows created.

18:32:13 SQL> commit;

Commit complete.

18:33:34 SQL>

http://stackoverflow.com/questions/10421806/about-oracle-parallel-insert-performance

http://www.oraclerecipes.com/monitoring/monitor-long-running-oracle-operations/

#Move data from old table to new table

ALTER SESSION ENABLE PARALLEL DML;

ALTER TABLE OLD_MYTABLE PARALLEL;
ALTER TABLE MYTABLE PARALLEL;

INSERT INTO MYTABLE
SELECT * FROM OLD_MYTABLE;

COMMIT;

ALTER TABLE OLD_MYTABLE NOPARALLEL;
ALTER TABLE MYTABLE NOPARALLEL;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.