Mladen Gogala wrote:
> On Sat, 28 Feb 2004 08:22:09 -0800, Raj Jamadagni wrote:
>
>
>>In past what I have done is ... in the logon trigger, I do
>>
>>insert into stats_collection as select * from v$sesstat ;
>>
>>in the logoff trigger ... you would again do the same thing, but this
>>time update the values in stats_collection with the _difference_
>>between (v$sesstat.value - stats_collection.value) for the sid. There
>>you have it .... you could of course restrict number of rows that you
>>need by using specific stat names .... You get the idea?? YMMV
>>
>>Works like a charm.
>>Raj
>
>
> Well, that is almost the same thing as what is done by AUDIT SESSION. Why
> not simply turn on auditing?
Writing your own allows for collection of additional information
that may be of great value.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Feb 29 2004 - 11:57:52 CST
