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 1. Use sqlnet.expire_time to deconnect session being idle x minutes 2. 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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
