Storing wait event information via after logoff trigger

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 20 Jun 2001 23:15:53 -0700
Message-ID: <F001.00331329.20010620224118@fatcity.com>

Hi,

We have an application that connects to our DB via ODBC runs a query and disconnects.
This query could do any type of DML and is triggered off from external interfaces (eg radio and scales).

I would like to capture the wait event information and wonder if anyone has written a DB after logoff trigger that selectively records information from v$session_event and CPU time from v$sesstat into a custom table.

If not it might be time to write such a trigger.

Thanks,
Bruce
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 21 2001 - 01:15:53 CDT