Morning everbody, I hope everyone is having a great day so far..if not we now have the weekend...
Ill to the point, im running statspack to produce a report and have a few questions that dont seem to be answered by the help files
1) if I want to run the statspack on 30 second intervals, how would i do that. I know how to shell script and can automate this with crontab but is there a way to do it within Oracle, maybe change a parameter somewhere??.
2) when you run a standard statpack report at the bottom are some values that i dont understand namely something called 'Hash Values' and some associated values like buffets gets, executions, there seems to be some sql code that is kicked out with these values..does anyone know what this is??..
3) finally if i want to produce only the top part of the report, what level would i set??, where would i set that level? (is it a table or parameter).
I thank anyone in advance for any help that they can offer.
