I have a strange issue. Using SQL Developer Version 21.4.3.063 on MacOS.
After a recent upgrade to Oracle 19 if I login as my production user and expand it's list of tables it takes over 30 seconds to display with a "running" progress bar displayed in the lower right footer.
If I connect to our development server using similar user account it expands almost instantly.
If my DBA connects as system and expands the production user table list it is also instant but when he logs in using the user login he gets the same issue of taking over 30 seconds to expand.
This database 1007 tables.
Smaller schema which has only 77 tables also takes over 30 seconds to expand.
Even Smaller schema which has only 22 tables takes 18 seconds to expand.
The fact that the DBA can open as system and get instant results while the user accounts all take 18-30 seconds seems to exclude network issues.
Just running a query of tables is instant as well.
SELECT * FROM user_tables ORDER BY table_name;
So I don't know what SQL Developer is doing that is taking so long.
I don't understand why it only happens on one machine and not the other when they are both Oracle 19 instances.