Enterprise Edition Home
|
Express Edition Home
|
Previous Page
|
Next Page
Effect of Configuration on Memory Utilization
In This Chapter
Allocating Shared Memory
Resident Portion
Virtual Portion
Message Portion
Configuring UNIX Shared Memory
Freeing Shared Memory with onmode -F
Configuration Parameters That Affect Memory Utilization
Setting the Size of the Buffer Pool, Logical-Log Buffer, and Physical-Log Buffer
BUFFERPOOL
DS_TOTAL_MEMORY
LOGBUFF
PHYSBUFF
LOCKS
RESIDENT
SHMADD
SHMTOTAL
SHMVIRTSIZE
STACKSIZE
Parameters That Affect Memory Caches
UDR Cache
Data-Dictionary Cache
Data-Dictionary Configuration
Monitoring the Data-Dictionary Cache
Data-Distribution Cache
Data-Distribution Configuration
Monitoring the Data-Distribution Cache
SQL Statement Cache
SQL Statement Cache Configuration
Monitoring and Tuning the SQL Statement Cache
Number of SQL Statement Executions
Monitoring and Tuning the Size of the SQL Statement Cache
Memory Limit and Size
Multiple SQL Statement Cache Pools
Output Descriptions of onstat Options for SQL Statement Cache
Session Memory
Data-Replication Buffers and Memory Utilization
Memory Latches
Monitoring Latches with Command-Line Utilities
onstat -p
onstat -s
Monitoring Latches with ISA
Monitoring Latches with SMI Tables
Encrypted Values
Enterprise Edition Home
|
Express Edition Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]