Results 1 to 3 of 3
  1. #1
    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.

  2. #2
    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.

  3. #3
    Join Date
    Feb 2012
    Posts
    89
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •