hi,good moring.i have a problem ,can you help me ,thank you
Oracle 10g windows server 2003
i have found a lock , locked mode is six, this makes me surprised, it have locked for serveral hours.
and i get the sql:
update seg$ set type#=: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(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
can you tell me what caused it and how to solve it? i think mode 6 lock is very .......
thanks .