Database Tuning (MOSC)

MOSC Banner

ORA-12805: parallel query server died unexpectedly

OS: MS Windows 2012 R2

DB: 12c Enterprise Edition Release 12.2.0.1.0 - 64bit


I am getting below error message while running a schedule job through Oracle Data Integrator 12.2. This job runs a lengthy query joining 10 to 12 tables every morning around 3am (non peek hours). Earlier data was slightly less and it was running fine but from last 6 months it has starting giving error without giving any output. The error is not consistent as sometimes it succeeds as well. However most of the days of week it throughs error after running for around 50 minutes. (like 1 days succeed, 6 days error, randomly no fixed days of week)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center