Techniques for self-diagnosing performance problems in a database are
provided. The techniques include classifying one or more performance
problems in a database system. One or more values for quantifying an
impact of the one or more performance problems on the database system are
then determined. The quantified values are determined based on the
performance of operations in the database system. A performance problem
based on the one or more quantified values is then determined. A solution
for the performance problem is generated and may be outputted.