SqlDbx
You are not logged in.
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
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