Oracle shared memory segments & GH regions

From: Antonio Gonzalez (agonort@yahoo.es)
Date: Thu Mar 16 2006 - 15:56:58 EST


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 @ 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



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:50:29 EDT