Friday, 6 December 2013

How to check database, tablespace sizes in SAP

Advertisement

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.


                    EmoticonEmoticon

                    :)
                    :(
                    hihi
                    :-)
                    :D
                    =D
                    :-d
                    ;(
                    ;-(
                    @-)
                    :o
                    :>)
                    (o)
                    :p
                    :-?
                    (p)
                    :-s
                    8-)
                    :-t
                    :-b
                    b-(
                    (y)
                    x-)
                    (h)