Re: Few questions for experts

There is no logical or implementation reason why a single transaction cannot last several - but there are all sorts of side-effects that you may not be prepared for.

Rather than going into a list of all the hazards you face, can you give us some indication of what could happen in the real world that would correctly translate into a requirement for a database transaction remaining uncommitted for several days ? At first sight it seems like you are heading for a design error.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Jadranko Lucic wrote in message <9bk4tq$bpt$1_at_fstgss02.tu-graz.ac.at>...


>Hi,

>Current situation is that I have created multi-user client application that

>access to oracle via ADO (over OLEDB) using (so called) micro transaction

>(commit is issued after every DML statement).

>Now, I got a request to implement solution where transaction can let even

>several days. On the end of work application user would have possibility to

>choose either to save (commit) or to cancel (rollback) its work. Now I have

>some questions:

>1. Did anyone have similar request and if so, how it is solved?

>2. Does Oracle have something like timeout duration for transaction

>(connection)? How long transaction can take? Forever!?

>3. What about rollback segment? How big it should be in this case?

>4. Is there any other oracle DB parameters that have to be changed for this

>purpose?

>5. How long oracle locks on table rows can be? Forever!?

>6. How can I issue “Savepoint” from client side application or do a

>“Rollback” to some particular Savepoint also from client side application?

>Is it possible at all?

>7. Is Rollback statement issued automatically if any oracle error appeared

>inside of transaction?

>8. Is there any way that rollback statement is issued without user

>interaction or knowledge (by Oracle DB itself under some condition)?

>

>Thanks for help

>

>

>--

>_________________________

>dipl. ing. Jadranko Lucic

>AVL Zagreb

>tel:++385 1 6551117

>jadranko.lucic_at_avl.com

>_________________________

>

>