Oracle - Timeout

[mcardia]

Oracle connection takes to long to load and most of the time it raises timeout.

I think it's related with oracle owner with a big dictonary.

I don´t know how the extension load the list of table/objects for the explorer/navigator, but,
if it´s using dba_* or all_* views, i would suggest to use user_* views and ignore public synonyms.

• SQLTools Version 0.19.3
• VSCode Version: 1.33.1
• OS: Windows

[mickeypearce]

hey @mcardia ,

extension uses queries from https://github.com/mtxr/vscodesqltools/blob/master/packages/core/dialect/oracle/queries.ts file to load tables: fetchTables, columns in tables fetchColumns, functions/procedures fetchFunctions, etc...

There is an open issue related about displaying only current user objects versus all objects with a parameter "sqltools.onlyUsersObjects" #218 Maybe just switching to user_* tables would make a difference as you suggest.

But loading a heavy schema can definatelly be a problem in every case. If you can optimize the queries please go ahead... That would be awesome. Or if you could find out which of these quieries takes the most time in your case would be also very beneficial and helpful.

Thank you very much in advance if you could provide this additional information or a PR.

[mtxr]

I must take a look on #218.

I think we are having a feel issues because of loading all data after connecting

[mtxr]

Not supported within this repository anymore.