Database Tuning (MOSC)

MOSC Banner

[11g] DIRECT-MODE insert in a partitioned table

edited Apr 5, 2013 6:27AM in Database Tuning (MOSC) 6 commentsAnswered
Hi,

I would like to know if an INSERT with DIRECT-MODE (by using APPEND hint) in a partitioned table cause a full table lock or only for the partition concerned during the insert dml ?

INSERT /*+ APPEND */ INTO PRODUCTS SELECT * FROM NEW_PRODUCTS where PARTITION_KEY = '2012';

What are the disadvantages of using DIRECT-PATH in INSERT DML ?

Is it useful to use nologging mode to improve performances ?

Best regards.

GD.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center