ORA-12805: parallel query server died unexpectedly

os: centos 7.6
db: oracle 19.3

压测应用报错

错误

2019-07-31 12:11:59.860 [appnode1] ERROR BaseController
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database.  Cause: java.sql.SQLException: ORA-12805: parallel query server died unexpectedly

### The error may exist in URL [jar:file:/apps/apps/webservice.jar!/BOOT-INF/classes!/mapper/OrderMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT hopo.a_id, hopo.a_number, hopo.amount, hopo.currency, hopo.a_date, hopo.source_code, hopo.order_number FROM order hopo WHERE hopo.a_type_code = ? AND hopo.a_batch = ? AND hopo.order_number = ? AND hopo.creation_date > ?
### Cause: java.sql.SQLException: ORA-12805: parallel query server died unexpectedly

; uncategorized SQLException for SQL []; SQL state [72000]; error code [12805]; ORA-12805: parallel query server died unexpectedly
; nested exception is java.sql.SQLException: ORA-12805: parallel query server died unexpectedly

$ oerr ora 12805
12805, 00000, "parallel query server died unexpectedly"
// *Cause: A parallel query server died unexpectedly, PMON cleaning
//         up the process.
// *Action: Check your system for anomalies and reissue the statement.
//          If this error persists, contact Oracle Support Services.
//          See trace file for more details.

搜索说是changing parallel_degree_policy=manual can fix the ORA-12805 error
结果就是 manual

SQL> set lines 200;
SQL> set pages 200;
SQL> show parameter parallel_degree_policy;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
parallel_degree_policy		     string	 MANUAL

SQL> show parameter parallel_max_servers;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
parallel_max_servers		     integer	 640

把 pga 的大小上调了一倍,再试试有没有报错.

SQL> alter system set pga_aggregate_limit=20G;
alter system set pga_aggregate_target=10G;

参考: