Connection process, PL/SQL block invokes delay trying to connect in 12.x, not in 11.x (4275279)

Chat now with support

Zurück

Titel

Connection process, PL/SQL block invokes delay trying to connect in 12.x, not in 11.x
Beschreibung

Within Toad for Oracle 12.x connection process, this PL/SQL block is invoked.
-- Look for Team Coding synonym
FOR i IN syns.FIRST .. syns.LAST
LOOP
BEGIN
Select table_owner, table_name
INTO local_owner, local_table
FROM sys.ALL_SYNONYMS
WHERE owner = 'PUBLIC' AND synonym_name = syns (i);
In Toad for Oracle 12 executing this block causes a near three minute delay
We have installed the latest version of TOAD 12.8, and we have the same problem.
However, in Toad for Oracle 11, this block is not invoked. Thus, there is no delay.

Anmeldung erforderlich

Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.

Empfohlener Inhalt

Produkt(e):: Toad for Oracle
13.3, 13.2, 13.1.1, 13.1, 13.0, 12.12, 12.11, 12.10, 12.9, 12.8, 12.7