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