* BLUSH * Big Time!
This is ripe coming from a DBA who still develops, but I'd often looked at the sysprocesses and wondered whether I could get the additional information to appear there - a severe case of RTFM!! Guilty as charged m'lud!
Isn't is amazing how quickly I can now respond right down to the desk when there are problems by identifying the precise user causing locks and slow processes within seconds. Eveyone will soon think I'm spying on them (more than I do now anyway).
Great artice, and an example of how a small change can make a huge impact.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.