Hi,

Sometimes you can get  ” ORA-12805: parallel query server died unexpectedly ” error.

 

ORA-12805 parallel query server died unexpectedly

Details of error are as follows.

ORA-12805: 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.

 

If you got this error with ORA-07445 [qertqistart] or ORA-600 [15803] in Oracle 12.1.0.2, this was related with bug 25694206 and it is corrected in version 12.2.0.2.

 

To solve this error, Upgrade database from 12.1.0.2 to 12.2 or run the following command for workaround.

SQL> alter system set "_px_wif_extend_distribution_keys"=false scope=both sid='*';

System altered.

 

 

If this error is not get with ORA-600 then you can solve it to run the following command.

SQL> ALTER SESSION SET PARALLEL_FORCE_LOCAL=TRUE;

Session altered.

Or you should Increase the  sort_area_size as follows.

SQL> show parameter sort_area

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sort_area_retained_size integer 0
sort_area_size integer 65536
SQL>



alter session set sort_area_size = 640000 scope=both sid='*';

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )