[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