Re: Oracle 8i eats memory !!!

On 21 May 1999 12:02:23 +1000, "Barry" <odbc_at_mailexcite.com> wrote:

>To sum up, a 8.0.5 DB with a 6MB SGA acquires a shared memory segment
>about the same size. convert it to 8.1.5 and it will grab around 26Mb
>
>Lets see, a small development server, 6 databases with small 5 to 6 MB SGAs
>now grab an EXTRA 20Mb each - 6 x 20MB = 120MB !
>Watch your development box crash and burn !
>
>I know of places with over 10 databases so there goes 200MB !
>
>Anybody else found this ...
>
>Oracle has let me done VERY BADLY .... Support are stumped...
>
>

Hello,

please keep in mind, that shared memory means shared memory. The process list displays the amount of memory for each process but it does not check if it is shared memory or not. If you are running six processes which all use the same chunk of shared memory then the output of the ps command will show you six times the effective memory in use.
Maybe there is a tool on your machine to display the memory addresses of the chunks the processes have in use. You will see, that they mostly use all the same shared segment(s).

On hp unix you can use glance, but i dont know what Solaris tools exists.

Fred Stojentin Received on Fri May 21 1999 - 04:18:18 CDT