12 SQL*Plus Scripts for Oracle In-Memory Database Cache

This chapter lists the SQL*Plus scripts that are installed with Oracle In-Memory 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.

Installed SQL*Plus scripts

cacheCleanUp.sql: Drops Oracle 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 objects used by autorefresh cache groups" for more information.
cacheInfo.sql: Returns change log table information for all Oracle tables cached in an autorefresh cache group, and information about Oracle objects used to track DDL statements issued on cached Oracle tables. Script is used to monitor autorefresh operations on cache groups and DDL statements issued on cached Oracle tables. Run this script as the cache administration user. See "Monitoring autorefresh operations on cache groups" and "Tracking DDL statements issued on cached Oracle tables" for more information.
grantCacheAdminPrivileges.sql: Grants privileges to the cache administration user that are required to automatically create Oracle objects used to manage the caching of Oracle data when particular cache grid and cache group operations are performed. Run this script as the sys user. See "Automatically create Oracle objects used to manage caching of Oracle data" for more information.
initCacheAdminSchema.sql: Grants a minimal set of privileges to the cache administration user and manually creates Oracle objects used to manage the caching of Oracle data. Run this script as the sys user. See "Manually create Oracle objects used to manage caching of Oracle data" for more information.
initCacheGlobalSchema.sql: Creates the Oracle timesten user, the Oracle 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 tables. Script must be run regardless of whether you are automatically or manually creating Oracle objects used to manage caching of Oracle data. Run this script as the sys user. See "Create the Oracle users" for more information.
initCacheGridSchema.sql: Manually creates Oracle 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 objects used to manage caching of Oracle data" for more information.
README: Contains descriptions of the SQL*Plus scripts that are installed with Oracle In-Memory Database Cache.