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... - 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: > > selectsid, serial#, username, osuser, process > > from v$session > > where paddr in (select addr from v$process > > where spid = > > ) > > Plug in the PID for the server process into > > "" 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) 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 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 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).
Re: Size of Oracle server processes
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: > selectsid, serial#, username, osuser, process > from v$session > where paddr in (select addr from v$process > where spid = > ) > Plug in the PID for the server process into > "" 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) 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 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 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).
Re: Size of Oracle server processes
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 = ) Plug in the PID for the server process into "" 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) 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 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 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!
Size of Oracle server processes
I have a question to ask regarding Oracle server process (oracle) 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 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 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!