Database Size

[Former Member]

Hi Friends,

We are on HPUX/oracle, ECC 6.0, how to find out what is the total database size on the box and how much is used and how much free space is left.

thanks,

k

[former_member204746 · Accepted solution]

transaction DB02OLD, click on SPACE STATISTICS

or better yes, go for SAP course ADM100 as soon as possible.

good luck.

[Former Member · Accepted solution]

Sorry, i am aware of the ST04, Db02, DBAcockpit. Sorry i missed some lines in my question, i have increased the tablespaces, as far as i know when the database is restarted it is reflected and we can know the total size of the dtabase. IS there any way at the SAP level to know the total size of the datbase size after the increase of the tablespaces.

At the sql level, with the sql code i could see that difference before increasing the table space and after increasing the tblespaces.

Please help me to find the same at the SAP level.

Thanks.

[former_member204746 · Accepted solution]

I gave you the answer. have you tried it?

transaction DB02OLD, click on SPACE STATISTICS. you will get all of your answers.

[Former Member]

Hi Krish,

Who told you that newly added FSs only showable after restart?

You can find the current size of database with DB02OLD tcode.....That wil show you total size include newly added.

Regards

Nick Loy

[Former Member]

Closed