当你查询性能视图的时候遇到科学计数法..._sql fm99999999999999999999-优快云博客

本文链接：https://blog.youkuaiyun.com/DBAdream/article/details/9001385

本文介绍了如何通过Oracle数据库的v$pgastat视图查看程序全局区(PGA)的内存使用情况，并提供了避免显示科学计数法的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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