8/16/2017

SAP How to check database, tablespace sizes in SAP ?

  • How to check the database size ?
  • How to check in SAP, the number of tables and indexes in database and their sizes ?
  • How to check  the users that are present in database at SAP level ?
  • How to check various tablespaces in SAP and their sizes ?
 ---------------------------------------------------------------------------------------

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


    saps

    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.

                    Popular Posts