Home » RDBMS Server » Performance Tuning » Database Metrics for Capacity Planning (Oracle 10G and 9i)
Database Metrics for Capacity Planning [message #303308] Thu, 28 February 2008 18:07 Go to next message
Messages: 1
Registered: October 2007
Junior Member
Hi everyone,

Can you please post your recommendations on what kind of statistics need to be captured on a Oracle 10G or 9i instance on a regular basis to track Database usage, growth and performance?

A key list of metrics sampled everyday at a specific time interval which can be used for capacity planning (Not just growth in tablespace but other factor such as CPU, Memory, IO etc)?

Re: Database Metrics for Capacity Planning [message #305281 is a reply to message #303308] Mon, 10 March 2008 05:31 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Oracle 10g has a nice view, called v$osstat, that can be sampled for CPU Time, memory, I/O wait time, etc.
Previous Topic: Impact of NLS Sort
Next Topic: optimized search for max() function
Goto Forum:

Current Time: Fri Oct 28 07:48:16 CDT 2016

Total time taken to generate the page: 0.16324 seconds