Database DataWarehousing (MOSC)

MOSC Banner

[11gR2] implement parallelism : 1 user per partition !

edited Apr 7, 2013 10:36PM in Database DataWarehousing (MOSC) 7 commentsAnswered
Hi,

I have to implement parallelism in my application ( 11g) to improve performances.

What’s the best strategy/method/ and conditions  to  implement this mechanism (11gr2)  knowing that

when a user  user_xxx execute a query , it concerns the same partition P_xxx of each table/index of the database.

Another user_yyy works only in partition P_yyy of each table/index.

User is associated to one environment (=partition).

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