Database Software

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!

ora-12805 parallel query server died unexpectedly

007Mar 15 2020 — edited May 3 2020

Hi All,

I am performing a full import of a database with Parallel=13 version 12.1.0.2.0 and i am facing the error ORA-12805 parallel query server died unexpectedly.The alert log shows the error "Kkjcre1p: Unable To Spawn Jobq Slave Process" and "Process m001 died" errors. I have set the below values in database for this import

Memory_Target=20G

Memory_Max_target=20G

pga_aggregate_limit =20G

job_queue_processes=50

processes=1500

The server RAM capacity is 30G and cpu is 16.Does this error can be avoided by resetting any value in the database or any OS level setting needs to be changed?

Regards,

007

Added on Mar 15 2020

#database-key-features, #export-import-sql-loader-external-tables

2 comments

1,311 views