Useful shortcuts for vi editor

Showing posts with label pga. Show all posts
Showing posts with label pga. Show all posts

Monday, 13 October 2014

How to see PGA size per oracle session?

Please execute following SQL lines as "sys";

select
    1048576+a.value+b.value   pga_size
from
   v$parameter a,
   v$parameter b
where
   a.name = 'sort_area_size'
and
   b.name = 'hash_area_size';