Extracting CPU data from statspack tables [message #127993] |
Thu, 14 July 2005 08:58 |
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
|
|
|
|