Home » Server Options » Text & interMedia » ORA-12801: error signaled in parallel query server P005
ORA-12801: error signaled in parallel query server P005 [message #48492] Tue, 23 November 2004 23:52 Go to next message
jigar
Messages: 74
Registered: July 2002
Member
I am getting following error while executing parallel query.

Error ORA-12801: error signaled in parallel query server P005

ORA-29903: error in executing ODCIIndexFetch() routine

ORA-20000: Oracle Text error:

DRG-50857: oracle error in drekrgm (one piece lob read)

ORA-01555: snapshot too old: rollback segment number with name "" too small

ORA-22924: snapshot too old - 12801

 

Do anybody have any idea?
Re: ORA-12801: error signaled in parallel query server P005 [message #48523 is a reply to message #48492] Thu, 25 November 2004 20:16 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Your Rollback segment is too small. If you are on 9i use undo_management=AUTO, else make your RBS's bigger.

hth
Re: ORA-12801: error signaled in parallel query server P005 [message #161469 is a reply to message #48492] Sun, 05 March 2006 00:27 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Just had the same problem - ORA-22924 is:

22924, 00000, "snapshot too old"
//  *Cause:  The version of the LOB value needed for the consistent read was
//           already overwritten by another writer.
//  *Action: Use a larger version pool.


To fix:

ALTER TABLE tablename MODIFY LOB (lobname) (PCTVERSION ...);


Looks like this happens with many concurrent updates. Snapshots and long running queries need to use an old version of a LOB - that version gets overwritten as PCTVERSION is too small.
Previous Topic: Getting an error while doing a search using intermedia
Next Topic: Question about dropping partitions in Oracle Text
Goto Forum:
  


Current Time: Sat Nov 23 21:15:37 CST 2024