Database DataWarehousing (MOSC)

MOSC Banner

Unable to parallelize the sql on session level

edited Sep 8, 2010 3:47AM in Database DataWarehousing (MOSC) 7 commentsAnswered
 Hi,
In our RAC Datawarehouse database 10gR2, Parallelism is setup and queries involving appropriate DOP are using it for the betterment but I wanted to use the parallelism on session level not on object level so I did following :
  • Took 2 tables A and B.
  • Set Degree=1 for both tables A and B.
  • Set Degree=1 for all the indexes of A and B.
  • Run the command Alter session force parallel DML
  • Run the query invloving a Join them on appropriate indexes columns.
  • Run the statement : select * from v$pq_sesstat;

The output of the last statement shows that query has not run inparallel . ANy reason why it was like this ?

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