Data compare for oracle slow at initializing stage

Every time I run a compare, it starts with initialising, registering database one, registering database two. These three steps can take 3 to 4 minutes. The actual table compare doesn't take that long.

Is there something that can be done to speed up the initialization stage? 
Tagged:

Answers

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi, Thank you for your forum post.

    There are no options that you can configure that will speed up the initialization process.  In the background the comparison engine is querying various Oracle data dictionaries.  By default it will attempt to use the dba_<dictionary_name>, for example dba_tables and if this is unsuccessful, it will switch to using the all_<dictionary_name>, for example all_tables.  The process identifies the dependencies between object in the schema being compared.  The switch from using dba_ to the all_ equivalent as been know to take a little time.

    To continue investigating, I recommend increasing the minimum logging level to verbose and repeat the running of the project.

    To increase the logging level using the GUI, please follow the steps in this help document, which also has instructions on how to obtain the log files.

    If using the command line, add the /loglevel:verbose switch to your command line syntax which will generate the log file each time this command line task is run.  Further reading on the command line switches is available here.

    Please reply with a copy of the log file generated, which may identify the process holding up the initialization.

    Many Thanks
    Eddie
     
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.