Home » RDBMS Server » Server Administration » SGA_MAX_SIZE_
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
Previous Topic: how to create a data base
Next Topic: Dropping Tablespace and datafiles
Goto Forum:
  


Current Time: Mon Dec 05 14:48:20 CST 2016

Total time taken to generate the page: 0.16092 seconds