Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error on Parallel Hint

MAZHAR.Jun 13 2017 — edited Jun 14 2017

Need explanation for the below error which I am getting on 3 node RAC

Mon Jun 12 15:45:23 CDT 2017

USER is "scott"

with vw as (select /*+ parallel(a,8,1) */ * from scott.my_view a),

ERROR at line 1:

ORA-12801: error signaled in parallel query server P008, instance zz3hi099oSCAR999P2 (2)

ORA-01652: unable to extend temp segment by 64 in tablespace TEMP1

Elapsed: 00:18:31.48

This post has been answered by JohnWatson2 on Jun 13 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2017

Added on Jun 13 2017

#general-database-discussions

12 comments

708 views