Resend :: OPEN_LINKS -- how do you define a policy

Resend ...

>Date: Wed, 09 Apr 2003 08:23:36 -0800
>Reply-To: ORACLE-L_at_fatcity.com
>From: Hemant K Chitale <hkchital_at_singnet.com.sg>
>Subject: OPEN_LINKS -- how do you define a policy
>
>
>
>A couple of developers are designing an application which queries about 5
>remote
>databases in a single form.
>In the development environment, they didn't actually create database links but
>copied the data into local "temp" tables.
>In the production environment, they set up database links, using the same
>synonynm
>names, and, of course, the form failed to compile, returning ORA-2020 "too
>many database links in use".
>
>Has anyone encountered serious issues with a higher OPEN_LINKS value ?
>What policy would you set on the usage of database links in a single session ?
>I am told that the amount of data fetched across the db-link will be "low".
>
>Hemant
>
>Hemant K Chitale
>My personal web site is : http://hkchital.tripod.com
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Hemant K Chitale
> INET: hkchital_at_singnet.com.sg
>
>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).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).