Schema compare takes REALLY long time
theotherhand
Posts: 2
I turned on logging, and here is one particular line that is taking a long time to run.
Any advise on speeding up the compare would be much appreciated.
08:22:54.931|Debug |Object Model |15 |-- Executing query
WITH m_owners AS
(
SELECT 'GMS' as owner from dual
UNION ALL
SELECT 'GMSTIB' as owner from dual
UNION ALL
SELECT 'CPS' as owner from dual
UNION ALL
SELECT 'CPSSEC' as owner from dual
UNION ALL
SELECT 'CPSTIB' as owner from dual
UNION ALL
SELECT 'GMSAPPL' as owner from dual
)
SELECT dba_col_comments.owner, dba_col_comments.table_name, dba_col_comments.column_name, dba_col_comments.comments FROM dba_col_comments, m_owners
WHERE dba_col_comments.comments IS NOT NULL AND dba_col_comments.owner = m_owners.owner;
08:22:55.043|Debug |Object Model |15 |Query returned reader in : 111 ms
08:22:55.324|Debug |Object Model |15 |Populating columns took 417244 ms
Any advise on speeding up the compare would be much appreciated.
08:22:54.931|Debug |Object Model |15 |-- Executing query
WITH m_owners AS
(
SELECT 'GMS' as owner from dual
UNION ALL
SELECT 'GMSTIB' as owner from dual
UNION ALL
SELECT 'CPS' as owner from dual
UNION ALL
SELECT 'CPSSEC' as owner from dual
UNION ALL
SELECT 'CPSTIB' as owner from dual
UNION ALL
SELECT 'GMSAPPL' as owner from dual
)
SELECT dba_col_comments.owner, dba_col_comments.table_name, dba_col_comments.column_name, dba_col_comments.comments FROM dba_col_comments, m_owners
WHERE dba_col_comments.comments IS NOT NULL AND dba_col_comments.owner = m_owners.owner;
08:22:55.043|Debug |Object Model |15 |Query returned reader in : 111 ms
08:22:55.324|Debug |Object Model |15 |Populating columns took 417244 ms
Comments
Thank you for your forum post and sorry for the delay in replying to you.
There is not an option as such that will magically speed up the comparison process. From experience supporting Schema Compare for Oracle having the Oracle Client installed on the Windows machine running Schema Compare and / or using a sysdba or system user account to connect to each Oracle database has been known to improve performance.
Obviously if you have the Oracle client installed and using a system or sysdba account, this advice will not help you.
A support ticket has been created for you. Please send an email to support@red-gate.com and enter 'Support call #50015' into the subject field of the message.
In the email, please include the following information:
1. Version of Schema Compare for Oracle?
2. Version of Oracle each data source for the comparison is using?
3. If the Oracle Client is installed?
4. Attach a copy of the log file you generated for me to review?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
As per support call #50015, I believe this call is now resolved after upgrading to V3.1.3.806. The Development Team, made some improvements to one of the queries used to obtain information regarding the schema.
If other users are reading this post, please use this LINK to download V3.1.3.806 if using an earlier version. Otherwise, please email support@red-gate.com to create a new support ticket.
Many thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com