Oracle-L: (no subject)

From: Gene Gurevich <g_u_r_e_v_i_c_h_at_yahoo.com>
Date: Fri, 29 Mar 2002 07:54:21 -0800
Message-ID: <F001.004369CC.20020329075421@fatcity.com>

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: g_u_r_e_v_i_c_h_at_yahoo.com

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: ListGuru_at_fatcity.com (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). Received on Fri Mar 29 2002 - 09:54:21 CST