Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recording historical session stats and events

Recording historical session stats and events

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: 1997/10/12
Message-ID: <Pine.OSF.3.95.971012004103.24862B-100000@gonzo.wolfenet.com>#1/1

I would like to make Oracle record session stats and events whenever a session ends. Is there any reason I can't put a trigger on SYS.AUD$ that collects stats and events whenever a disconnect occurs?

Potential problems:

1.) Is the session already gone when the audit stuff is firing off?

2.) Should I be really, really careful about putting a trigger on a data dictionary table? Why?

Anyway, I think I'll try it on a test instance. This would be really cool if it worked.

--
Jeremiah Wilton      http://www.wolfenet.com/~jeremiah
Received on Sun Oct 12 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US