(no subject)

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Thu, 23 Nov 2000 21:56:20 +0200
Message-Id: <10499.105769@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0528_01C05598.36AA3C10 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear DBAs !
Some more newbie's questions :

Are concurrent sessions , concurrent users & concurrent connections = the same ( in a dedicated server environment ) ?
How can i calculate memory & other resources occupied by = CURRENT/CONCURRENT users/connections/sessions ?
How can i calculate the maximum number of CONCURRENT = users/connections/sessions that my DB allows and is able to handle ?=20
Which init.ora settings affect this ? What are the limits ?
How can i monitor the number of concurrent users/connections/sessions = ?

I'm running 8.1.5 on NT and we're migrating to 8.1.6 in Windows2000 = later this week and in a month or so we'll have more DBs on UNIX ( SUN & = HP-UX)=20

Many thank in advance .

------=_NextPart_000_0528_01C05598.36AA3C10 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear DBAs !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Some more newbie's questions =
:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>- </FONT><FONT face=3DArial =
size=3D2>Are concurrent=20
sessions , concurrent users & concurrent connections the same ( in a =

dedicated server environment ) ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>- How can i calculate memory & =
other resources=20
occupied by CURRENT/CONCURRENT users/connections/sessions ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>- How can i calculate the maximum =
number of =20
CONCURRENT users/connections/sessions  that my DB allows and is = able to=20
handle ? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>- Which init.ora settings affect this =
?  What=20
are the limits ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>- How can i monitor the number of =
concurrent=20
users/connections/sessions ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm running 8.1.5 on NT and we're =
migrating to=20
8.1.6 in Windows2000 later this week and in a month or so we'll have = more DBs on=20
UNIX ( SUN & HP-UX) </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thank in advance .</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
Received on Thu Nov 23 2000 - 13:56:20 CST