NAME VALUE UNIT
---------------------------------------------------------------- ---------- ------------
aggregate PGA target parameter 2.1475E+10 bytes
aggregate PGA auto target 1.9262E+10 bytes
global memory bound 1073741824 bytes
total PGA inuse 2386163712 bytes
total PGA allocated 2406360064 bytes
maximum PGA allocated 1.2785E+10 bytes
不让oracle使用科学计数法:
SQL>col value format 999999999999999999999999
SQL> select * from v$pgastat;
NAME VALUE UNIT
---------------------------------------------------------------- ------------------------- ------------
aggregate PGA target parameter 21474836480 bytes
aggregate PGA auto target 19269089280 bytes
global memory bound 1073741824 bytes
total PGA inuse 327317504 bytes
total PGA allocated 2694194176 bytes
maximum PGA allocated 12784621568 bytes
total freeable PGA memory 2354053120 bytes
或者:
SQL> select NAME,to_char(value ,'FM99999999999999999999') from v$pgastat;
NAME TO_CHAR(VALUE,'FM9999
---------------------------------------------------------------- ---------------------
aggregate PGA target parameter 21474836480
aggregate PGA auto target 19263255552
global memory bound 1073741824
total PGA inuse 352571392
total PGA allocated 2694194176
maximum PGA allocated 12784621568
total freeable PGA memory 2328756224