Simple way to extract database statistics

[Former Member]

Hi All,

I have around 40 different SAP systems for which I would be interested to collect the database/tablespace statistics (like Total Size/kb and Total Free/kb) to understand the database growth everyday.

It is difficult and tedious for us to collect these statistics manually to an excel. Can someone suggest us a better way to get this information in a more sophisticated way? We have solution manager which we can use if someone can suggest us how to use it to collect this info.

We are on Sun Solaris, Oracle 9i with 640 kernel.

Thanks

Vijay

[former_member66264]

Go for solution manager in combination with BW connection

This is alll standard

[Former Member]

Hi Vijay,

You can utilize the feature of STATSPACK provided by Oracle. This feature will automatically generates the reports you are looking for.

Kindly go through the below link for more info

http://www.dba-oracle.com/art_statspack.htm

Regards,

Suneel