Displaying Current SGA setting

SQL> show SGA
Total System Global Area 925966448 bytes
Fixed Size 454768 bytes
Variable Size 494927872 bytes
Database Buffers 429391872 bytes
Redo Buffers 1191936 bytes
SQL> show parameter db_block_size
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_block_size integer 8192
SQL> show parameter db_block_buffers
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_block_buffers integer 52416
SQL> show parameter buffer_pool
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
buffer_pool_keep string
buffer_pool_recycle string
SQL> show parameter sga_max_size
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
sga_max_size big integer 925966448
SQL> show parameter cache_size
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_cache_size big integer 0
SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
statistics_level string TYPICAL
SQL> show parameter db_block_buffers
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_block_buffers integer 52416
SQL> show parameter db_block_size
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_block_size integer 8192
Setting up DB_CACHE_ADVICE AND STATISTICS_LEVEL
SQL> alter system set DB_CACHE_ADVICE=ON;
alter system set DB_CACHE_ADVICE=ON
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is
invalid
ORA-00381: cannot use both new and old parameters for buffer cache size
specification
SQL> alter system set statistics_level='TYPICAL';
System altered.
Deleting old SGA Parameter
SQL> alter system reset buffer_pool_keep scope=spfile sid='*';
alter system reset buffer_pool_keep scope=spfile sid='*'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE
SQL> alter system reset buffer_pool_recycle scope=spfile sid='*';
alter system reset buffer_pool_recycle scope=spfile sid='*'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE
SQL> alter system reset db_block_buffers scope=spfile sid='*';
System altered.
Set new SGA Parameter
SQL> alter system set sga_max_size=1612262112 scope=spfile;
System altered.
SQL> alter system set db_cache_size=780140544 scope=spfile;
System altered.
Setting Statistical level - ALL or TYPICAL
SQL> alter system set statistics_level='TYPICAL' scope=spfile;
System altered.
Restarting Oracle
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1620650740 bytes
Fixed Size 457460 bytes
Variable Size 838860800 bytes
Database Buffers 780140544 bytes
Redo Buffers 1191936 bytes
Database mounted.
Database opened.
SQL> show sga
Total System Global Area 1620650740 bytes
Fixed Size 457460 bytes
Variable Size 838860800 bytes
Database Buffers 780140544 bytes
Redo Buffers 1191936 bytes
SQL> show parameter sga_max_size;
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
sga_max_size big integer 1620650740
SQL> show parameter db_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_cache_size big integer 780140544
SQL> show parameter db_block_buffer
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
_db_block_buffers integer 93093
db_block_buffers integer 0
SQL> show parameter buffer_pool_keep
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
buffer_pool_keep string
SQL> show parameter buffer_pool
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
buffer_pool_keep string
buffer_pool_recycle string
SQL> show parameter db_block_size;
NAME TYPE VALUE
------------------------------------ ----------- ----------------------
db_block_size integer 8192