Monitoring PermSize and TempSize Attributes

The SYS.V$MONITOR system view contains several columns that can be used to monitor usage of PermSize and TempSize.

These columns include PERM_ALLOCATED_SIZE, TEMP_ALLOCATED_SIZE, PERM_IN_USE_SIZE, PERM_IN_USE_HIGH_WATER, TEMP_IN_USE_SIZE, and TEMP_IN_USE_HIGH_WATER. Each of these columns show in KB units the currently allocated size of the database and the in-use size of the database. The system updates this information each time a connection is made or released and each time a transaction is committed or rolled back.

For example, you could evaluate the temporary space usage by running a full workload and watching the high water mark (TEMP_IN_USE_HIGH_WATER) of the temporary space usage. The high water mark can be reset using the ttMonitorHighWaterReset built-in procedure. And if necessary, you can change TempSize to a value of the observed TEMP_IN_USE_HIGH_WATER value and add 10%.

Note:

You can also use the ttIsql dssize command to provide this information. See dssize in the Oracle TimesTen In-Memory Database ttIsql User's and Reference Guide.

You can monitor block-level fragmentation in the database with the SYS.V$BLOCK_INFO system tables or by calling the ttBlockInfo built-in procedure.

See SYS.V$MONITOR, SYS.V$BLOCK_INFO in the Oracle TimesTen In-Memory Database System Tables and Views Reference for details on these views. See ttBlockInfo in the Oracle TimesTen In-Memory Database Reference.