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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |