Hi
on our development environment the query on sys.all_cons_columns is realy slow on our oracle11 server. 10 to 12 seconds! Yes, seconds not milliseconds.
i already tried (without effect):
dbms_stats.gather_fixed_objects_stats;
dbms_stats.gather_dictionary_stats;
dbms_stats.gather_schema_stats('SYS');
I know i can turn this off on the dataset.
Do you know a way to optimize this?
thanx in advance,
kind regards
Ruud
Last edited by Ruudbern; 10/16/14 03:15 PM.