When SQL Developer Is Idle I Lose My Connection

How can I keep Oracle SQL Developer from closing the DB connection?

This doesn't sound like an issue with SQL developer, cetainly I've never come across it. Are you sure it's not something else, like your network? What happens if you connect from SQL plus from your desktop.

What SQL or PL/SQL on Oracle 11g would keep a connection from being idle?

If you have access to dbms_lock you can create an infinite loop that sleeps 60 seconds each time. If you don't have access to dbms_lock try user_lock.sleep instead, although that function is not installed by default. (And if you do use it, change the 60 (seconds) to 60000 (milliseconds)).

begin
    for i in 1 .. 9999999 loop
        dbms_lock.sleep(60);
    end loop;
end;
/

SQL Developer 4.0 extensions not loading

As noted in the early adopter release announcement:

All 3rd party extensions are currently disabled – our framework has
changed such that they will need to be updated to be compatible with
the new version

The extension developers will need to update their extensions; if there is not already a new version available you'll need to contact them directly to ask for this to be done, it's not something Oracle has control over really. This and this might also be of interest. As mentioned in the release notes, issues with the early-adopter version should be reported on the SQL Developer forum.

---

Related Topics