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: EdStevens <quetico_man_at_yahoo.com>
Date: 6 Apr 2006 11:53:50 -0700

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: EdStevens <quetico_man_at_yahoo.com>
</span>
<span id="date"><dfn>Date</dfn>: 6 Apr 2006 11:53:50 -0700</span>
<span id="message-id"><dfn>Message-ID</dfn>: <1144349630.309278.15890_at_j33g2000cwa&#46;<!--nospam-->googlegroups.com>
</span>
</address>

maxim2k wrote:
<br>
<i class="quotelev1">> Hi all,</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> How can I access a log of the latest queries executed on an Oracle</i><br>
<i class="quotelev1">> Database (9i and 10g)?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> Thanks.</i><br>

There is no easily readable 'log', per se. Check out logminer. Also v$sqltext.
<span id="received"><dfn>Received on</dfn> Thu Apr 06 2006 - 13:53:50 CDT</span>
</div>
Received on Thu Apr 06 2006 - 13:53:50 CDT

Original text of this message

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