Unable to parallelize the sql on session level
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 :
The output of the last statement shows that query has not run inparallel . ANy reason why it was like this ?
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 ?
0