-
Making sense out of a statspack report?
Windoze 2000
Oracle 9i
Problem; I log in this morning and notice both CPU’s are maxed out, stays that way most of the time.
Well, I must first apologize for posting a legitimate question, I know you have all grown accustomed to my typical nonsense and meanderings.
Anyhow, I installed statspack today on one of our prod DB’s today and created the report, which…shall we say…..is lengthy, to be mildly understated.
So, given the OS and the problem, what should I be focusing on?
Any links to statsreports_for_dummies out there?
I have already piped one of the offending SQL’s (Top 10 by CPU) through Lecco
and sent the reports to applications, including the re-writes for their bad code.
Suggestions?
MH
I remember when this place was cool.
-
There's a book out there that gives good advice but I can't remember the name of the thing (it's in my household goods which are still being shiped). You could also go and register at http://www.oraperf.com/ and they'll analyze your reports for free. It's kind of neat. You can also go and download this GUI that will interface with the database and read the reports and put them into spiffy spread sheets. http://www.geocities.com/alexdabr/sppro.html.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
STATSPACK Viewer is not for free (30 days trial only).
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
yeaaaa... better manually read spreport...little bit hard but good for you. Like myself prefer sqlplus rather then oem.
-
Thanks guys!
I ran the spreport but it is really long, sometimes too much info can be counter-productive. I may check out that website, but I do not want to break any company rules either.
MH
I remember when this place was cool.
-
The most important part of the statspack report is the first few pages. Most of the other stuff just supports findings in the first few pages...
Jeff Hunter
-
I took the pragmatic approach and ignored
- anything I didn't understand
- anything that looked excessively tedious
I came to the same conclusion as Jeff.
-
Maybe I should just start drinking heavily, it is Friday after all, and it is after 8am.
Hmmmmm?
MH
I remember when this place was cool.
-
Large quantities of alcohol were mentioned in a tuning white-paper I once read. I think I wrote it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|