Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Select name, block_size, current_size from v$buffer_pool

SQL> SQL> alter system set db_keep_cache_size=2M; System altered. SQL> SQL> select name, block_size, current_size from v$buffer_pool; KEEP                       8192            4 DEFAULT                    8192          164 2 rows selected. SQL>