Database DataWarehousing (MOSC)
MOSC Banner

how to avoid the error ..ORA-12801: error signaled in parallel query server ..

edited Sep 21, 2011 11:18PM in Database DataWarehousing (MOSC) 1 commentAnswered
We have 3 node RAC on 10gR2( 12 cpu and 2 threads_per_cpu). FOllowing query is taking 8 hours and failed with following error :
-A database error occured. The database error text is: ORA-12801: error signaled in parallel query server P025, instance dap-ccdw-ora01:CCDWP1 (1) ORA-01410: invalid ROWID . (WIS 10901)
-A database error occured. The database error text is: ORA-12801: error signaled in parallel query server P090, instance dap-ccdw-ora02:CCDWP2 (2) ORA-01652: unable to extend temp segment by 128 in tablespace TEMP . (WIS 10901)

I guess reason is unbalanced usage of temp space by parallel resources.

In this query all tables are serial( degree =1 ) and one table is huze ( fact table with 127 gb size ). but all the operations are in parallel. Why ??

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