Page 1 of 1

ORA-03117: two-task save area overflow

Posted: Tue 12 Feb 2013 17:13
by slaxman
Sometimes I am getting this oracle exception. Not sure what the exact scenario is. Any ideas?

EXCEPTION (Devart.Data.Oracle.OracleException): ORA-03117: two-task save area overflow
Stack Trace: at Devart.Data.Oracle.a6.b(Int32 A_0)
at Devart.Data.Oracle.a8.a(Int32 A_0, bw A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.w.a(CommandBehavior A_0)
at Devart.Common.Entity.o.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.w.b(CommandBehavior A_0)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

Re: ORA-03117: two-task save area overflow

Posted: Wed 13 Feb 2013 14:24
by Shalex
We recommend you to turn on the dbMonitor tool and find the SQL which fails to localize the issue:
http://www.devart.com/dotconnect/oracle ... nitor.html
http://www.devart.com/dbmonitor/dbmon3.exe
slaxman wrote:ORA-03117: two-task save area overflow
It looks like the problem at Oracle server side: http://ora-03117.ora-code.com/.