we upgrade from 11g rel2 db to 12c rel2 db
the schema browser on startup takes more then 3 min to open.
I found that this select in the background is the reason for this:
Select t.table_name, user as owner, t.cluster_name,
t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed, round(t.num_rows) num_rows,
t.initial_extent, t.degree, t.logging, t.cache, t.buffer_pool
, t.monitoring, t.temporary, t.table_type, t.table_type_owner, t.nested
, t.Compression, t.dropped
, t.compress_for, t.flash_cache, t.cell_flash_cache, t.segment_created
from sys.user_all_tables t
order by table_name;
this select brings the table list in the schema browser
I already run the statistics on sys and system schema and on fix objects - not helping
what is your recommendations to improve the loading time?