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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dedicated/shared server mode

Re: dedicated/shared server mode

From: johan Eriksson <johan.eriksson_at_bossmedia.se>
Date: Tue, 17 Jan 2006 08:25:28 +0100
Message-Id: <1137482728.1553.31.camel@erijoh.ad.bossmedia.se>


Could be better views to look for this, but v$session reports what each session has.

select username, server, status from v$session

/Johan

On Tue, 2006-01-17 at 12:41 +0530, Onkar N Tiwary wrote:
> Hi,
>
> I just wanted to know the mode of the database if its a dedicated or
> shared server mode. which data dictionary shall i use?????

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 17 2006 - 01:25:21 CST

Original text of this message

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