| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Resend :: OPEN_LINKS -- how do you define a policy
This error u probably getting b'cuaze, your session is exceeding the max limit set in ini.ora file for parameter:open_links and open_links_per_instance.
set these parameters according to ur requirement and license.
With Regards,
Manoj Kumar Jha
C-56 , Phase-2
NOIDA -201305, UP(INDIA)
Tata Consultancy Services
Ph No: (+91-120) 4461001 ext : 1037 (Off.)
Mobile No : 9810090974
A transcendentalist engaged in auspicious activities does not meet with destruction either in this world or in the spiritual world; one who does good, is never overcome by evil.
"Stephane Paquette"
<stephane.paquette_at_standa To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
rdlife.ca> cc:
Sent by: root_at_fatcity.com Subject: RE: Resend :: OPEN_LINKS -- how do you define a policy
04/16/03 04:38 AM
Please respond to
ORACLE-L
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: ManojKr Jha INET: jmanoj_at_delhi.tcs.co.in 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).Received on Wed Apr 16 2003 - 02:28:49 CDT
 |
 |