Re: logminer

Log miner reads and interprets the redo logs, even when the database is not open.

You cannot use it to find queries, only the effects of inserts, updates, and deletes. and then not the SQL used to do the job, only SQL that emulates the effects.

It does not, in principal, affect the performance of the database directly - however it obviously has to use CPU and disk accesses, so has some marginal effect on performance: in much the same way as running an awk script against a large file would have.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



letokai_at_my-deja.com wrote in message <91dlbi$7tq$1_at_nnrp1.deja.com>...


>I'm trying to understand how to use logminer?

>any informations?

>

>Can I obtain the last queries executed during last 10 minutes for

>example?

>Does it low performance of the database (while users are querying)?

>

>

>Sent via Deja.com

>http://www.deja.com/