Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: AUDIT & DETAIL QUERIES

Re: AUDIT & DETAIL QUERIES

From: nirav <shivam71_at_gmail.com>
Date: 2 Mar 2006 02:29:55 -0800
Message-ID: <1141295395.723584.16840@e56g2000cwe.googlegroups.com>


Yes , it is possible to do so, by turning on sql_trace. this will create a trace file in user dump destination directory. Use tkprof with record=a.txt (it will prompt you for an output file, give a filename) and this file, a.txt contains all the user supplied sql statements. Received on Thu Mar 02 2006 - 04:29:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US