Oracle-L: Database link and connection

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Fri, 04 Apr 2003 13:53:55 -0800
Message-ID: <F001.0057AE84.20030404135355@fatcity.com>

Hi all,

Oracle 8172 with dedicated connections.

I've not played that much with database links.

Users from application A will accessed data from another database B with a dblink.
Real time access is needed so no snapshot, tables and stored proc are accessed.

There are 300 users in application A so that means that they can open 300 connections in database B.

Is there a way to not used that many connections on database B ? If not, I guessed I have 2 choices

Use sqlnet.expire_time to deconnect session being idle x minutes
Use a job that kills session with the dblink username after x minutes being idle

Any other choices ?

TIA Stephane Paquette
Administrateur de bases de données
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
stephane.paquette_at_standardlife.ca

--

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). Received on Fri Apr 04 2003 - 15:53:55 CST