Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    New records question: increase in tablespace size to accommodate them

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    We are anticipating early next year having a very large influx of new records, at least 100,000. This would account for about 5% of our current bib count.

    What Oracle table space, indexes, etc. should our DBAs look at in order to accomodate this rapid growth?

    The data tables and index tables associated with bib records (HOLs, items, Browse index, Word index) account for almost all of the space used in the system. I think you should plan on increasing *all* tablespaces by 5%.

    If you have a lot of authority records, the tablespace those records reside in may be able to get by with a smaller increase.

    • Article last edited: 10/8/2013