Re: How to trace transcations?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 06 Aug 1999 17:41:15 +0800
Message-ID: <37AAADBB.3DF4@yahoo.com>

Patrick Leung wrote:
>
> Hi,
>
> Does anyone know how to trace transcations (e.g insert, update delete from
> database users) on Oracle 7.1 database?
>
> Thanks

Have a read about the auditing options which can log dml against tables etc, and also "sql_trace" in the alter session command to trace all statements from more of a performance tuning perspective..

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Aug 06 1999 - 04:41:15 CDT