Timeline for Oracle simple count(*) SQL query takes "forever"
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 24, 2021 at 15:53 | comment | added | ggo | Thanks Andrew. The query you suggested to retrieve schemas is exactly the one I had chosen to use too. | |
| Oct 23, 2021 at 19:24 | comment | added | Andrew Sayer | If you want to raise the performance issue of SQLTables() to Oracle then you will need to log it with them directly. Either as a support case (support.oracle.com) which requires a support contract, or maybe unofficially through their community pages (maybe community.oracle.com/tech/apps-infra/categories/… ). | |
| Oct 23, 2021 at 19:21 | comment | added | Andrew Sayer |
Rather than running SQLTables(), use the SQL statement select username from all_users. That said, this sort of query is the sort of thing a developer would be running manually when they are trying to figure out the data model, using ODBC for this is not typical, you would use something like 'SQL Developer' or 'toad' (or a command line alternative). I tried to replicate what you were doing but it seems SQLTables isn't implemented easily by the .net ODBC class (I'm using powershell) so I'd have to write some "proper" code to run it - I would rather just fire up SQL Developer etc.
|
|
| Oct 23, 2021 at 15:03 | comment | added | ggo | Just for fun: retrieving the list of schema with the Oracle ODBC Driver took almost 40 minutes! (loool). I believe that Oracle really should do something about that. Well, maybe I'm the only one retrieving the list of schema in the world from an Oracle database, so no one has ever reported this problem. | |
| Oct 23, 2021 at 14:17 | comment | added | ggo | The Oracle ODBC Driver 19c seem to s**k as much as the 12c when it has to retrieve the list of schemas from the database with SQLTables(). I guess that both must use the same query (did not investigate). Fortunately there are other ways to retrieve this list. | |
| Oct 22, 2021 at 13:31 | comment | added | ggo | Thank you @Andrew. Just for the record, the Oracle 12c ODBC driver (at least on Windows, x64) seems to use this view when a program asks the list of schemas (with the SQLTables() ODBC API); and it takes a very long time. Maybe it's better with other versions of the ODBC driver. I will try. | |
| Oct 21, 2021 at 10:21 | vote | accept | ggo | ||
| Oct 20, 2021 at 18:08 | history | edited | Andrew Sayer | CC BY-SA 4.0 |
added 228 characters in body
|
| Oct 20, 2021 at 18:03 | history | answered | Andrew Sayer | CC BY-SA 4.0 |