SqlDbx Forum

SqlDbx

You are not logged in.

#1 2018-11-13 08:09:17

jcantao
Member

Very long time connection to a Oracle 11g (SQLDbx Personal or Pro)

When I connect to my Oracle 11g database (Oracle Database 11g Release 11.2.0.3.0 - 64bit) SQLDBX Personal take one hour or more to conclude. There is no problem about exection of regular queries. The main problem is connection time only. The principal query executed during SQLDBX connection process take 30 seconds approx., what don´t explain the time to up the application. Recently my company have purchased a SQLDbxPro license and the remains the same. There any way to fix this ?

Offline

#2 2018-11-20 08:47:04

timeco
Member

Re: Very long time connection to a Oracle 11g (SQLDbx Personal or Pro)

Two things. It all comes to the fact Sqldbx reads data from Oracle Metadata views when starting. Your database is either LARGE or heavily fragmented.

1. Check the Sqldbx Options / Servers / Oracle Server / Show Table Row Count  checkbox.  Try unchecking it.
2. Sqldbx Options / IntelliSense / Include Schemas / Databases  checkbox.  Try unchecking it.
3. Try executing this query and report the execution time to confirm metadata query issues:

SELECT
        OBJECT_NAME,
         OWNER,
         OBJECT_TYPE,
         0 ISSYSTEM,
         LAST_DDL_TIME,
         TEMPORARY,
         '',
         CREATED,
         STATUS
  FROM   SYS.ALL_OBJECTS O
WHERE   O.OWNER = 'DWH'  -- your shema here
         AND OBJECT_NAME NOT LIKE ('ISEQ$$_%')
         AND OBJECT_TYPE IN
                  ('FUNCTION',
                   'MATERIALIZED VIEW',
                   'PACKAGE',
                   'PROCEDURE',
                   'SEQUENCE',
                   'TRIGGER',
                   'TYPE',
                   'VIEW')
;


Let me know if any of this works. We'll go from there.

Offline

Board footer

Powered by FluxBB