What is size of the INSTANCE [message #65970] |
Wed, 09 February 2005 05:53  |
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  |
Frank Naude
Messages: 4595 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
|
|
|