Poor performance when connecting to Oracle E-Business Suite APPS schema. (15619)

Toad experiences poor performance when connecting to Oracle E-Businees Suite APPS schema.

WORKAROUND:

1. Connect to the database using a database user other than APPS. Typically there are other accounts which are read-only. Connecting with one of these users will not take nearly as long to connect to the database as the APPS user. However, some functions will not behave properly without some grants and/or synonyms.

2. Select View | Options | Oracle | General, set the OCI Array Buffer Size to a minimum of 500.

3. Select View | Options | Windows, remove the check mark from the Auto Open box for Schema Browser.

4. On the right-hand side of the Schema Browser, select the Browser Style drop-down and select Tabs. This allows a default tab to be selected. Next, click Configure from the Browser Style drop-down, disable the disired items and select an object type that will load fast no matter which user is used to login, for example, Sequences. Then move the object type to the top of the list, to make it the default tab upon opening the Schema Browser.


STATUS:

An enhancement request has been submitted to Development for consideration in future release of Toad for Oracle.