OS환경 : Oracle Linux6.8(64bit)
DB 환경 : Oracle Database 11.2.0.4
방법 : sqlplus 에서 show sga 입력 시 아래와 같이 나오는 경우 해결 방법(set numwidth)
1 2 3 4 5 6 7 | SQL> show sga Total System Global Area 6.3E+08 bytes Fixed Size 2255832 bytes Variable Size 3.8E+08 bytes Database Buffers 2.4E+08 bytes Redo Buffers 3313664 bytes |
set numwidth를 사용하여 늘려준다
1 2 3 4 5 6 7 | SQL> set numwidth 15 SQL> show sga Total System Global Area 626327552 bytes Fixed Size 2255832 bytes Variable Size 377488424 bytes Database Buffers 243269632 bytes Redo Buffers 3313664 bytes |
정상적으로 출력되는 모습
참조 : https://onkartiwary.wordpress.com/2013/11/13/display-big-numbers-in-sqlplus/
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| Resize operation completed for file# n 이란 (0) | 2018.11.08 |
|---|---|
| ORA-29275: partial multibyte character (0) | 2018.10.29 |
| Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter. (0) | 2018.10.24 |
| ORA-09925: Unable to create audit trail file (0) | 2018.10.15 |
| ORA-29746: Cluster Synchronization Service is being shut down. (0) | 2018.10.11 |