| SGA_MAX_SIZE_ [message #206736] |
Fri, 01 December 2006 05:25 |
fabat
Messages: 1
Registered: December 2006
|
Junior Member |
|
|
I have one solaris server with oracle 9.2.0.6
one of these instances , I've seen some top process in unix like this:
$ top
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
16559 oracle 1 0 0 1093M 29M sleep 115.5H 9.29% oracle
that is using almost 1G
but , my parameters are configuration like this:
SQL> select * from v$sga
2 ;
NAME VALUE
-------------------- ----------
Fixed Size 732736
Variable Size 922746880
Database Buffers 134217728
Redo Buffers 2203648
SQL> show parameter sga_max_size
NAME TYPE VALUE
------------------------------------ ----------- -----------
sga_max_size big integer 1050408620
I'd like to know that total instance is allocated by using the sga_max_size and the best way to find out a real memory usage for instances into the unix box
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
