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

Stephane,

I have passed on your idea to my developers. I am now suggesting to them that they use local snapshots refreshed either by a button on a form or by a regular job or use an array fetch as you have suggested.

Thanks
Hemant
At 09:58 AM 16-04-03 -0800, you wrote:
>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).

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