Hi A developer is getting a sporadic errors when trying to access ORacle database via a Cold Fusion screen. The messages on the screen are Oracle Error Code = 0 Timeout while obtaining an Oracle statement lock. I turned tracing on in his session and found this in the trace file:
update seg$ set type=:3,ts#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9, extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:1 4, 65535, NULL, :14) where file#=:1 and block#=:2 END OF STMT PARSE :c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=3,tim=0 EXEC 2:c=0,e=0,p=0,cr=5,cu=1,mis=0,r=1,dep=1,og=3,tim=0 STAT #2 id=1 cnt=1 pid=0 pos=0 obj=13 op='TABLE ACCESS CLUSTER SEG$ ' STAT #2 id=2 cnt=1 pid=1 pos=1 obj=8 op='INDEX UNIQUE SCAN 'EXEC #1:c=0,e=0,p=9985,cr=61653,cu=432587,mis=0,r=0,dep=0,og=3,tim=0 ERROR #1:err=3113 tim=0 STAT #1 id=1 cnt=60082 pid=0 pos=0 obj=1147 op='INDEX RANGE SCAN ' Looks like ORA-03113, but no mentinong of it in the alert.log What should be my next step. any ideas? thanks Gene ===== __________________________________________________ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
