The present invention provides a method and system for monitoring the
process performance of a database that accepts and records SQL statements
and that records the status of a session of use of the database. The
invention obtains the SQL address and hash value for each SQL statement,
the current session status corresponding to each SQL statement and the
previous session status corresponding to each SQL statement. The
invention also records a time stamp at the time the session status
information is obtained. The information gathering steps are repeated at
a predetermined interval of time. Using the information gathered, the run
time for each SQL statement is calculated. The run time for each SQL
statement may then be reviewed to determine which SQL statements
experience the greatest run time, which allows DBAs to locate the source
of any performance problems.