Re: AUDIT command

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 19 Nov 1999 20:22:53 +0100
Message-ID: <943039441.25860.0.pluto.d4ee154e@news.demon.nl>

No,
AUDIT doesn't track the exact statement. I don't know for what purpose you want to do this. If you want to do it for tuning purposes, you better enable trace for a session or on instance basis.

Hth,

--
Sybrand Bakker, Oracle DBA
Robert Chung <robertch_at_mindspring.com> wrote in message news:383498e3.330522812_at_news.mindspring.com...
>
> When auditing database activity on tables, is there any way to catch
> exact SQL statements submitted from users to database server? I know
> how to do it using table trigger and scanning v$sql, but I am
> wondering if it is possible using Oracle's own AUDIT command. Thank
> you in advance.
>
>
Received on Fri Nov 19 1999 - 13:22:53 CST