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

Please let me know.

Thanks in advance

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: 4578
Registered: April 1998
Senior Member

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

SQL> conn / as sysdba
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.

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

Current Time: Thu Feb 22 02:43:53 CST 2024