当你查询性能视图的时候遇到科学计数法...

来源：互联网发布：7723java游戏编辑：程序博客网时间：2024/05/16 08:58

SQL> select * from v$pgastat;

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