topic Re: Oracle shadow process memory in Operating System - HP-UX

Oracle shadow process memory

Ian Lochray — Mon, 14 Apr 2003 13:42:22 GMT

We have an application that uses dedicated Oracle shadow processes. Currently the application used Oracle 8.1.7.3. I have built and run the same application code on Oracle 9.2.0.3 but I have noticed that the Oracle shadow processes use double the memory that they used at 8.1.7.3. I have tried playing with pga_aggregate_target but this had made no difference.
I have logged a call with Oracle but wanted to know if anyone out there had seen the same thing.

Re: Oracle shadow process memory

Duncan Edmonstone — Mon, 14 Apr 2003 13:51:04 GMT

Wild guess...

is the 8.1.7.3 a 32-bit app, and 9.2.0.3 a 64-bit app?

Cheers

Duncan

Re: Oracle shadow process memory

Ian Lochray — Mon, 14 Apr 2003 13:56:07 GMT

Duncan,
although Oracle 9i is 64-bit only on HP-UX, the application I am using is still 32-bit and uses the Oracle 32 bit libraries in $ORACLE_HOME/lib32.
Even if the application was 64-bit, would it really lead to an Oracle shadow that is twice the size?

Re: Oracle shadow process memory

Duncan Edmonstone — Mon, 14 Apr 2003 14:24:03 GMT

Ian,

I don't know! Like I said I was just guessing... I'm sure a better mind than mine will be able to give you a better answer..

Sorry

Duncan

Re: Oracle shadow process memory

Gene Kornacki_3 — Mon, 14 Apr 2003 15:21:40 GMT

What method are you using to measure how much memory is being taken up by the processes in question?

Re: Oracle shadow process memory

Indira Aramandla — Tue, 15 Apr 2003 06:07:54 GMT

Hi,

You can measurement these using v$sesstat to look up pga and uga memory. This will give you a better estimate of memory increases per session across versions.

Its true that Oracle 8.1.7 needs more memory for the shadow processes.
In the case of an Oracle shadow process or foreground process the text segment will always be shared as it is the same program. The shadow process will have a shared segment, the SGA. This memory should only be counted for the first process.

Using pmap utility (pmap is a Solaris utility only), you can determine the following:

1)How much memory a process is using

2)How much of that memory is shared

You can also use the normal 'ps' utility.
This 'ps' utility will print out information about any process currently active on the system. Using 'ps' with the '-l' will cause 'ps' to print out the SZ field, which contains the virtual size of the process's non-text segments, measured in pages. While this figure is an accurate measure of the virtual memory being used by this process, it is not accurate if the process has attached a shared memory segment. This means that when sizing memory, you must subtract the size of the SGA from the virtual memory used by all of the Oracle background and shadow processes.

By using PMAP you can also see that the SGA is always part of the shared memory of a shadow process. This is normal. To get the real amount of memory always subtract the SGA. Determining the memory for the shadow processes of 8.1.7 this way will give you a good idea of your memory requirement. Otherwise you can use the following query to determine the sum of PGA and UGA memory which will also give you some idea on your total memory requirement:

compute sum of maxmem on report
break on report

select se.sid,n.name, max(se.value) maxmem
from v$sesstat se,v$statname n
where n.statistic# = se.statistic#
and n.name in ('session pga memory','session pga memory max',
'session uga memory','session uga memory max')
group by n.name,se.sid
order by 3
/

Further for reducing the memory required for the shadow processes you can use the init parameters SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE to some extent. These control the size of the UGA and PGA.

If you find your available memory is not sufficient to run a dedicated server you can very well go for MTS but at the cost of reduced performance of the application due to increased wait times.

Re: Oracle shadow process memory

Brian Crabtree — Tue, 15 Apr 2003 16:57:05 GMT

Ian,

Overall, the answer you are looking for is, "Yes, 9i takes up twice as much memory as 8i". This was also true in the change from 8.0 to 8i as well. I wouldn't worry about it to much, as the "ps -elf" command will show you the total amount of memory that the process is taking up, but this aso includes the shared memory that Oracle takes up as well.

Overall, I wouldn't worry about it to much, and would just keep an eye on available memory. Inrdu posted well on how to reduce the pga and sga as needed.

Brian

Re: Oracle shadow process memory

Yildiz_1 — Fri, 19 Mar 2004 05:39:26 GMT

Oracle 9i documentation says:

With PGA_AGGREGATE_TARGET, sizing of work areas for all dedicated sessions is automatic and all *_AREA_SIZE parameters are ignored for these sessions.

I have moved from Oracle 7 to 9i and it needs 2-3 times more Memory.

Re: Oracle shadow process memory

Nicolas Dumeige — Fri, 19 Mar 2004 07:58:54 GMT

Look at metalink Note:174555.1
UNIX: Determining the Size of an Oracle Process

As for the PGA_AGGREGATE_TARGET, Oracle will allocate min(5% PGA_AGGREGATE_TARGET, 100MB) to each process.

This rule is not enforced drasticaly, we've seen pga consumption per process far more than 100 Mo.

Re: Oracle shadow process memory

Bill Hassell — Fri, 19 Mar 2004 08:21:48 GMT

Just a note on using ps to examin process memory. ps -efl shows memory usage in pages (4k) which is not the most useful unit of measure for a sysadmin. Try this:

UNIX95= ps -u oracle -o vsz,pid,args | sort -rn

That shows the amount of memory used in Kbytes. To look at everything sorted by memory usage:

UNIX95= ps -eo vsz,pid,args | sort -rn | more

As mentioned, SGA (shared memory) is not counted because it really isn't counted for any single process.

Re: Oracle shadow process memory

Jakes Louw — Fri, 19 Mar 2004 08:26:57 GMT

Ian

Upgrading from 8.0.6.3 to 9.0.2.3, I saw exactly the same thing.
We are busy looking at SGA settings to see if we can reduce this usage, but it would appear that the background/shadow processes simply load more code into their stacks.

Re: Oracle shadow process memory

Hein van den Heuvel — Fri, 19 Mar 2004 09:31:19 GMT

Nitpicking...

>>Ian Lochray Apr 14, 2003 18:56:07 GMT
>>
>> Even if the application was 64-bit, would it really lead to an Oracle shadow that is twice the size?

The the shadow (server code) is running the Oracle executable and will be 64 bit. It will be independend of whether the application (client code) is 32 bit or not. They are seperated/connected by SQL*net.

Hein.