Newbie question -on enablecommit and disablecommit

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: sidd (siddharthkhare_at_hotmail.com)
Date: 08/12/04


Date: 12 Aug 2004 00:01:13 -0700

Hi All,
1)enableCommit Sets the consistent bit to true and the done bit to
false in the COM+ context.

but could some one explain a senario(example) when one would use this
method.

in other words an example on when one would want to sets the
consistent bit to true and the done bit to false .

i could see the description for these methods in msdn but could not
find a sample which would explain when and where to use it .
if possible please explain in follwoing cases
i)objects are only making use of com+ transaction support
ii)objects are using JITA and/or object pooling.

2)also second question ..if you are using com+ transaction support,can
one also use transaction in storedProc level.commiting or rollbacking
a transaction in stored proc... will it have any effect?

thanks
siddharth



Relevant Pages

  • Re: v$transaction.cr_gets
    ... Is it all consistent gets for the transaction? ... that required rolling back a change from the undo segment listed in the ... So is this all the logical I/O, or just the logical I/O needed ...
    (comp.databases.oracle.server)
  • Re: buffer cache and Rollback
    ... specific RBS specified in the transaction slot of the updating transaction, ... layer of the onion by reconstructing read consistent images until the block ... A rollback/undo block is just another block, if it's in the buffer cache ...
    (comp.databases.oracle.server)
  • Re: v$transaction.cr_gets
    ... Jonathan Lewis wrote: ... Is it all consistent gets for the transaction? ... So is this all the logical I/O, or just the logical I/O needed ...
    (comp.databases.oracle.server)
  • Re: Undo
    ... consistent gets from cache ... transaction tables consistent reads - undo records applied ... Below is the doc from oracle in the performance tuning guide on ... This is called delayed block cleanout. ...
    (comp.databases.oracle.server)
  • Re: v$transaction.cr_gets
    ... Is it all consistent gets for the transaction? ... that required rolling back a change from the undo segment listed in the ... So is this all the logical I/O, or just the logical I/O needed ...
    (comp.databases.oracle.server)