Skip to Content
0
Jun 10, 2013 at 06:27 AM

Tablespace growth for a Java stack SAP system

817 Views

Hello All

I need to calculate monthy growth for all the tablespaces for a java stack SAP system.

I need to see the details similar to the monthly history we get to see in DB02 for an ABAP stack system.

So that, I can get all the necessary details to calculate monthly tablespace growth.

We are using Oracle Database 11g Enterprise Edition Release 11.2.0.2.0.

Need to know the monthly tablespace growth. Could anyone help me with how can I get this detail ?

Anyone knowing any SQL query by which I can get the appropriate result easily OR any other better suggestion required.

Tablespaces: PSAPSR3DB, PSAPTEMP, PSAPUNDO, SYSAUX, SYSTEM, TOOLS.

Thanks!

Regards

Abhishek