I want to check how much memory does timesten use, I run this SQL in ttisql:
select sysdate, PERM_ALLOCATED_SIZE, PERM_IN_USE_SIZE, PERM_IN_USE_HIGH_WATER, TEMP_ALLOCATED_SIZE, TEMP_IN_USE_SIZE, TEMP_IN_USE_HIGH_WATER from sys.monitor;
and it prints:
< 2012-08-08 01:47:46, 8192000, 97801, 97842, 5120000, 82484, 540572 >
Does it mean:
The total memory TimesTen instance can use is: 8192000 (8G);
There are 97801 (97MB) used for storing data, in other words, the data in my cache group takes up 97 MB in total.
And also may I know what the TEMP_ALLOCATED_SIZE (the tempsize in sys.odbc.ini) means?
Thanks a lot!
Documentation (http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21633/using.htm#BCGHAIBG) says:
"Oracle TimesTen manages database space using two separate memory partitions within a single contiguous memory space. One partition contains permanent data and the other contains temporary data.
- Permanent data includes the tables and indexes that make up a TimesTen database. When a database is loaded into memory, the contents of the permanent data partition are read from files stored on disk. The permanent data partition is written to disk during checkpoint operations.
- Temporary data includes locks, cursors, compiled commands, and other structures needed for command execution and query evaluation. The temporary data partition is created when a database is loaded into memory and is destroyed when it is unloaded.
The connection attributes that control the size of the database when it is in memory are PermSize and TempSize. The PermSize attribute specifies the size of the permanent data partition and the TempSize attribute specifies the size of the temporary data partition."
Additionally you can use the following command for getting the db size:
Note that ipcs -m only tells you how large a shared memory segment TimesTen has allocated from the O/S and you can anyway know this as it is just PermSize+TempSize+LogBufMB+~20MB. It does not give you any insight into how much of that memory is actually used within TimesTen.