![aqua data studio increase memory aqua data studio increase memory](https://img1.wsimg.com/isteam/ip/04433131-cbb7-4d56-8eab-043900564722/20200615_035651.jpg)
ADS cannot detect third-party client commands and symbols. Before sending scripts to the server, these tools extract “client-side” commands, and send only “server-side” commands to the database. These are processed on the client side-they are not accepted by the server. Some database commands or symbols (such as “ ”) do not work in Aqua Data Studio while they do work in the database vendor’s command line tool.Ī: Most command line tools provided by vendors accept their own specific commands and symbols. Q: Scripts with multiple statements return errors. However, many DBAs configure the database servers to timeout inactive database connections, and sometimes firewalls are set to timeout socket connections. Q: Aqua Data Studio gets disconnected after a certain period of time.Ī: Aqua Data Studio does not timeout user connections.
![aqua data studio increase memory aqua data studio increase memory](https://sko.dziesieciotysieczny.pl/templates/f16dc396e088c7c707eabe9d7479e7a2/img/866f0615c3e5d010bafc35caf60c4804.jpg)
You may increase the size of memory allocated to the JVM to increase Aqua Data Studio’s memory capacity. Q: Executing queries that have large result-sets cause Aqua Data Studio to hang or crash.Ī: Aqua Data Studio is a Java application, and is limited to the size of memory allocated to the Java Virtual Machine (JVM) at startup. Such issues can be easily isolated and corrected by users. Q: Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior.Ī: All unstable behavior is caused by 1 of 3 things: 1) outdated video drivers, 2) incorrect Java Virtual Machine or 3) an incompatible Oracle Client/JDBC mismatch with the use of the “Oracle – OCI” connection type.