Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shared v.s. dedicated mode

Re: shared v.s. dedicated mode

From: Snewber <snew_at_snew.com>
Date: Fri, 01 Jul 2005 14:10:11 +1000
Message-ID: <da2fn3$2ens$1@bunyip2.cc.uq.edu.au>


Hi Sybrand,

you mentioned that

 > In order for mts to become active, the listener must have been started  > *prior* to the database.

Does this mean that if the database is running and you shutdown and then start up the listener, that you cannot have shared server (formerly MTS in 8i) connections to the database?

Sybrand Bakker wrote:
> On Thu, 30 Jun 2005 12:31:59 -0400, Jeff Kish <jeff.kish_at_mro.com>
> wrote:
>
>

>>Hi.
>>
>>
>>2 questions here...I'm working write not with Oracle 9.2.01
>>a) I wanted to see the difference between a database instance that is
>>installed as 'dedicated' v.s. 'shared'. So I installed two instances, choosing
>>'shared' for one and 'dedicated' for the other. But when I go into enterprise
>>manager console, and click on each instance, they both say in the TNS
>>Descriptor on the page on the right, (SERVER=DEDICATED). So.. isn't this where
>>it should say either 'DEDICATED' or 'SHARED'? If not, how can I tell the
>>difference?
>>
>>b)I'm seeing a deadlock problem at a customer site using Oracle 9.2.0.1 64 bit
>>on AIX. I've never seen this before with the same software on a variety of
>>other systems. Any chance that the above setting has anything to do with it?
>>
>>
>>Thanks

>
>
> a) Your instance will accept shared sessions when the mts_dispatchers
> parameter is set (the dispatchers parameter in 9i).
> The value of the dispatchers parameter is the only difference between
> a 'shared' and a 'dedicated' instance.
> In order for mts to become active, the listener must have been started
> *prior* to the database.
> There are certain operations (like the shutdown command) that for
> obvious reasons require a dedicated session.
> OEM takes this into account.
> There is a server column in v$session which will show what type of
> connection you have.
>
> b) Has completely nothing to do with it.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Thu Jun 30 2005 - 23:10:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US