Re: Reading/sniffing O7/O8 Log Files for SQLs

A copy of this was sent to sminni_at_vsnl.com (if that email address didn't require changing) On Fri, 03 Sep 1999 11:38:34 GMT, you wrote:

>I could not find any reference to log_miner, can I have more details on
>where to find it in the DOCs,
>
>Also I am using oracle server 8 NT, (i.e. not the enterprise version)
>it it different grom oracle 8i
>

Oracle8i, release 8.1 introduced this feature -- it is not in the 8.0.x release.

You can read about it online at http://technet.oracle.com/ (free accounts there). The Oracle8i documentation is online.

>- sanjay minni
>
>
>In article <37CEA04E.E3EC80D2_at_excite.com>,
> Thiru <tmgn_at_excite.com> wrote:
>> Oracle 8i introduced Log_Miner facility which you can use to achieve
>this..
>>
>> -Thiru
>>
>> sminni_at_vsnl.com wrote:
>>
>> > Hi,
>> >
>> > Using O7/O8 server on NT
>> >
>> > Is it possible to reverse engineer the Oracle Log archives so see
>the
>> > SQLs executed ?
>> >
>> > We need it for History and we are trying to set up a replication
>system
>> > on our own by getting the SQLs and executing it at other sites.
>> >
>> > if any products are availaible in this line can i get info on it
>> > pl. send copy of mail to NOSPAM_sminni_at_vsnl.com
>> >
>> > Regards
>> > ---
>> > Sanjay Minni NOSPAM_sminni_at_vsnl.com
>> > Minisoft Private Limited http://www.minisoftindia.com
>> > Calcutta, India
>> >
>> > Sent via Deja.com http://www.deja.com/
>> > Share what you know. Learn what you don't.
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Sep 03 1999 - 08:09:25 CDT