You can change the size of the secondary data cache.
To increase the size of the secondary data cache to the declared size of the shmfs, use sp_configure. This is a dynamic change and does not require restarting Adaptive Server. For example, to increase cache size to 8GB, enter:
sp_configure “extended cache size”, 4194304
To increase the size of the secondary cache beyond the shmfs size configured by the operating system:
Disable the secondary cache. Enter:
sp_configure “extended data cache”, 0
Unmount the /dev/shm.
Mount the shmfs with the desired size.
See “Configuring the operating system” for instructions.
Enable the secondary data cache with the desired size.
See “Configuring Adaptive Server” for instructions.
You can decrease the size of the secondary cache in two ways: statically, which requires a reboot of Adaptive Server, and dynamically, which does not.
To statically decrease the size of the secondary data cache:
Use sp_configure to reset the size of the secondary data cache to the desired size. For example, to increase cache size to 2GB, enter:
sp_configure “extended cache size”, 1048576
Reboot Adaptive Server.
To dynamically decrease the size of the secondary data cache:
Disable the current secondary cache. Enter:
sp_configure “extended data cache”, 0
Re-create the secondary cache in the desired size. For example:
sp_configure “extended cache size”, 1048576
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
