Re: sql trace - XCTEND rlbk=1, rd_only=1

Boris

It look like the app's is doing rollback :-( Have a look in Note 39817.1 Interpreting Raw SQL_TRACE ... for more info.  

XCTEND rlbk=(0 or 1) rd_only= (0 or 1)

rlbk : 1 = rollback 0 = commit

rd_only : 1 = read only transaction 0 = none read only

/peter

Boris Dali wrote:

>I've got a third party package that connects to Oracle
>via OCI and works in HTTP-like (stateless) fashion.
>Reviewing raw SQL trace output I don't see a single
>commit or rollback there, but there are plenty of
>XCTEND tx markers with rlbk=1 (after about every
>SELECT statement). Is this normal? Does this mean that
>this app rollbacks (implicitly?) after each of those
>selects?
>
>Thanks,
>Boris Dali.
>
>______________________________________________________________________
>Post your free ad now! http://personals.yahoo.ca
>
>

-- 
Peter Gram
 
comp  : Miracle A/S
Addr  : Kratvej 2, 2760 Maaloev 
Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
mail  : peter.gram@MiracleAS.dk - http://www.miracleas.dk

Upcoming events:

Miracle Master Class with Tom Kyte, 12-14 January 2004
Visit   http://miracleas.dk/en/events.html#MasterClass

Visit http://www.miracleas.dk fore news !




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).