Database Administration (MOSC)

MOSC Banner

[ORACLE 12c] inmemory + parallel in the alter table DDL

edited Apr 20, 2016 10:06AM in Database Administration (MOSC) 2 commentsAnswered

hello,

is there any reason to expect performance enhancement during an inmemory loading process or not ?

Currently, we do:

alter table ONETABLE <inmemory clause> parallel 18;

and I just tested the same DDL without the parallel clause (prior to this, I passed the noparallel clause) and I can see *NO* decrease in the load process.

So, does it change something for the LOAD INMEMORY or not ?

Regards

Xavier

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