 | ||
| Enabling and disabling caching for the database | ||
|---|---|---|
| Prev | About SmartIO caching for Oracle databases on VxFS file systems | Next |
| ||
| Enabling and disabling caching for the database | ||
|---|---|---|
| Prev | About SmartIO caching for Oracle databases on VxFS file systems | Next |
The SmartIO plug-in for oracle allows you to enable or disable caching for the database.
You can use this operation to temporarilly disable caching for database jobs like backup or data warehouse ETL (extract, transform and load) operations. After the job completes, you can enable caching. You can enable and disable caching while the database is online.
To enable caching for the database
# sfcache app cachearea=cachearea_name oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o enable
For example:
$ sfcache app cachearea=sfcachearea_1 oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o enable
INFO: Oracle Instance tpcc is running
INFO: Store DB details at /tpccdata/.CACHE_INFO
INFO: Setting enable mode to /tpccdata
INFO: Setting enable mode to /tpcclog
To disable caching for the database
# sfcache app cachearea=cachearea_name oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o disable
For example:
$ sfcache app cachearea=sfcachearea_1 oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o disable
INFO: Oracle Instance tpcc is running
INFO: Store DB details at /tpccdata/.CACHE_INFO
INFO: Setting disable mode to /tpccdata
INFO: Setting disable mode to /tpcclog