Oracle

Oracle: UnsatisfiedLinkError when connecting using the Oracle OCI driver
DbVisualizer 13.0 If using the Oracle OCI driver you may encounter the following exception when trying to connect.  Details:    Type: java.lang.reflec...
Wed, 22 May, 2024 at 11:52 AM
Oracle: Single Sign-On (SSO) using Kerberos
In addition to the standard Java configuration for Kerberos, there are a few steps that needs to be done to connect to Oracle with Kerberos. The following s...
Tue, 12 Apr, 2022 at 5:25 PM
Oracle: Bad performance running queries
If you experience bad performance when running queries in Oracle check the Set query fetch size article for more information.
Thu, 4 Mar, 2021 at 8:06 AM
Oracle: Connecting to Oracle Analytics Cloud Autonomous Data Warehouse using Oracle Wallet
Prerequisites DbVisualizer installed Wallet zip file downloaded from the Oracle Analytics Cloud Autonomous Data Warehouse (OAC ADW) admin.  Downloading...
Tue, 12 Apr, 2022 at 9:45 PM
Oracle: Stored procedure/function columns are listed several times
Note: This applies only when using DbVisualizer Free or when the "generic" database profile is loaded in DbVisualizer Pro. Selecting a stored ...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: Stored procedures/functions are displayed several times
Note: This applies only when using DbVisualizer Free or when the "generic" database profile is used in DbVisualizer Pro. Stored procedures/fun...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: Some stored procedure/functions are displayed as "xx.yy" in the database objects tab
Note: This applies only when using DbVisualizer Free or when the "generic" database profile is loaded in DbVisualizer Pro. Oracle has the abil...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: DDL tab doesn't show for Oracle even if using Oracle 9 or later
The DDL feature requires a JDBC 3 compliant driver. Make sure you your are using the latest available JDBC driver from the Oracle web site.
Mon, 27 Jul, 2015 at 2:32 PM
Oracle: How do I execute SELECT statements that contain hints
Oracle hints are supported from DbVisualizer 8.0. The following is applicable for older versions. Block comments identified by /* ... */ are automa...
Wed, 12 Jul, 2017 at 7:56 PM
Oracle: Synonyms are not displayed in the Query Builder or when using auto completion in the SQL editor
In the Properties tab for the connection, select Driver Properties. Then either locate the includeSynonyms parameter in the list or insert it. Set the value...
Wed, 12 Jul, 2017 at 7:57 PM