How to find SGA and PGA values

Here is the way to find to SGA and PGA Values

SQL> select * from v$sga;

NAME                      VALUE
-------------------- ----------
Fixed Size           ##########
Variable Size        ##########
Database Buffers     ##########
Redo Buffers         ##########

SQL> show sga;

Total System Global Area  530288640 bytes
Fixed Size                  2256864 bytes
Variable Size             394264608 bytes
Database Buffers          125829120 bytes
Redo Buffers                7938048 bytes



SQL> select max (pga_used_mem) / 1024/1024 M from v$process;

         M
----------

123.972422

SQL> show parameter pga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ----------------

pga_aggregate_target                 big integer 0

SQL> select * from v$pgastat;

NAME                      VALUE UNIT

-------------------- ---------- --------------------

aggregate PGA target ########## bytes

 parameter

aggregate PGA auto t ########## bytes

arget

global memory bound  ########## bytes

total PGA inuse      ########## bytes

total PGA allocated  ########## bytes

maximum PGA allocate ########## bytes

d

NAME                      VALUE UNIT

-------------------- ---------- --------------------

total freeable PGA m ########## bytes

emory

process count        ##########

max processes count  ##########

PGA memory freed bac ########## bytes

k to OS

total PGA used for a ########## bytes

uto workareas

NAME                      VALUE UNIT

-------------------- ---------- --------------------

maximum PGA used for ########## bytes

 auto workareas

total PGA used for m ########## bytes

anual workareas

maximum PGA used for ########## bytes

 manual workareas

over allocation coun ##########

NAME                      VALUE UNIT

-------------------- ---------- --------------------

t

bytes processed      ########## bytes

extra bytes read/wri ########## bytes

tten

cache hit percentage ########## percent

recompute count (tot ##########

al)

19 rows selected.