Skip to Main Content
  • Questions
  • Time taken to mine 1GB of archive log on mining database

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Sanjay.

Asked: March 06, 2017 - 9:43 am UTC

Last updated: March 07, 2017 - 7:38 am UTC

Version: Oracle 11.2.0.4

Viewed 1000+ times

You Asked

Hi,

I would be requires expert advice on how much time is required to mine 1GB archive log files on mining database. I do not want to mine archive logs on primary database. I have created similar copy of database called as"mining database" and wanted to mine archive logs in mining database.

Hence,m please advice how much time it will take to mine 1GB of archive log file on mining database.

Appreciate your help.

Thank you,

and Connor said...

It will take 3 minutes 14.159265358979 seconds.

Seriously, that is totally dependent on

- your storage
- your I/O bandwidth
- your CPU
- your RAM
- what else is running
- etc etc etc

There's an easy way to find out ..... give it a try !

Is this answer out of date? If it is, please let us know via a Comment