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
mkrishna95050
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)?

Thanks
Krishna
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: Thu Dec 08 20:21:05 CST 2016

Total time taken to generate the page: 0.24276 seconds