并行查询定位问题

ptc学习者

已于 2024-05-31 00:37:47 修改

阅读量377

点赞数 4

分类专栏：笔记文章标签：人工智能

于 2024-05-26 16:40:10 首次发布

本文链接：https://blog.csdn.net/oZiSeFengYe1/article/details/139216733

版权

笔记专栏收录该内容

79 篇文章 0 订阅

订阅专栏

http://m.blog.itpub.net/22782597/viewspace-622714/
http://m.blog.itpub.net/30126024/viewspace-2148192/

数据库降级执行

PARALLEL_DEGREE_POLICY
PARALLEL_DEGREE_POLICY
PARALLEL_MIN_PERCENT
PARALLEL_SERVERS_TARGET
PARALLEL_MAX_PERCENT

SELECT *
FROM V$SES_OPTIMIZER_ENV;

报错是 java.sql.SQLException: ORA-12801: error signaled in parallel query server P311
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded

SELECT 0 indexAlias ,A0.blob$entrySetadHocAcl,A0.classnameA2A2,A0.branchIdA2typeDefinitionRefe,A0.idA3A2ownership,A0.idA2A2,A0.typeadministrativeLock,A0.classnamekeydomainRef,A0.securityLabels,A0.entrySetadHocAcl,A0.statestate,A0.idA3domainRef,A0.classnamekeyA2ownership,'wt.doc.WTDocument' classnameA2A2,A0.branchIditerationInfo,'VR',COUNT(*) OVER ( PARTITION BY A0.idA3masterReference),A0.idA3masterReference,-1,A0.versionSortIdA2versionInfo,UPPER(A0B.name) SORT_ATTR0 FROM WTDocument A0,WTDocumentMaster A0B WHERE (A0.idA3masterReference=A0B.idA2A2) AND ((A0.latestiterationInfo = ?) AND (A0.branchIditerationInfo IN (SELECT /*+ CARDINALITY(wtot 1600) */ * FROM TABLE(cast(? as WCADMIN.TABLE_OF_NUMBER)) wtot WHERE (ROWNUM > 0) AND (column_value IS NOT NULL)))) ORDER BY SORT_ATTR0 DESC;

为了解决上述问题，需要参考Oracle并行执行（Oracle Parallel Execution）

https://blog.csdn.net/frostlulu/article/details/131312420