Scott Gamble wrote:
> The table is not dropped, its defined as a global temp table (on commit
> preserve rows) due to the third party app and its processing.
>
> I am trying to figure out why I am not getting the actual 'commit' text in
> the trace of this new release as we did in the old. I suppose it is
> possible that they are not reparsing the statement as they have in the
> past.
>
> Thanks for the answer
>
> Scott
>
>
> Tanel Poder <tanel_at_peldik.kom> wrote in
> news:3d8b3150$1_1_at_news.estpak.ee:
>
>
>>Hello!
>>
>>XCTEND means transaction end, thus commit or rollback
>>
>>rlbk=0 - commit was done
>>rlbk=1 - rollback was done
>>
>>rd_only=0 means that changes were made in this transaction
>>rd_only=1 means that transaction didn't change any data
>>
>>So, it seems that you do have several commits in your code.
>>
>>Do you just delete from this temp table or drop it as well?
>>
>>Tanel.
>>
>>
you could use log miner to see where the extra commits come from.
--
hth,
Stan
Received on Fri Sep 20 2002 - 21:00:56 CDT
