Sqldeveloper file open dialog freeze

oracleoracle-sql-developer

When I try to open a file using the file open dialog, sqldeveloper freezes for almost a minute. After that the dialog opens at the user temp folder.

I think it is trying to access some unavailable network location:

promon

However, I can't figure out how to make it "forget" that location. I tried to select a local file in the dialog, but next time all repeats.

Best Answer

sql developer was taking a long time to open files dialog. I found out that it was because it is opening local temp folder which has a huge amount of files. Guess what, these files are being generated by sql developer. They are name amcXXXX.tmp. I didnt find how to avoid its generation though.