Exactly. Each process is carrying two separate UGAs and PGAs in the server process's "heap" area, which is a data segment. Does HPUX have a "pmap" utility, as can be found in Solaris and Linux? It does a great job of breaking down a process into the distinct code and data segments. I don't know "glance" very well, so I can visualize what your seeing...
If you're inclined to test this effect, you can implement multiple connections using OCI or PRO*C in a test program. On Oracle8i software installs, there is an OCI demo program named "cdemoses.c" in the directory "$ORACLE_HOME/rdbms/demo" which creates two connections from the same program. I don't know exactly what it does, but it could be something to compile/link quick and see if the effect is duplicated... ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 7:28 AM > Tim, > I think your observation is correct, every Apps logon > does create two sessions. How is that affecting the > size of the server process? Do you mean the size is > the sum of the two sessions? In glance, most of the > memory size came out of the data segment of the > process. > Jos > > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > This is a > pure guess, and I don't have my own > > OraApps system to check it upon first, so this might > > be embarrassing, but here goes... > > > > Often I see 2 sessions started for every dedicated > > server process when Oracle Forms is in use with > > Oracle Apps, from R10.7 on up. I think the > > Jinitiator applet is creating the second session > > associated with the process. To verify this, you > > could try running the following query and see if it > > returns two rows instead of one: > > select sid, serial#, username, osuser, process > > from v$session > > where paddr in (select addr from v$process > > where spid = > > <oracleSID-processID>) > > Plug in the PID for the server process into > > "<oracleSID-processID>" where you are seeing the > > large RSS. If you do get two rows back from the > > query, then this might be an explanation for the > > increased size....? > > > > Hope this helps... > > > > -Tim > > ----- Original Message ----- > > From: Jos Someone > > To: Multiple recipients of list ORACLE-L > > Sent: Monday, July 15, 2002 1:18 PM > > Subject: Size of Oracle server processes > > > > > > I have a question to ask regarding Oracle server > > process (oracle<SID>) size. We have just installed > > Oracle Apps 11i, while monitoring the system using > > glance, I notice something strange, the oracle > > server processes - process which has a name > > oracle<SID> has a very big RSS size in glance, these > > processes were associated with the f60webmx > > processes. I was curious about the size of it, > > normally these processes are about 2-3M big. I did a > > quick test by logging on to the database using > > sqlplus and observe the size of the oracle server > > process, it showed a size of 2M. So why the > > oracle<SID> processes size is so big where they are > > assoicated with f60webmx, is it something special > > about them? Or the RSS size shown in glance is > > doubling up on something? > > > > Jos > > > > > > > > > > > > > > > > > -------------------------------------------------------------------------- ---- > > SOLD.com.au - Find yourself a bargain! > > > > http://www.sold.com.au - SOLD.com.au > - Find yourself a bargain! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Jos=20Someone?= > 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: Tim Gorman 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).
