Re: Recording historical session stats and events

Oracle does not allow users to create triggers on data dictionary tables.

Solomon Yakobson.

In article <Pine.OSF.3.95.971012004103.24862B-100000_at_gonzo.wolfenet.com>,   Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:
>
>
> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet