select name, block_size, current_size from v$buffer_pool : v_buffer_pool « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. v_buffer_pool

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>
SQL>

   
    
  

Related examples in the same category