OraFAQ Forum: Performance Tuning » Database Metrics for Capacity Planning

Home » RDBMS Server » Performance Tuning » Database Metrics for Capacity Planning (Oracle 10G and 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Metrics for Capacity Planning [message #303308]

Thu, 28 February 2008 18:07

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

Report message to a moderator

Re: Database Metrics for Capacity Planning [message #305281 is a reply to message #303308]

Mon, 10 March 2008 05:31

Frank Naude
Messages: 4581
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.

Report message to a moderator

Previous Topic:	Impact of NLS Sort
Next Topic:	optimized search for max() function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:39:10 CST 2024