Results 1 to 4 of 4

Thread: Sybase Cache

  1. #1
    Join Date
    Mar 2009
    Location
    New Delhi - India
    Posts
    22

    Question Unanswered: Sybase Cache

    How can I clear all the cache' in Sybase ??

  2. #2
    Join Date
    Aug 2010
    Posts
    19
    sp_unbindcache_all "default_data_cache"

    --------------------------
    check out our blog:
    SybDocBlog | The Sybase internal FAQ page

  3. #3
    Join Date
    Mar 2008
    Posts
    96
    try dbcc cacheremove ( dbname, objectname )

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Besides those already posted
    Other commands to look at depending on your version

    set statement_cache off -- session level
    <your sql statements here>

    or
    sp_configure 'statement cache size',0 -- server level

    dbcc proc_cache (free_unused)

    dbcc proc_cacherm(type, dbname, objname)

    where: type is V,P,T,R,D,C,F, or S (must be uppercase) corresponds to View,
    Proc, Trigger, Rule, Default, Cursor, SQLJ Function, SQL function

Tags for this Thread

Posting Permissions

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