Hi, I am using Version-11.2.0.4 of oracle. We are seeing below error for one of the SELECT query which runs in multiple parallel threads. I see the query completes in ~10minutes and sometimes fast though. Rerun went smooth though. From the description of the error it seems there must be some direct path operation happening on one of the objects on which this query was running upon. But as i verified i dint get any Index rebuild or direct path operation on the underlying objects- TAB1. But i saw stats gather was running during that period on the underlying objects TAB1, so is there a possibility , by any chance this error can come during a SELECT query execution, when stat gather was running on same object? or any other ways to debug/fix this issue?
Error: ORA-12801: error signaled in parallel query server P020 ORA-08176: consistent read failure; rollback data not available Database driver error. Function Name : Execute SQL Stmt :
victorgrant replied
386 weeks ago