If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Database Server Software > Sybase > Sybase cache memory information

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Oct 2012
Posts: 1
Sybase cache memory information

I have some question about cache memory in Sybase 12.5

1- How to check currently which store procedure in there in cache memory. please let me know the command which will display entire store procedure are there in cache memory
2- How to clear the cache memory. Please let me know the command. I want to clear all the data, store procedure, and query from the cache memory.
3- If I want to store the store procedure in cache memory for this I need to execute the procedure. It is like below

EXEC cip_get_bmf @account_no=307780923

EXEC cip_get_bmf @account_no=307780911

As see the above there is one store procedure but have the different account_no as a parameter. So in this case, in cache memory same store procedures are store in two times because input parameters are different. Please let me know how to store the store procedure in cache memory.

4- If procedure A is calling procedure B, C, D. so if I execute the procedure A. in the cache memory what procedure will store. It will store all the procedure like A,B,C, and D. Please let me know.
Reply With Quote
  #2 (permalink)  
Registered User
Join Date: Feb 2012
Location: India,Mumbai
Posts: 34
Point# 2 : There is no such command to clear the cache memory for Sybase 12.5.
You can restart the server to clear the cache memory or refresh the database of the server.
Reply With Quote
  #3 (permalink)  
Registered User
Join Date: Feb 2012
Posts: 86
Point #1 : you can execute system sproc sp_helpcache to determine bound cache to the objects
sp_configure 'procedure cache size' to check value for procedure cache
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On