We are running Oracle 11.2.0.3 on a Windows 2008 R2 Server with an app server on the same. Our app has a search function that has recently started timing out on us. Sometimes intermittently but often now. I've ran a trace in our dev environment, below code, in an attempt to track down the issue but I'm finding very little useful information in relation to the errors I see in the trace file below. My experience in deciphering trace code is nill so I was hoping there would be someone out there who could elaborate a little on how they interpret these errors or provide a resource so I could do so myself. I appreciate any help provided.
*** 2013-04-18 14:27:23.353
*** SESSION ID:(3093.63097) 2013-04-18 14:27:23.353
*** CLIENT ID:() 2013-04-18 14:27:23.353
*** SERVICE NAME:(SYS$USERS) 2013-04-18 14:27:23.353
*** MODULE NAME:(w3pw.exe) 2013-04-18 14:27:23.353
*** ACTION NAME:() 2013-04-18 14:27:23.353
ERROR #532357120:err=1013 tim=1395332943283
=====================
PARSING IN CURSOR #532354152 len=911 dep=2 uid=66 oct=47 lid=66 tim=1395332944838 hv=4132741411 ad='2a92d9d60' sqlid='27dnt1rv59893'
declare
sel number;
arg0 VARCHAR2(1) := null;
begin
:1 := "CTXSYS"."TEXTOPTSTATS".ODCIStatsSelectivity(
sys.ODCIPREDINFO('CTXSYS',
'CTX_CONTAINS',
'TEXTCONTAINS',
32),
sel,
sys.ODCIARGDESCLIST(sys.ODCIARGDESC(3, NULL, NULL, NULL, NULL, NULL, NULL), sys.ODCIARGDESC(5, NULL, NULL, NULL, NULL, NULL, NULL), sys.ODCIARGDESC(2, 'MV$SEARCH', 'CIPS', '"NAME"', NULL, NULL, NULL), sys.ODCIARGDESC(1, NULL, NULL, NULL, NULL, NULL, NULL)),
:3,
NULL
, arg0, :4,
sys.ODCIENV(:5,:6,:7,:8));
if sel IS NULL then
:2 := -1.0;
else
:2 := sel;
end if;
exception
when others then
raise;
end;
END OF STMT
PARSE #532354152:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=1395332944836
CLOSE #470004032:c=0,e=21,dep=3,type=1,tim=1395332945763
EXEC #532354152:c=0,e=1279,p=0,cr=9,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=1395332946378
ERROR #532354152:err=1013 tim=1395332946406
ERROR #532979664:err=1013 tim=1395333014987
ERROR #548803376:err=1013 tim=1395333015201