how to avoid the error ..ORA-12801: error signaled in parallel query server ..
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 ??
-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 ??
1