Skip to content

Unable to connect to a large Oracle database with thousands of tables #907

@jhaddonNHS

Description

@jhaddonNHS

First of all, thanks for your efforts with this extension. I use it for other databases and it would be great to use with Oracle too.

Bug Description

When connecting to a large Oracle database with thousands of tables, the connection fails because I suspect it is scanning tables / performing introspection and there doesn't appear to be any way of preventing it. When attempting to select the connection to run a SQL query, it shows the database, then the loading circle continues forever (I tried waiting over 30 mins).

Repro steps

  1. Create an Oracle connection to large Oracle database (with many schemas and tables)
  2. Try to connect
  3. Connection never completes
  4. See error

Expected Behavior

Ideally it would be possible to prevent introspection at this point to at least enable querying the database, even with the additional functionality unavailable.

Actual Behavior

Unable to use the extension for this database.

Environment

  • DBCode version: 1.23.3
  • VS Code (or fork) version: 1.107.1
  • OS: W11
  • Database: Oracle 19c
  • Connection: (direct/SSH/SSL) Direct

Logs

No logs displayed

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions