A new topic, 'query taking 100 seconds', has been made on a board you are
watching.
You can see it at
http://liquibase.org/forum/index.php?topic=695.new#new
The text of the topic is shown below:
Hi,
I'm new here so please direct me to the right location if this question is old.
On our production environment we're running liquibase 1.9.5 on Oracle 11g and
it takes very long time, like an hour or more for each update. DBA stopped it a
few times and it was executing the following query:
SELECT NULL AS pktable_cat,
p.owner as pktable_schem, p.table_name as pktable_name, pc.column_name
as pkcolumn_name,
NULL as fktable_cat, f.owner as fktable_schem, f.table_name as
fktable_name, fc.column_name as fkcolumn_name, fc.position as key_seq,
NULL as update_rule,
decode (f.delete_rule,'CASCADE',0,'SET NULL',2,1) as delete_rule,
f.constraint_name as fk_name,
p.constraint_name as pk_name,
decode(f.deferrable,'DEFERRABLE',5,'NOT DEFERRABLE',7,'DEFERRED',6)
deferrability
FROM all_cons_columns pc, all_constraints p,
all_cons_columns fc, all_constraints f
WHERE 1 = 1
AND p.table_name = :3
AND p.owner = :1
AND f.constraint_type = 'R'
AND p.owner = f.r_owner
AND p.constraint_name = f.r_constraint_name
AND p.constraint_type = 'P'
AND pc.owner = p.owner
AND pc.constraint_name = p.constraint_name
AND pc.table_name = p.table_name
AND fc.owner = f.owner
AND fc.constraint_name = f.constraint_name
AND fc.table_name = f.table_name
AND fc.position = pc.position
ORDER BY fktable_schem, fktable_name, key_seq
So I ran this query manually on the same DB and it takes like a 100 seconds to
execute.
On my local DB ( Oracle 10g ) it takes like 4 seconds but my DB is empty with
no data, while our production DB runs a lot of schemas there so that is why the
amount is much bigger.
So I just wanted to know if it is a known bug or does anyone have solutions for
this?
Thank you for any information in advance
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
