cancel
Showing results for 
Search instead for 
Did you mean: 

How can i find out the database size

Former Member
0 Kudos

Hi Experts,

Please let me know how can i find out the database size for each system.

Regards,

Reddy V

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thank you for your valuable information

Former Member
0 Kudos

Go to tcode DB02

There you can find out the Databse total size, Total free size and Total used %.

Former Member
0 Kudos

Hi Deepak,

Thank You for your information

In DB02 T-code it is showing the below details two options

1. TableSpaces

Total number 7

Total size/kb 136,273,920

Total free/kb 23,600,960 17 %

Minimum free/kb 17,856

Max. autoextensible/kb 450,560,000

2. Tables and indexes

Tables Indexes

Total number 68,514 82,026

Total size/kb 43,432,960 43,286,080

More than 1 extent 2,960 3,474

Missing in database 0 0

Missing in R/3 DDIC 1 0

Space-critical objects 0 0

In point 1.Total size 136,273,920 kb it means 130 GB.

Please confirm the same

Regards,

Reddy V

Former Member
0 Kudos

Hi

Your current database size is

Total 136,273,920

Free 23,600,960

Size is 108GB. (Actual filled size means this much amount of data is present in database)