Skip to Content
avatar image
Former Member

Tablespace usage

Dear experts,

Please check my quality server tablespace details below.

PSAPPRD tablespace used 98%, what step I have to follow.

Please suggest me.

Thanks & regard,

Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 19, 2014 at 09:58 AM

    Hi Amit,

    From the screen shot I can see that PSAPPRD is 98% used.

    Total size = 73GB GB out of which 1.3 GB is still free.

    Total extents size = 130 GB out of which 57 GB is free.

    As the data files are in auto extend mode system can grow up to another 57 GB. Post which your system can start having problems.

    Suggestion

    1) Check what is the daily and monthly growth of system to ensure how many days system can run without any problem with 57 GB.

    2) Check space of storage where sapdata files are created. Do you have enough space to add new data files.

    3) If storage has good amount to free space  and DB growth is higher please add up another 50 GB into PSAPPRD . This will bring down the usage to below 90%

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      We have 180GB free out of 524GB on physical disk

      AUTOEXTEND option is on

      Cool..Check your Production from where you copied the data (as part of system refresh, if you did). Ensure you have enough space in Production as well.

      Since it is QA system and you have enough partition (you hardly have TS growth), you may ignore this.

      You may set an threshold for monitoring if you have option (As said by other techies).

      Regards,

      Nick Loy

  • Jun 19, 2014 at 11:30 AM

    I see the tablespace PSAPPRD is in auto extensible mode.

    I would setup up CCMS monitoring or a third party monitoring tool to trigger an alert when the free space is below a certain percentage.

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      If the tablespace is more than 95% alert is shown in RZ20 t-codes.

      Check in RZ20-SAP CCMS Monitor Templates-Database-Oracle-Space management-Tablespaces.

      All the tablespace are showing and if more than 95% give alert for the same.

      AUTOEXTEND is on its good and u you can add new datafile via Brtools - extend tabplesapce


      Regards


      Naveen 

  • Jun 20, 2014 at 05:46 AM

    Dear Amit.

    The first thing I see is that you are still using the old tablespace layout with DMTS tablespaces. This, on its own can be the cause for this huge waste of space. As you may already know in DMTS every object can have different extent sizes, this can lead to tablespace fragmentation.

    If you would reorganize your tablespaces to the new tablespace layout and so to LMTS/ASSM (sap note 355771), the fragmentation will drop due to much more less different sizes of extents (64 KB,1MB,8MB,64MB,128MB). This makes your life as an administrator not just easier, but you can use some new features as of Oracle 10g. Because some features can not be used for DMTS tablespaces.

    Long story short:

    Short term solution: reorganization within the same tablespace structure

                   positiv effect: less fragmentation

                   negativ effect: fragmentation and so waste of space will arise again and again in a short                                         time

                                            can not use some of the new features of recent Oracle releases

    Long term solution: reorganize to LMTS/ASSM

              positiv effect: less fragmentation, easier administration, I/O load is slightly better, new fetures                               can be used

              negativ effect: takes time to reorganize all tablespaces

    Regards,

    János

    Add comment
    10|10000 characters needed characters exceeded