Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query log
<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.<!--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