Introspection of "table and view defaults" never finished. Oracle, DataGrip 2020.1.2

Answered

hello.

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
                     from sys.DBA_objects
                     where owner = ?
                       --  and last_ddl_time >= :since
                       --  and object_name in ( :[*major_object_names] )
                       and object_type in ('TABLE','VIEW') )
select table_name,
       column_name,
       data_default as default_expression
from my_objects T,
     sys.DBA_tab_columns C
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

Test Conection:
DBMS: Oracle (ver. Oracle Database 11g Enterprise Edition Release 11.2.0.4.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. 12.2.0.1.0, JDBC4.2)
Ping: 183 ms

2 comments
Comment actions Permalink

This is known issue and we are working on it here

 

0
Comment actions Permalink

Yuriy, thank you.

0

Please sign in to leave a comment.