Memory or not not memory, this is the question

From: <LBOUCHAR_at_bouyguestelecom.fr>
Date: Fri, 22 Aug 1997 13:39:00 +0100

Hello there,

        We've been having very strange problems since we migrated our Oracle
7.3.2 Database from 8Kb block to 32Kb (DU 3.2G, ASE 1.3). Performance
Advisor tells me that processes are not bigger than before but when we
do a 'ps avx' we see that the Resident Set Size (RSSIZE) seems bigger
than before.

        I'm about certain that 'ps' does a sum of the physical memory used by a
process and of the memory segments used by the process (it was told to
me by a DEC support engineer a while ago). So now it looks like Oracle
is not handling its Shared Global Area (SGA) which uses big memory
segments the same way with 8Kb blocks and 32Kb blocks.

        Sorry if it is on the fringe between Oracle and DU but I taught that
someone might have encountered the same kind of problem.

Will summarize,

                TIA
                                        Bye..
                                                ...Louis
+-----------------------------------------------------------------------
---- -------------------------------------------------+
 | | Louis Bouchard |
 | J'aimes que ca cesse quand c'est fini. |
lbouchar_at_bouyguestelecom.fr |
 | Quand ca recommence, ca me scie. | Ingenieur Systeme Unix |
 | R. Ducharme | Bouygues Telecom |
+-----------------------------------------------------------------------
---- -------------------------------------------------+
Received on Fri Aug 22 1997 - 14:08:31 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:36 NZDT