The database start behaving slow from time to time, this has happened quite a few times now,
I am more interested in finding out is their sequence of steps to be taken to findout what is currently going on in the Database.
Something like, get all the SQL stmt. currently executing
How much disk I/O etc.
Is their any article/white papers on this topic.