|
********************************************************************************************
关于SGA中log_buffer的大小:
SQL> select * from v$sgastat where name='log_buffer';
POOL |NAME | BYTES
-----------|--------------------------|----------
|log_buffer | 656384
SQL> show sga
Total System Global Area| 219223120|bytes
Fixed Size | 451664|bytes
Variable Size | 184549376|bytes
Database Buffers | 33554432|bytes
Redo Buffers | 667648|bytes
SQL> show parameter log_buffer
NAME |TYPE |VALUE
------------------------------------|-----------|------------------------------
log_buffer |integer |524288
三个值完全不同,是怎么回事?
*********************************************************************************************** |
|