Toad takes hours to connect to an Oracle database even though SQL*Plus takes seconds to connect. The database connection is hanging due to this block being executed when Toad is connecting to the database.
BEGIN IF DBMS_UTILITY.IS_CLUSTER_DATABASE THEN :RetVal := 1; ELSE :RetVal := 0; END IF; END;
RetVal = <NULL>
The DBMS_UTILITY.IS_CLUSTER_DATABASE procedure may be invalid, or may not exist in the Oracle database. This anonymous block is used to determine if the database is a RAC instance or not. Users requests that Toad should have an option that would toggle this query from being executed prior to a database connection.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center