SYNOPSIS:
For user convenience we are outlining here the steps for disabling preferences in shared memory.
High-Level Process
- Shutdown the environment (services/processes)
- On remote servers
- On Web/App servers.
- Run in a Tc command window
- clearlocks -assert_all_dead
- install -lock_db
- Delete the shared memory directory
- TC_SHARED_MEMORY_DIR
- In custom env file (or directly in tc_profilevars.bat)
- set TC_USE_PREFS_SHARED_MEMORY=FALSE
- Run in a Tc command window
- generate_metadata_cache -u=infodba -p=infodba -g=dba -force
- Optionally clean u
- Clear logs in TC_TMP_DIR
- Clear logs in TC_LOG (%TC_DATA%log_%TC_DB_SERVER%_%ORACLE_SID%)
- Run in a Tc command window
- install -unlock_db
- Restart the environment (servicesprocesses)
- On App/Web servers.
- On remote servers.
Default Values
TC_NO_TEXTSRV_SHARED_MEMORY = FALSE
TC_USE_LOV_SHARED_MEMORY = TRUE
TC_USE_METADATA_SHARED_MEMORY = TRUE
TC_USE_PREFS_SHARED_MEMORY=TRUE
Notes
The side effect of turning off shared memory is that each tcserver takes additional memory as below.
Shared Memory Segment | Additional Memory (per tcserver) |
---|---|
Preferences | ~2-4MB |
Metadata | ~19MB |
LOV | ~5MB |
TextServer | ~6MB |