Re: Track user resource usage

On Sun, 29 Feb 2004 09:57:52 -0800, Daniel Morgan wrote:

> Writing your own allows for collection of additional information
> that may be of great value.

Can you be more specific? There is application specific logging and there is database auditing with specific purpose of tracking resource usage. What paritcular information of great value would you collect in the database trigger that would not be covered in application logging or dba auditing? Applications typically record username, date and operation on the transaction table, audit can collect logon time, logoff time and SQL statements, as well as CPU used, logical reads, physical reads and logical writes. What information in addition to that would you collect, and why?

-- 
Some people are only alive because it is illegal to shoot them.