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

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <shastry17@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Jul 2007 12:23:40 -0400

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;



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


Other related posts: