Thread: Monitoring performance

Monitoring performance

From
Jan Ploski
Date:
Hello,

Is there a way to monitor query performance on the database server level?
What I am doing now is tweaking the JDBC driver to log slow queries
(slow = taking longer than some arbitrary threshold), but it appears to
me that the db server itself should be the ideal place for such tasks.

Can anyone point me to some documentation about how to get to some
internal stats, if they exist? I have found nothing in the Admin guide
nor in the book (apart from general advice about top/ps).

Thanks,
JPL