This appendix lists the SQL*Plus scripts that are installed with TimesTen Application-Tier Database Cache used to perform various configuration, administrative and monitoring tasks, and provides links to more information including examples. All scripts are installed in the TimesTen_install_dir/oraclescripts directory.
cacheCleanUp.sql: Drops Oracle Database objects such as change log tables and triggers used to implement autorefresh operations. Script is used when a TimesTen database containing autorefresh cache groups is unavailable because the TimesTen system is offline, or the database was destroyed without dropping its autorefresh cache groups. Run this script as the cache administration user. See "Dropping Oracle Database objects used by autorefresh cache groups" for more information.
cacheInfo.sql: Returns change log table information for all Oracle Database tables cached in an autorefresh cache group, and information about Oracle Database objects used to track DDL statements issued on cached Oracle Database tables. Script is used to monitor autorefresh operations on cache groups and DDL statements issued on cached Oracle Database tables. Run this script as the cache administration user. See "Monitoring autorefresh operations on cache groups" and "Tracking DDL statements issued on cached Oracle Database tables" for more information.
grantCacheAdminPrivileges.sql: Grants privileges to the cache administration user that are required to automatically create Oracle Database objects used to manage the caching of Oracle Database data when particular cache grid and cache group operations are performed. Run this script as the sys user. See "Automatically create Oracle Database objects used to manage data caching" for more information.
initCacheAdminSchema.sql: Grants a minimal set of privileges to the cache administration user and manually creates Oracle Database objects used to manage the caching of Oracle Database data. Run this script as the sys user. See "Manually create Oracle Database objects used to manage data caching" for more information.
initCacheGlobalSchema.sql: Creates the Oracle Database timesten user, the Oracle Database tables owned by the timesten user to store information about cache grids, and the TT_CACHE_ADMIN_ROLE role that defines privileges on these Oracle Database tables. Script must be run regardless of whether you are automatically or manually creating Oracle Database objects used to manage caching of Oracle Database data. Run this script as the sys user. See "Create the Oracle database users" for more information.
initCacheGridSchema.sql: Manually creates Oracle Database tables used to store information about TimesTen databases that are associated with a particular cache grid. Run this script as the sys user. See "Manually create Oracle Database objects used to manage data caching" for more information.
README: Contains descriptions of the SQL*Plus scripts that are installed with TimesTen Application-Tier Database Cache.