PGA Size In Oracle

Onur ARDAHANLI

7 months ago

In today’s article, we will explain how we can find out the size of the PGA (Program Global Area) area in Oracle Database.

The size of the PGA area can be determined as follows:

1.It can be learned by querying the v_$pgastat view from TOAD.

2.It can be learned by executing the following query in Sql*Plus.

SQL> select NAME, VALUE, UNIT from v_$pgastat order by 2 desc;

1	SQL> select NAME, VALUE, UNIT from v_$pgastat order by 2 desc;