SQL Developer does not return query result. No error message.

user9138393

I have downloaded SQL developer 20.4.1.407.

I am able to connect to the database.

Once I write a query and try to run it, it's working forever with no result.

SELECT count(*) 

FROM table1 t1

LEFT JOIN table2 t2

ON t1.column1 = t2.colimn2;

it's not giving me any response, neither output nor error. If I check run button (on top bar of sql developer) all options are disable.

thatJeffSmith-Oracle

forever = longer than you're willing to wait?

some queries can take days if they're not well written - how many rows are in table 1 and table 2?

user9138393

forever means, for example, that "monitor session" indicate that job is done (became inactive), but I don't see the result. Or, if I run "create table ... as select ..." statement, table is already created, session already inactive, but I don't see any indications on a main screen where I am running it. It looks like still running. I can close application only through Task Manager.

thatJeffSmith-Oracle

a session trace and a java jstack dump would help us see what's actually happening