Remember too, if people are using Forms or other GUI tools to connect,
sometimes they open up two or three separate sessions. Designer does that,
I think.
The amount of memory server side by each connection depends on the tool
used, plus on the tools' version. I noticed that there were differences
from version to version, so you almost have to test it yourself to see how
much memory is used by default for each tool. Then (not sure about this) I
think that the amount increases depending on the result sets that have to be
transmitted back and forth.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst�mes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Rahul [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 3:06 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: how much ram per oracle process?
i guess the SGA size is also included in the SZ
> ----------
> From: Henry Chan[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, June 01, 2001 5:59 AM
> To: LazyDBA.com Discussion
> Subject: how much ram per oracle process?
>
> Environment: Sun 2.7, Oracle 8.1.6.3, 2Gig RAM
>
> I issued ps -elf to see how much memory each oracle server process
was
> using.
> The SZ column for each oracle process was approximately 47175.
There are
> 112
> connections.
> This is over 5Gig of virtual memory used.
> 1) is this an accurate indication of how much memory each oracle
process
> is
> using?
> 2) why it is so large? What determines how much memory is used?
>
> HenryC
>
>
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
[EMAIL PROTECTED]
> To subscribe: send a blank email to
[EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
