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 126.96.36.199.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.