Re: Oracle Logminer

Alex wrote:
> Hi all!
> We are using DBMS_LOGMNR. I wonder, is there some way to increase
> perfomance of Oracle Logminer?
> Maybe there is some analog of the db_file_multiblock_read_count
> parameter..
>
> We got one Oracle DB - which using only for to proceed archive logs
> from source DB and to put all data to our Data.
> So we can change all of the parameters of Oracle DB in the middle -
> it will not affect to end-users applications.
> Thanks.
>

Unfortunately, you cannot do very much, if anything, to improve LogMiner's performance. The more archived redo logs you scan, then longer it will take to mine information from them. You may consider mining fewer logs. Another option is to copy the online redo logs to another system and use that for mining so that you are not competing with your end users for resources.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com