| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Size of Oracle server processes
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...
> 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 <Tim_at_SageLogix.com> 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
> >
> >
> >
> >
> >
> >
> >
> >
> --------------------------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim_at_SageLogix.com 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: ListGuru_at_fatcity.com (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).Received on Wed Jul 17 2002 - 11:38:42 CDT
 |
 |