Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Version SQL Developer 21.4 is very slow

Any query will take at least 8 seconds,even "Select * from Dual". Using previous version any test query execute below 1 second.
Are there any new settings that has to be performed to get reasonable performance in 21.4?
Answers
-
Hi
I have the same problem with Version 21.4.0.346 Build 346.2239. Query against a table with 15 rows is running 7 seconds for the first time. If there is a syntax error in the SQL statement it always takes long. Compiling is also very slow. Feels like freezing. Please help
-
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.
-
De-select 'Enable Semantic Analysis Info Tip' in Preferences - Code Editor - Completion Insight.
-
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,
-
There's a lot going on in this thread...but I'm not seeing any slowdown in queries. It's not that I don't believe you, I do. I just need to be able to reproduce what you're seeing so we can fix something if there is something to fix.
I ran your query ...
No delay, 0.117 seconds.
-
11.2.0.4 - is basically no longer supported.
"Extended Support end date has been extended until 31st December 2020." That was a year ago.
" patch support for 11.2.0.3 has now ended (as of 27th August 2015). Currently only 11.2.0.4 is supported in terms of receiving patch fixes and only if and Extended Support fees have been paid."
-
Hi,
I ran your query ...
Sorry, not my query, SQL Developer's query! And (maybe) the problem is that it doesn't parse on 11.2.0.4...
But yes, I agree with you, there could be intermixed reports in this thread. Sorry about that.
Regards,
-
on 19c db...