Introspection of "table and view defaults" is failed after 1 hour with message: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
The query from database.log for this task return 21892 rows, it was selected just one schema.
with my_objects as ( select object_id, object_name
where owner = ?
-- and last_ddl_time >= :since
-- and object_name in ( :[*major_object_names] )
and object_type in ('TABLE','VIEW') )
data_default as default_expression
from my_objects T,
where C.owner = ?
and C.table_name = T.object_name
and data_default is not null
-- and identity_column != 'YES'
order by object_id, column_id;
To consult the first 500 records, DataGrip spends 1 minute and 30 seconds, for comparison, SQL Developer needs only a couple of seconds; with the same connection configuration. So this speed is not ok.
DataGrip 2020.1.2 on Windows 10 Pro
Connection Driver: Thin
DBMS: Oracle (ver. Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options)
Case sensitivity: plain=upper, delimited=exact
Driver: Oracle JDBC driver (ver. 18.104.22.168.0, JDBC4.2)
Ping: 183 ms