I'm trying to be a dba on our sql installations, but some of the tasks isn't all that easy. From time to time we have a heavy cpu load, but I'm having a hard time finding a way to find the right spid. Using who2 only shows the cumulative cpu usage and that can be misleading. Any tips on how to achieve something like top in unix or task list in windows, showing the top 10 spids with cpu usage.
Anders