Aqua Data Studio's settings, options, connection files, and configurations are designed to be easily backed up, copied, and modified. It is possible to transfer all or some of the files which are used for database server and SSH server registrations to another user or another computer. The locations of these files vary based on the Operating System.
Aqua Data Studio stores all application customizations and server registrations in the [USER_HOME]\.datastudio directory. [USER_HOME] is the home directory of the current user logged into the Operating System.
All database and ssh server connection configurations are stored in the \.datastudio\connections directory and sub-directories, with a connection file for each server in the appropriate directory. Users may exchange and share server connections by transferring individual files for each server.
If you have suddenly lost all of your registered servers, it's possible that an environment variable for your USERPROFILE changed recently. To check where Aqua Data Studio is looking for your connection files, click on the Schema Browser tree node "Local Database Servers" at the very top of the Schema Browser. At the bottom left of the Main Application window, the status bar will indicate the path Aqua Data Studio is currently using for its connection files.
The path Aqua Data Studio uses is automatically picked up from the Windows environment variable named USERPROFILE. In a command prompt, you can type "SET" and see a list of environment variables to double-check the value.
You can change what Aqua Data Studio is using for a specific path if you pass this value to the JVM ( where C:\Documents and Settings\username is the location you've discovered for your lost connection files)
It may sound strange but if I run the same query in Aqua data studio it takes long time for output to come. If I run the same query in sqlplus its comes within 1 sec . I am having both softwares (Aqua data and sql server ) on my machine . Using oracle 10g .This thing happens to everyone in my team .Something is strange about Aqua data studio. Has anyone experienced this kind of issue before. (May be in toad or other 3rd party tool)
I have come across similar. I have never used Aquastudio however to be diligent have you checked in Oracle to see if any transformation of the SQL you think you are executing has not been transposed into generic sql that the drivers have adjusted.
7fc3f7cf58