Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to capture SQL_TEXT of queries?
Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in article
<3347CA33.4944_at_exesolutions.com>...
> > In short, I need to set up kind of a trigger on some of the tables so
> > that it captures the text of the queries run against those tables.
>
> I may be shown to be incorrect by those more knowledgeable than I but I
> suspect it can not be done without forcing those doing the queries
> through some kind of three tier system where the middle tier does the
> capture.
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?
Thanks for response,
Sergei
>
> Daniel A. Morgan
>
Received on Sun Apr 06 1997 - 00:00:00 CST