Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > Query Caching > Using the Cache Manager >
Purging Cache
Purging cache is the process of deleting entries from the query cache. You can purge cache entries in the following ways:
- Manually, using the Siebel Analytics Server Administration Tool Cache Manager facility (in online mode).
- Automatically, by setting the Cache Persistence Time field in the Physical Table dialog box for a particular table.
- Automatically, by setting up a Siebel Analytics Server event polling table.
- Automatically, as the cache storage space fills up.
To purge the cache manually with the Cache Manager facility
- Use the Siebel Analytics Server Administration Tool to open a repository in online mode.
- Select Manage > Cache to open the Cache Manager dialog box.
- Select Cache or Physical mode by selecting the appropriate tab in the left pane.
- Navigate the explorer tree to display the associated cache entries in the right pane.
- Select the cache entries to purge, and then select Edit > Purge to remove them.
- In Cache mode, select the entries to purge from those displayed in the right pane.
- In Physical mode, select the database, catalog, schema or tables to purge from the explorer tree in the left pane.
In Cache mode, you can purge:
- One or more selected cache entries associated with the open repository.
- One or more selected cache entries associated with a specified business model.
- One or more selected cache entries associated with a specified user within a business model.
In Physical mode, you can purge:
- All cache entries for all tables associated with one or more selected databases.
- All cache entries for all tables associated with one or more selected catalogs.
- All cache entries for all tables associated with one or more selected schemas.
- All cache entries associated with one or more selected tables.
Purging deletes the selected cache entries and associated metadata. Select Action > Refresh or press F5 to refresh your cache display.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 23 June 2003 |