Forum Stats

  • 3,836,792 Users
  • 2,262,193 Discussions


High CPU usage after auto-complete/template expansion fail

User_TMTV7 Member Posts: 6 Green Ribbon
edited Feb 22, 2022 10:44AM in SQL Developer

The issue I see is that, when auto-complete fails, sqldeveloper hits high CPU usage (somewhere around 70%) as shown by 'top'. Once sqldevloper hits that state, it remains so; and the only way out is to restart the application. Obviously, I'm on Linux (CentOS) where I see this.

An example: I've a a template $tn that expands to ticket_number, a common column in our tables. Sometimes, I've to hit control+space multiple times to get that to expand. At times it won't expand at all ($tn then turns red), and that's when the CPU usage shoots up. And from that point onward, no auto-completion works. App restart is the only way out.

I'm currently on 21.4.2. I hit the issue multiple times on a good day, so it's not very exciting to restart the application multiple times. I'd like to know if this is a known issue, and/or where I can submit a bug report. Happy to offer any diagnosis I can.