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: query log

Re: query log

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Apr 2006 09:55:51 -0700
Message-ID: <1144428946.672223@yasure.drizzle.com>


ianal Vista wrote:
> maxim2k <maxim2k_at_gmail.com> wrote in news:91fa5$44355b8b$5277c1be$11950
> @news0.easynet.it:
>

>> Hi all,
>>
>> How can I access a log of the latest queries executed on an Oracle 
>> Database (9i and 10g)?
>>
>> Thanks.

>
> as a general rule SELECT statements are "never logged"

Though it should be noted that SELECT logging is the default in the DBMS_FGA built-in package.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Apr 07 2006 - 11:55:51 CDT

Original text of this message

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