Re: How to capture SQL_TEXT of queries?

How about just reading from V$SQLTEXT? As this only shows currently cached SQL statements, you would have to set up some sort of daemon to monitor the "new" statements, testing them for your criteria and saving them somewhere permanent.

Dragon Fly wrote:
>
> 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.
> The problem is, the "standard"
> triggers can be set up only for UPDATE OR INSERT
> while I need a trigger for SELECT statement.
> Anybody has an idea what is the good way of implementing
> such kind of thing?
>
> Thanks,
> Sergei
 

-- 
Diana Duncan	     | My opinions are my own.
Sr. Consultant	     | 
REALOGIC, Inc.	     | Excitement, Adventure and
dduncan_at_realogic.com | Really Wild Things - Z.B.