Why do people email...
Today – a 1.8mb statspack report. The text of the email said “Maybe not the right way to approach for help. But please excuse. … Really sorry for the long post”. They know they are doing something outside the normal bounds of netiquette, but do it anyway. To top it off – the statspack was inline, not an attachment. Not even a chance it wouldn’t be downloaded.
Never mind that it might slam me big time on the road. Heck, when I was using a satellite connection – that simple email would have been more than 5% of my quota for the day!
To top it off – the statspack report was for 15 minutes (that is good), but unfortunately, it was 15 minutes when no one was logged on, when no activity was taking place in the database. Yes – transactions per second? 0.00. Executes per second? 0.47 (meaning, every two or three seconds on average, a statement was executed). User calls per second? 0.03 – 0.03! Each node reports – 1 CPU second used (total of 3 CPU seconds). The only SQL in the report? Yep – the SQL executed by the statspack snaps.
I have no idea why anyone would send such an email. None.
Guess it is sort of like a person at a party that meets a doctor and proceeds to take off a shoe to show them a foot problem and ask for advice.