System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. 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>