[20131108]sqlplus参数NUMWIDTH.txt

http://space.itpub.net/267265/viewspace-746988/

曾经写过一篇blog改变show parameter control_files的显示宽度，顺便提到了show sga的显示：

SQL> show sga
Total System Global Area 1.2885E+10 bytes
Fixed Size                  2105920 bytes
Variable Size            1660947904 bytes
Database Buffers         1.1207E+10 bytes
Redo Buffers               14667776 bytes

--实际上设置的数字的显示宽度，可以简单的设置参数NUMWIDTH，增加数字的显示宽度,这个是昨天看别人干活学到的！
--测试如下：

SYS@test> @ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SYS@test> show NUMWIDTH
numwidth 10
--缺省宽度10.

SYS@test> show sga
Total System Global Area 1603411968 bytes
Fixed Size                  2228784 bytes
Variable Size             922750416 bytes
Database Buffers          671088640 bytes
Redo Buffers                7344128 bytes

SYS@test> set  NUMWIDTH 8
SYS@test> show sga
Total System Global Area   1.60E+09 bytes
Fixed Size                  2228784 bytes
Variable Size              9.23E+08 bytes
Database Buffers           6.71E+08 bytes
Redo Buffers                7344128 bytes

--只要增加 NUMWIDTH=12,显示就不是科学记数法了。

SYS@test> set  NUMWIDTH 12
SYS@test> show sga
Total System Global Area   1603411968 bytes
Fixed Size                    2228784 bytes
Variable Size               922750416 bytes
Database Buffers            671088640 bytes
Redo Buffers                  7344128 bytes