Page History

...

• Checking MEM_MAX_DB_SIZE

  Code Block
  language sql
  iSQL> SELECT value1/32/1024 FROM v$property WHERE name = 'MEM_MAX_DB_SIZE'; VALUE1/32/1024 : 32768 1 row selected.

  The above example shows the maximum number of pages that can be used (It is divided by 32 as the size of one page is 32K).
• Checking Usage

  Code Block
  language sql
  iSQL> SELECT space_name, maxsize/32/1024, alloc_page_count FROM v$mem_tablespaces; SPACE_NAME : SYS_TBS_MEM_DIC MAXSIZE/32/1024 : 4294967295 ALLOC_PAGE_COUNT : 129 SPACE_NAME : SYS_TBS_MEM_DATA MAXSIZE/32/1024 : 4294967295 ALLOC_PAGE_COUNT : 29313 SPACE_NAME : MEM_TBS MAXSIZE/32/1024 : 3200 ALLOC_PAGE_COUNT : 3201 3 rows selected.

  1. The above example shows the current usage of the memory tablespace. There are 32,643 pages allocated in total.

2. For SYS_TBS_MEM_DIC and SYS_TBS_MEM_DATA, they have not reached MAXSIZE but the error has occurred because the sum of all the memory tablespaces has almost reached MEM_MAX_DB_SIZE.

...