Hello,
On Friday August 22nd I wrote about a problem with Oracle 7.3.2 and 32
Kb db blockss (original question at the end of this summary). After
looking at the archives, news on comp.databases.oracle it appears that
no specific problem exists on this. DEC support told me that the
shared memory is in fact accounted for in the RSS field of the 'ps'
command.
Joseph Dunleavy pointed me at the Oracle script 'utlestat' to check the
delays in the DB. It had already been done by our team of DBA's. They
went back to a 8 Kb db block size. Stats from days before the migration
to 32 Kb, and after the return to 8 Kb don't show any difference in
memory utilisation. To me it didn't change a thing.
Thanks to :
Joseph M. Dunleavy DUNLEAVJ_at_labs.wyeth.com
Guy Dallaire dallaire_at_total.net
>>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.
>>
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 Wed Sep 10 1997 - 13:14:50 NZST