Databases Reference
In-Depth Information
We can size the PGA using Oracle Enterprise Manager, following steps 1 through 4, where
we get the following page, allowing us to size the PGA:
As for System Global Area (SGA), we have the ADVICE button to see the performance
improvement that could be obtained by varying the PGA size.
In step 5, we query for the parameters related to cursors. The results are shown in the
following screenshot:
In step 6 and step 7, we query the statistics to see the space used by the current session
and the maximum UGA space used by all users, respectively.
