From oracle-l-bounce@freelists.org Tue Jan 17 08:34:13 2006 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id k0HEYD7p021707 for ; Tue, 17 Jan 2006 08:34:13 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id k0HEXUg7021568 for ; Tue, 17 Jan 2006 08:34:07 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A699827AFA3; Tue, 17 Jan 2006 09:30:38 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02121-09; Tue, 17 Jan 2006 09:30:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F70627ADF4; Tue, 17 Jan 2006 09:30:38 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 17 Jan 2006 09:30:29 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 901C027AE7B for ; Tue, 17 Jan 2006 09:30:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02088-10 for ; Tue, 17 Jan 2006 09:30:29 -0500 (EST) Received: from smtp14.singnet.com.sg (smtp14.singnet.com.sg [165.21.6.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ABB6627AD01 for ; Tue, 17 Jan 2006 09:30:21 -0500 (EST) Received: from chitale.singnet.com.sg (bb220-255-255-145.singnet.com.sg [220.255.255.145]) by smtp14.singnet.com.sg (8.13.5/8.13.4) with ESMTP id k0HEU5B2029298; Tue, 17 Jan 2006 22:30:08 +0800 Message-Id: <6.2.1.2.0.20060117222702.01fe3cb0@pop.singnet.com.sg> Date: Tue, 17 Jan 2006 22:30:03 +0800 To: onkarnath.tiwary@gmail.com, Oracle-L From: Hemant K Chitale Subject: Re: dedicated/shared server mode In-Reply-To: References: <1137482728.1553.31.camel@erijoh.ad.bossmedia.se> <6e9345580601170302n5d86aa16j4913bca7f6991172@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/html; charset="us-ascii" X-archive-position: 30089 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-To: hkchital@singnet.com.sg X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org
You can have both DEDICATED and SHARED connections concurrently.

Some environments with SHARED Servers also use DEDICATED connections for Administrative jobs or Long Running Batch Jobs.

Read up on the "SERVER=DEDICATED" parameter that can be specified in the client-side TNSNAMES.ORA file.

Hemant

At 07:18 PM Tuesday, you wrote:

than cheng. You are right i can check if the system supports shared server or not but my main question is to find the mode(shared/dedicated) for the database. Say DB1 is up and running and i just have to decide the mode of the database is the db is in :

1) archive /no archive log mode -- quite easy to check and i have
2) dedicated/shared --- confused for how to check this one

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

-- http://www.freelists.org/webpage/oracle-l