Version SQL Developer 21.4 is very slow

Hello,

Menu View -> Log (Ctrl + shift + L)

Can you have a look at the Logging Page and Statements tabs, see if there's anything abnormal there?

Also, what is the target database version?

Using Oracle 11.2.0.4—sorry!—right now I'm seeing the following errors:

Caused by queries obviously not suited for this (venerable) Oracle release:

select distinct aa.owner, aa.package_name, aa.subprogram_id, aa.object_name, aa.overload, aa.argument_name, aa.position, aa.data_type, aa.data_length, aa.in_out, aa.type_name, aa.type_subname, aa.type_link, aa.type_object_type, aa.pls_type, aa.char_length, aa.char_used, aa.defaulted from all_procedures ap, all_arguments aa where aa.object_id = ap.object_id and ap.subprogram_id = aa.subprogram_id and aa.package_name = ap.object_name and aa.owner = :OWNER and aa.package_name = :PACKAGE order by aa.owner, aa.package_name, aa.subprogram_id, aa.object_name, aa.overload, aa.position

And:

select attributes from all_plsql_types where owner = :OWNER and package_name = :PACKAGE and type_name = :OBJECT

And apparently SQL Developer keeps trying... and trying... and trying...

Afraid I might have to go back to 21.2... 😕

Regards,

P.S. MOS Doc 2828123.1 makes it clear that Log4j is a non-issue in any release of SQL Developer, so there's no rush either.

I see the same behaviour in 21.4. Queries take much longer to show results.

It works fine on 21.2 on the same database.

21.2

21.4

Hi,

@Alastair M : Thanks! I might try that.

So far I'm back on 21.2 (for my day-job duties). Meanwhile, I've always had 'Enable Semantic Analysis Info Tip' checked in 21.2 and prior versions...

I took an ASH report and a session trace of the hanging session this morning. The ASH report says that all time was spent on SQL id 4mrsvxt0ppwdu (select distinct owner, object_name from all_procedures order by owner, object_name ), not fast in any case yet executed repeatedly: 108 sampled execs in ASH... And all that was triggered (apparently) as I called a small SQL script (@tinyscript) in the SQL worksheet.

The trace file also shows a couple of dozens of failed parses, of the following queries:

The following statements encountered a error during parse:

select distinct aa.owner, aa.package_name, aa.subprogram_id, aa.object_name, aa.overload, aa.argument_name, aa.position, aa.data_typ
e, aa.data_length, aa.in_out, aa.type_name, aa.type_subname, aa.type_link, aa.type_object_type, aa.pls_type, aa.char_length, aa.char
_used, aa.defaulted from all_procedures ap, all_arguments aa where aa.object_id = ap.object_id and ap.subprogram_id = aa.subprogram_
id and aa.package_name = ap.object_name and aa.owner = :OWNER and aa.package_name = :PACKAGE  order by aa.owner, aa.package_name, aa
.subprogram_id, aa.object_name, aa.overload, aa.position

Error encountered: ORA-00904
--------------------------------------------------------------------------------
select attributes from all_plsql_types where owner = :OWNER and package_name = :PACKAGE and type_name = :OBJECT

Error encountered: ORA-00942
--------------------------------------------------------------------------------
select distinct aa.owner, aa.package_name, aa.subprogram_id, aa.object_name, aa.overload, aa.argument_name, aa.position, aa.data_typ
e, aa.data_length, aa.in_out, aa.type_name, aa.type_subname, aa.type_link, aa.type_object_type, aa.pls_type, aa.char_length, aa.char
_used, aa.defaulted from all_procedures ap, all_arguments aa where aa.object_id = ap.object_id and ap.subprogram_id = aa.subprogram_
id and aa.package_name = ap.object_name and aa.owner = :OWNER and aa.package_name = :PACKAGE  and aa.object_name = :OBJECT  order by
 aa.owner, aa.package_name, aa.subprogram_id, aa.object_name, aa.overload, aa.position

Error encountered: ORA-00904

Possible explanation: the database version (11.2.0.4) was not correctly detected or handled, causing SQL Developer 21.4 to submit data dictionary queries which could not be parsed successfully on that DB version. The resulting exception was not handled gracefully/appropriately, causing SQL Developer to try again multiple times.

Somehow the hanging ended by itself before I attempted to kill the session, so that was not an infinite loop, just a bunch of very slow queries repeated plenty of times... ☹️

Regards,