Capacity Planning and Query
Posted on 2002-04-08
Calculating Tablespace Size using Query
I normally use tools to view space utilization and free-space left in database. I have to work for 'Capacity Planning', I have around 50 database and have to find the 'space utilization' for all the databases.
1. Can i get a query which tells me the total space 'used' by all the tablespaces in database and total 'free-space' left in all the tablespaces for current database.
2. What are the other factors i have to work for Capacity Planning, Any suggestions/ideas most welcome.