 | |
| ORA-12801 | | ORA-12801: | error signaled in parallel query server string | | Cause: | A parallel query server reached an exception condition. | | Action: | Check the following error message for the cause, and consult your error manual for the appropriate action.
|
|
|
| Posts about ORA-12801 | | We get the following error when using parallel query
across schemas and a logon trigger that alters the
session to enable resumable.
Any ideas why we would be getting this error?
The user running thHi All
A parallel query on a Range Partitioned IOT is exiting with the below
error
ORA-12801 error signaled in parallel query server P024
ORA-00904 "A1 ". "rowid " invalid identifier
The oracle vOn 8/19/05 VIVEK_SHARMA <VIVEK_SHARMA@(protected) > wrote
>
> SQL > alter session set sort_area_size 500000000
>
> SQL > exec
> dbms_stats.gather_table_stats( 'TBAADM ' 'HIST_TRAN_DTL_TABLE ' degree
SQL > alter session set sort_area_size 500000000
SQL > exec
dbms_stats.gather_table_stats( 'TBAADM ' 'HIST_TRAN_DTL_TABLE ' degree >4 e
stimate_percent >30)
ERROR at line 1
ORA-12801 errorDoes anybody know why I am getting this error
Start of log messages from Plsql program
+I am finally getting to practice some of the tracing functionality that is discussed here and ran into something I haven 't seen dicussed here. We had a complaint about a query that performs inconsistI have the only process running on the server. I am using an undo tablespace with 15 GBs of undo. I have undo retention set to 20000(I just upped it due to the error) and I get the following error. Th |
|
| Oracle Database Server Error Codes | |
|