(no subject)

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Sat, 25 Nov 2000 10:26:05 +0200
Message-Id: <10501.105921@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0058_01C056CA.1E0FFA40 Content-Type: text/plain;

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

Dear DBAs !
I'm reposting this , cause nobody responded yet , so probably it didn't = reach U=20

Some more newbie's questions :

Are concurrent sessions , concurrent users & concurrent connections = the same ( in a dedicated server environment ) ? =20
How can i calculate memory & other resources occupied by = CURRENT/CONCURRENT users/connections/sessions ? =20
How can i calculate the maximum number of CONCURRENT = users/connections/sessions that my DB allows and is able to handle ?=20 =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 thanks in advance .

------=_NextPart_000_0058_01C056CA.1E0FFA40 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>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Dear DBAs !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I'm reposting this , cause nobody =
responded yet ,=20
so probably it didn't reach U </FONT></DIV>
<DIV> </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 thanks in advance=20
.</FONT></DIV></FONT></DIV></FONT></DIV></BODY></HTML> Received on Sat Nov 25 2000 - 02:26:05 CST