Home » RDBMS Server » Performance Tuning » What is size of the INSTANCE
What is size of the INSTANCE [message #65970] Wed, 09 February 2005 05:53 Go to next message
Vivek Vijai
Messages: 67
Registered: April 2004
Member
How can i get the total memory allocated to the INSTANCE.
Actually i want to resize PGA_AGGREGATE_TARGET

which shud be TOTAL SIZE oF INSTANCE
MINUS
SGA_MAX_SIZE

Please let me know.

Thanks in advance

Vivek
Re: What is size of the INSTANCE [message #65975 is a reply to message #65970] Mon, 14 February 2005 02:31 Go to previous message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

You can get the instance's size from V$SGA or V$SGASTAT. Alternatively, use the "SHOW SGA" command:

SQL> conn / as sysdba
Connected.
SQL> show SGA

Total System Global Area  357091568 bytes
Fixed Size                   731376 bytes
Variable Size             150994944 bytes
Database Buffers          204800000 bytes
Redo Buffers                 565248 bytes


BTW: Before increasing PGA sizing, look at the PGA Advisor. Also, ensure you don't increase memory to the point where your system starts swapping.

Best regards.

Frank
Previous Topic: open_cursors value is exceeded
Next Topic: Warning from "SYSTEM.DBMS_APPLICATION_INFO" package
Goto Forum:
  


Current Time: Tue Sep 22 07:37:05 CDT 2020