Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-12801: error signaled in parallel query server P038 ORA-12801: error signaled in parallel query server P038

RE: ORA-12801: error signaled in parallel query server P038 ORA-12801: error signaled in parallel query server P038

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 10 Jul 2007 12:23:40 -0400
Message-ID: <BAY141-DAV1572001231B2F83E39428BA6050@phx.gbl>
Message-ID: <000c01c7c30e$ad42e7b0$cb7810ac@bell.corp.bce.ca> 





Did you try it serially?


I've usually seen these types of errors with corruption.
Try analyze table table_name validate structure.
Or run a query that does a full table scan and see if you get the same
errors.


Select /*+ full(a) */ count(*)


From table_name a;




--
http://www.freelists.org/webpage/oracle-l


Received on Tue Jul 10 2007 - 11:23:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US