Skip to Content
author's profile photo Former Member
Former Member

Database space blown up

Hi experts,

after reloading one of our Infocubes the database size has increased by 50 GB. I did the new loads with the PSA option, but when I deleted the PSA data it did not help very much. Do you have any ideas what might be behind that? What should I do to win the space back?

Thank you very much,

Michal

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Apr 10, 2008 at 06:56 AM

    Hi,

    Try to free some DB space by these steps.

    1. Delete old/unwanted PSA data.

    2. If you aggregates that have very low valutaion (------) and whose usage is very less, then better delete/deactivate them.

    3. For those targets where you dont need PSA in the data flow remove it.

    4. If you have unused reports (created for some testing), delete them.

    Once all this is done perform DB reorg routinely.

    This will free up some DB space.

    thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      The first three points you have already tried them.

      Regarding reports, its a practice we follow. In some systems you are given authorization to create reports freely (mainly testing purposes). They are generally copy of some standard or custom report just created to test some scenarios and later on ignored. If the number of such reports are higher its better to delete them if not required.

      This is not just limited to reports, it will advicable for almost all objects that are unused and without any dependencies.

      for eg imagine you have an ODS/Cube with say 20 million records holding data for all regions and later on you decide to have logical partion on this, thats creating multiple ODS/cubes for each region and creating new reports for them and ignoring the old ODS and reports on them. Once you perform the historical load and setup deltas to the new ODS , and they are ready, you may chose to delete the old one. Thats ultimately a business decision.

      DB reorg.

      SAP note 541538 - FAQ: Reorganizations

      Tablespace reorganizations can be useful in the following situations

      Recovering disk space: If a tablespace contains a lot of freespace that is never used, you can reduce the size of the tablespace with a tablespace reorganization so that space is recovered on the hard disk

      http://www.oracle.com/technology/deploy/availability/htdocs/online.htm

      SAP note 646681 Reorganizing tables with BRSPACE

      SAP note 647697 - BRSPACE - New tool for Oracle database administration

      SAP note 620803 - Oracle 9i: Automatic Segment Space Management

      http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

      Hope this helps.

      Thanks,

      JituK

      Edited by: Jitu Krishna on Apr 10, 2008 8:16 PM

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 06:11 PM

    Michal,

    Deleting the PSA probably increased the amount of space 'Free' within the database.

    To shrink the filesize of the database itself, I believe you need to talk with your DBA/Basis about that operation.

    Nick

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Nick,

      if I understand you well you say that transaction DB02 does not show when I delete the PSA data? Can this be connected with e.g. Nametab inconsistencies which were reported (temporary entries in tables which are no loger used, but are still there)? Any OSS note, clean-up program, I should check?

      Thank you,

      Michal

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.