Re: SQL Trace with Oracle 8

Use sql_trace=TRUE, as Bob suggested, or oracle auditing. In any case, you may not want ALL sql statements and you'll want some type of discretion. SQL Tracing facility allows you to get all SQL pertaining to a session
(connection), you can switch it on with ALTER SESSION statement. Auditing allows you to get all SQL for a particular object or type of access. There are also other options that auditing offers. Auditing is usually configured to store results in the database (AUDIT_TRAIL=DB or TRUE in init.ora). It is easier to obtain them with sql against a number of views. If you want them in a file, consider OS auditing (AUDIT_TRAIL=OS).

Regards,
Karen Abgarian.

jchernia9012_at_my-deja.com wrote:

> Folks,
> I'm using Oracle8 for NT. I want to log all SQL statements that come
> into the server to a file (there is a similar utility with MSSQL). Is
> this possible, and how would I do it?
>
> TIA,
> John Cherniavsky
> You can email me at jchernia1_at_yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Sep 09 1999 - 08:38:50 CDT