Home » Infrastructure » Linux » RAM size
RAM size [message #236019] Tue, 08 May 2007 13:01 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sri


Plz help me know command to find "how much RAM is oracle using"

in redhat Linux(advanced 3.0 version)

Advanced Thanx.
Re: RAM size [message #237101 is a reply to message #236019] Sat, 12 May 2007 02:05 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
SQL> break on report
SQL> compute sum of VALUE on report
SQL> select * from v$sga;

NAME                      VALUE
-------------------- ----------
Fixed Size              1218292
Variable Size          75499788
Database Buffers       83886080
Redo Buffers            7168000
                     ----------
sum                   167772160


PS: values are in bytes.
Re: RAM size [message #237706 is a reply to message #237101] Tue, 15 May 2007 08:58 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member


-thank u sir
Previous Topic: Oracle 10g on Fedora Core 4
Next Topic: Linux command to find platform
Goto Forum:
  


Current Time: Thu Apr 18 07:42:38 CDT 2024