Oracle shared memory segments & GH regions

From: Antonio Gonzalez <agonort_at_yahoo.es>
Date: Thu, 16 Mar 2006 21:56:58 +0100 (CET)

Tru64 v5.1B PK4
Cluster of two GS1280 with 10GB RAM & 4 CPUs
4 CPU => 4 RADs
Each region rad_region = 1280
4 * 1280 = 5 GB

Oracle 9.2 with SGA of 4.8 GB

After db startup we see in ipcs -a that Oracle has
taken 3 segments:
- first 4 GB
- second 800 MB
- there is another ... A small one for the listener I
think

How can I check that both segments came from GH
regions ??
Why Oracle picks up 2 different segments for SGA
instead of one ??

Is there any parameter that control the maximum size
of a shared segment ??

TIA
Antonio González

e-Mail antonio.gonzalez _at_ terra.es



                
______________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
Received on Thu Mar 16 2006 - 20:58:43 NZDT

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