TimesTen allows you to specify a RAM policy that determines when the database is loaded and unloaded from main memory. The policy options are:
Policy | Default | Description |
---|---|---|
InUse | Yes | Load the database on first connection and unload on last disconnect. |
Inuse with RamGrace | Keep the database in memory for a “grace period” after the last disconnect. | |
Always | Keep the database in memory at all time and automatically load the database upon restart of the TimesTen daemon process. | |
Manual | Load and unload the database manually |
Use the ttAdmin utility to set or get the RAM policy.
[oracle@Exalytics-01 ~]$ ttAdmin MyDSN
RAM Residence Policy : inUse
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : False
Once the Ram policy is changed with another value than the default, the ttstatus utility gives also the Ram Policy.
TimesTen status report as of Wed Jun 20 14:16:57 2012
Daemon pid 23522 port 53396 instance tt1122
TimesTen server pid 23531 started on port 53397
------------------------------------------------------------------------
Data store /u01/app/oracle/product/aggregate_store/tt_aggr_store/di_tt_aggr_store
There are no connections to the data store
.........
.........
.........
RAM residence policy: Always
Replication policy : Manual
Cache Agent policy : Manual
PL/SQL enabled.
Use the ttAdmin utility to set or get the RAM policy.
[oracle@Exalytics-01 ~]$ ttAdmin -ramPolicy always MyDSN
RAM Residence Policy : always
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : False