Oracle-L: 2-phase commit queries and the Web Development Toolkit

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Fri, 19 Jul 2002 11:28:31 -0800
Message-ID: <F001.0049CEA0.20020719112831@fatcity.com>

Some developers here ran into a bit of a problem, when they submit queries via db link the transactions always end up as 2-phase commit transactions.

This impacts our production server, because if one side cuts the connection entries remain in dba_2pc_pending. Result is that the production db keeps trying to re-submit these queries, to conclude the transactions.

Oracle has told me probably they need to put SET TRANSACTION READ ONLY before every query that goes through a db link.

I don't know if that is a practical solution for pages built using the Web Development Toolkit.

Another possible solution (?) might be to set the target tablespace to be READ ONLY. Has anyone else run into this situation? Have you found another workaround for this?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Fri Jul 19 2002 - 14:28:31 CDT