|
SQL>
SQL> select * from v$pgastat
2 where rownum < 50;
NAME VALUE UNIT
——————– ———- ————
aggregate PGA target 94371840 bytes
parameter
aggregate PGA auto t 68705280 bytes
arget
global memory bound 18874368 bytes
total PGA inuse 18112512 bytes
total PGA allocated 36039680 bytes
maximum PGA allocate 40627200 bytes
d
total freeable PGA m 0 bytes
emory
process count 26
max processes count 26
PGA memory freed bac 0 bytes
k to OS
total PGA used for a 0 bytes
uto workareas
maximum PGA used for 7386112 bytes
auto workareas
total PGA used for m 0 bytes
anual workareas
maximum PGA used for 530432 bytes
manual workareas
over allocation coun 0
t
bytes processed 433881088 bytes
extra bytes read/wri 0 bytes
tten
cache hit percentage 100 percent
recompute count (tot 13259
al)
19 rows selected.
SQL> –
|
Tags: Code, Oracle PL / SQL, pgastat, pgastat laquo System Tables Views laquo Oracle PL SQL, query the VPGASTAT dynamic view, System Tables Views, To check how the total PGA is being allocated by the instance
Posted in pgastat |
This entry was posted
on Saturday, July 4th, 2009 at 5:30 am and is filed under pgastat.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
