Friday, 6 December 2013

How to check database, tablespace sizes in SAP

How to check the database size ?

Goto transaction DB02  and navigate to Space -> Space overview to view

  • Database name
  • Database system
  • Size
  • Free size
  • Used percentage
  • Number of database users
  • Number of tablespaces
  • Number of tables and size
  • Number of indexes and size

In DB02, navigate to Space -> Space overview to find all the above mentioned details

    How to check  the users that are present in database at SAP level ?
    In DB02, navigate to Space -> Users -> Overview as below
              How to check various tablespaces in SAP and their sizes ?
              In DB02, navigate to Space -> Table spaces -> Overview to view tablespaces details as below.


                    1. Experience the thrill of outdoor laser tag skirmish in a new and exciting way.
                      It’s an ideal activity for kids and teenagers birthday parties!
                      Our Crew will arrive at least 15 minutes before your party starts to establish
                      the playing area and set up the equipment.


                    2. nice sir but can u explain the details that we look in this Tcode .

                    3. Thank you for such guidance about astrology,Best Blog on kerala manthrikam in Chennai

                    4. It was very nice blog to learn about SAP BASIS. Thanks for sharing.SAP basis

                    5. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP SD.
                      SAP SD

                    6. Sap MM SD FICO ABAP BASIS Training in Chennai with Placement Assistance.

                      Hi All, Reach Mr.Karthick for Best Quality SAP Training in Chennai with real time project assistance. Myself and my friends got training from the sample place. We can get basic level training from the same place. Any way in SAP we have to put more effects to get the job.

                      I recommended karthick is the best person for SAP Training in Chennai, his number is 8122241286,9003085882.
                      SAP MM

                    7. Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP BASIS.SAP basis