How to Determine Which Intervals Have a Particular Select Limit
To determine the interval for a cache group, use ttIsql
and run the
cachegroups
command.
> cachegroups cgowner.cgname
;
This returns all attributes for the cgowner.cgname
cache group including the interval.
To determine which intervals have a select limit, you can run the following query on
the Oracle database where <cacheAdminUser>
is the cache
administrator, <hostName>
is the host name of the machine where
the TimesTen database is located, <databaseFileName>
is the
database path taken from the DataStore
attribute, and substitute the version
number (such as 07) for the xx
.
SELECT * FROM <cacheAdminUser>.tt_xx
_arinterval_params
WHERE param='AutorefreshSelectEveryN'
AND host='<hostName>'
AND database like '%<databaseFileName>%'
ORDER BY arinterval;
For example, if the cache administrator user name is pat
, the host
name is myhost
, the database file name is myTtDb
, and 07 is
substituted for xx
that is the TimesTen minor release number then:
SELECT * FROM pat.tt_07_arinterval_params WHERE param='AutorefreshSelectEveryN' AND host='myhost' AND database like '%myTtDb%' ORDER BY arinterval;
The interval is stored in milliseconds.