Check DB size

[Former Member]

Hello friends,

How can I check the whole DB size for Oracle ?

IS it the same size allocate for /oracle/SID/sapdata1 ?

Soon I will reach the maximum size that customer is paying for, and I am not sure what to do.

Thanks in advance,

Jord

[Former Member · Accepted solution]

DB size can be verified from the transaction DB02.

If you want to see the allocated file system size at OS level, then yes it is the same as the size allocated (used space out of total space of that particular file system) to /oracle/SID/sapdata*.

where sapdata* are sapdata1, sapdata2.. etc.

To have more space, you will have to request OS/Unix team to add more file system space (If used% is increasing)

Thanks

[Former Member · Accepted solution]

Thanks,

I appreciate it.

Have a good day,

[Former Member · Accepted solution]

One more thing,

How can I check the tables that grow the most in oracle ?

Thanks again

[Former Member · Accepted solution]

Hello,

This will be helpful :

Thanks