Re: Weired problem when using serializable transaction in 10g

According to your trace file:

> PARSING IN CURSOR #6 len=48 dep=0 uid=65 oct=7 lid=65 tim=105493980587
hv=3637529011 ad='67da3a90'
> delete from PROPERTIES p where p.VERSION_ID = 28
> END OF STMT
> PARSE #6:c=0,e=231,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=105493980577
> EXEC #6:c=0,e=259,p=0,cr=1,cu=1,mis=0,r=1,dep=0,og=1,tim=105493980952
> STAT #6 id=1 cnt=0 pid=0 pos=1 obj=0 op='DELETE (cr=1 pr=0 pw=0 time=160
us)'
> STAT #6 id=2 cnt=1 pid=1 pos=1 obj=51685 op='INDEX RANGE SCAN SYS_C007946
(cr=1 pr=0 pw=0 time=85 us)'

Note the EXEC line, which contains the text "r=1".

For a delete statement, this should be the number of rows deleted.

If this trace is from your script, then there is something odd going on - but I wouldn't speculate about the source of the oddity until I see a trace that is guaranteed to be the definitive end to end simple test case. (For example - what happened to cursor #5 ?)

In passing - here's a complete log from an SQL session which produces a similar effect - but is not what's happening in your case:

SQL> spool temp
SQL> truncate table t1;

Table truncated.

SQL> insert into t1 values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> delete from t1;

1 row deleted.

SQL> delete from t1;

1 row deleted.

SQL> delete from t1;

1 row deleted.

SQL> delete from t1;

1 row deleted.

SQL> delete from t1;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select * from t1;

        N1

         1

1 row selected.

SQL> spool off

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Oliver Zeigermann" <oliver_at_zeigermann.de> wrote in message
news:2jnl4vF12hqujU1_at_uni-berlin.de...


> Yes, the trace matches the run with 17 deleted rows I guess, but I will

> re-check.

>

> - Where do you see one row is deleted?

> - Still, even if it was just one row, this is strange, right?

> - What is an Object table?

>

> Thanks,

>

> Oliver

>