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

We have application A and application B. Users from application A position the cursor on a client and then press a button that run a stored proc in B. In B, the stored proc gathers the client's data and pass it as an array back to application A that shows the data on the screen. Application A close the dblink.

Since we have 300 users, I show the dev team to close the database links as I do not want many idle connections on application B server and use ressources for nothing.

Stephane

-----Original Message-----
Chitale
Sent: Wednesday, April 16, 2003 12:44 PM To: Multiple recipients of list ORACLE-L

You mean that the application provides a "button" to the user which refreshes the snapshot ? That's something I can take back to the team.

The team wanted to go ahead with dblinks and online querying across them because "the data fetched over the link is very little .. if we create a local table, we need to setup and maintain a job to refresh the table ... the users need real-time data". One issue I pointed out to them was that if any one of the remote databases was down, the form would fail.

Hemant

At 03:08 PM 15-04-03 -0800, you wrote:
>Can't you just snapshot the data to your local database on a daily basis ?
>
>You can use a dblink, copy the data then close the dblink.
>I just learn that 2 weeks ago on this list, it's a cool feature and it's
>qlready running in our production database. I have 300 users who can push
>the blue button (developper fantasy) that called a remoted stored proc and
>then close the dblink.
>
>Stephane
>
>-----Original Message-----
>Chitale
>Sent: Tuesday, April 15, 2003 12:28 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: stephane.paquette_at_standardlife.ca

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