ORA-03117: two-task save area overflow

ORA-03117: two-task save area overflow

Postby slaxman » Tue 12 Feb 2013 17:13

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)
slaxman
 
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

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

Postby Shalex » Wed 13 Feb 2013 14:24

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/docs/?dbmonitor.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/.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle