These statistics describe the amount and purpose of memory used by the database server.
Statistic | Scope | Description |
---|---|---|
Mem Pages: Lock Table | Database | Shows the number of pages used to store lock information. |
Mem Pages: Locked Heap | Server | Shows the number of heap pages locked in the cache. |
Mem Pages: Main Heap | Server | Shows the number of pages used for global database server data structures. |
Mem Pages: Map Pages | Database | Shows the number of map pages used for accessing the lock table, frequency table, and table layout. |
Mem Pages: Procedure Definitions | Database | Shows the number of relocatable heap pages used for procedures. |
Mem Pages: Relocatable | Database | Shows the number of pages used for relocatable heaps (cursors, statements, procedures, triggers, views, and so on). |
Mem Pages: Relocations/sec | Database | Shows the rate at which relocatable heap pages are read from the temporary file. |
Mem Pages: Rollback Log | Connection and database | Shows the number of pages in the rollback log. |
Mem Pages: Trigger Definitions | Database | Shows the number of relocatable heap pages used for triggers. |
Mem Pages: View Definitions | Database | Shows the number of relocatable heap pages used for views. |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |