Using the ttIsql Utility cachegroups Command
You can obtain information about cache groups in a TimesTen database using the
ttIsql
utility cachegroups
command.
% ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet" Command> cachegroups; Cache Group CACHEADMIN.RECENT_SHIPPED_ORDERS: Cache Group Type: Read Only Autorefresh: Yes Autorefresh Mode: Incremental Autorefresh State: On Autorefresh Interval: 1440 Minutes Autorefresh Status: ok Aging: Timestamp based uses column WHEN_SHIPPED lifetime 30 days cycle 24 hours on Root Table: SALES.ORDERS Table Type: Read Only Cache Group CACHEADMIN.SUBSCRIBER_ACCOUNTS: Cache Group Type: Asynchronous Writethrough (Dynamic) Autorefresh: No Aging: LRU on Root Table: SALES.SUBSCRIBER Table Type: Propagate Cache Group CACHEADMIN.WESTERN_CUSTOMERS: Cache Group Type: User Managed Autorefresh: No Aging: No aging defined Root Table: SALES.ACTIVE_CUSTOMER Where Clause: (sales.active_customer.region = 'West') Table Type: Propagate Child Table: SALES.ORDERTAB Table Type: Propagate Child Table: SALES.ORDERDETAILS Where Clause: (sales.orderdetails.quantity >= 5) Table Type: Not Propagate Child Table: SALES.CUST_INTERESTS Table Type: Read Only 3 cache groups found.
The information displayed by the ttIsql
utility's cachegroups
command include:
-
Cache group type, including whether the cache group is dynamic
-
Autorefresh attributes (mode, state, interval) and status, if applicable
-
Aging policy, if applicable
-
Name of root table and, if applicable, name of child tables
-
Cache table
WHERE
clause, if applicable -
Cache table attributes (read-only, propagate, not propagate)
See ttIsql in Oracle TimesTen In-Memory Database Reference.