Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. Cleaning the SFX_REQUEST table

    Cleaning the SFX_REQUEST table

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: SFX
    • Product Version: 3

    Description:
    What is the SFX_REQUEST table, why do I need to clean it, and how do I clean it?

    Resolution:
    The SFX_REQUEST table is used to store data required to generate each SFX menu screen - the data on requests before it actually gets processed by the statistics module. It is not directly related to statistics tables, so cleaning it does not result in a loss of statistical data.

    If you clean the SFX Request table using the server_admin_util tool, it will keep the last 24 hours of requests in the table, which is really all that is necessary for SFX Request to function, so the users will not be affected in any way.

    When selecting server_admin_util, choose option 5: Statistics.

    Then you will see:

    Statistics

    1 Move data from online to offline
    2 Archive statistics
    3 Load statistics from a file
    4 Show stats tables monitor information
    5 Scheduling for statistics maintenance tasks
    6 Clear SFX_REQUEST table
    Please select [1-6,q,m]:

    so you would choose option 6.

    This should reduce the size of the table to near zero.

    it is also possible to schedule this table for cleaning also using Option 5>5 of server_admin_util :
    5 Schedule clearing of SFX_REQUEST table

    We recommend cleaning the SFX_REQUEST table once a month, preferably before running the monthly update. A large SFX_REQUEST table may contribute to the fill-up of the /exlibris filesystem disk space and increase the time it takes to back up the instance database.

    Additional Information

    SFX_REQUEST,clean,maintenance,server_admin_util


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Clean scratch directory util doesn't clean ../sessions subdirectory
      • COinS cannot handle the encoding of some special characters
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 3
      2. contype:kba
      3. Prod:SFX
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved