Setting SmartIO caching policies for database objects


Setting SmartIO caching policies for database objects
Prev	About SmartIO caching for Oracle databases on VxFS file systems	Next

A Database Administrator (DBA) with knowledge of the database activity and usage statistics may want to adjust the SmartIO caching policies based on this information. You can set a SmartIO caching policy for a specified database object, including a named tablespace, a recent partition, or a particular datafile. You can also pin a specified database object to hold it in the SmartIO cache area.

See Pinning and unpinning database objects.

To set the caching policy for a specified database object

Use the following command:

# sfcache app cachearea=cachearea_name oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o set --cachemode={nocache|read} \
{--datafile=name | --partition=name \
| --tablespace=name | --tablecluster=name \
| --filelist=name}

Prev	Up	Next
Setting default SmartIO caching policies for a database running on a VxFS file system	Home	Pinning and unpinning database objects