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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can i leave log for SQL query?

Re: How can i leave log for SQL query?

From: Chris Weiss <chris_at_hpdbe.com>
Date: Wed, 15 May 2002 17:20:21 -0400
Message-ID: <abujeq$3104$1@msunews.cl.msu.edu>


If I understand what you are trying to get it, you want to see what SQL was executed?

Read about the V$SQLAREA and V$SESSION.

You can also turn on tracing and each Oracle session will generate a unique trace file. Be sure to turn this off, or you will fill your trace directory file system.

If you need online auditing, triggers can provide this functionality.

Good Luck!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts

"ÀÌ¿µÇÑ" <hotyoung_at_netnsec.com> wrote in message
news:oTjE8.1818$V3.278472_at_news.bora.net...

> Connect to Oracle DB server using PHP.
>
> Does log about SQL query remain to this case Oracle server?
>
> How can you see this log if remain?
>
> If do not remain, is method to leave log that store SQL query that execute
> because connecting to Orakeul server?
>
>
>
>
>
Received on Wed May 15 2002 - 16:20:21 CDT

Original text of this message

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