Home » RDBMS Server » Performance Tuning » Extracting CPU data from statspack tables
Extracting CPU data from statspack tables [message #127993] Thu, 14 July 2005 08:58 Go to next message
dee_hicks
Messages: 1
Registered: July 2005
Location: TN,US
Junior Member
We have a cron job that wakes up every 30 minutes and takes a statspack snapshot.

I have been tasked to query this statspack data to determine the peak CPU usage on a daily basis over the last week.

I have only a small amount of statspack knowledge and the documentation is somewhat limited.

I was hoping that someone familiar with statspack could give me a little sql to perform this operation.

Thanks in advance for your help,

Dee
Re: Extracting CPU data from statspack tables [message #127999 is a reply to message #127993] Thu, 14 July 2005 09:21 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you look into DBMS_STATS.GATHER_SYSTEM_STATS?
Previous Topic: trace level for query
Next Topic: Pinning question
Goto Forum:
  


Current Time: Sat Nov 23 16:42:32 CST 2024