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 -> Re: How to capture SQL_TEXT of queries?

Re: How to capture SQL_TEXT of queries?

From: Hank Eskin <henry_at_ix.netcom.com>
Date: 1997/04/08
Message-ID: <334A8473.562D@ix.netcom.com>#1/1

Michael Ho wrote:
>
> Dragon Fly wrote:
>
> > how about setting up a trigger on some system table which gets
> > updated or inserted into whenever someone runs "SELECT" ??
> > which table(s) might be a good candidate?
>
> Maybe work, never try.
> But sounds too risky. I think a good DBA will never allow something
> like that happen.

don't worry, Oracle won't let you put triggers on system tables. I tried this once to trap when users logged in (using V$session table) and I could not put a trigger on it.

-- 

netcom: henry_at_ix.netcom.com
Received on Tue Apr 08 1997 - 00:00:00 CDT

Original text of this message

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