Intermittently consuming 95% of my CPU when I load a big package. (4300987)

Toad will use 95% of my CPU when I load a big package, procedure script. Toad uses a lot / high CPU power resources. This issue does not happen on Toad 11.0.

WORKAROUND:

Go to View menu | Toad Options | Editor | Display | and un-check all 3 “Syntax Highlighting” check boxes (un-check “Highlight table names”, “Highlight view names”, and “Highlight stored procedure names”).

STATUS:

Waiting for fix in a future release of Toad for Oracle.

A workaround exists for the performance CR if the user's want to keep highlighting of object names. It requires manually setting up the highlighting and requires active maintenance if objects are created or dropped to keep the list up to date.

- Uncheck the option to highlight PL/SQL objects.

- Get a list of all PL/SQL objects. This is the query we use in Toad. I just exported the list to clipboard and pasted it in Notepad. Do whatever search and replace is necessary to get the list such that one object name exists on each line. Also remove the OBJECT_NAME header on line 1 if it exists.

SELECT object_name
FROM user_objects
WHERE object_type IN ('PACKAGE', 'FUNCTION', 'PROCEDURE');

- Configure the PL/SQL syntax highlighter.

Edit the PL/SQL language, select Rules tab, and click "Copy from..." Copy the Toad_UserProcs rule from the PL/SQL language. The newly created rule will be at the bottom of the list although it should probably be selected and scrolled to, ugh. Select it and select the Conditions tab. Click the + to add a new condition, select Identifier, uncheck "Include all tokens," paste in your list of object names.

These steps should be repeated for the table highlighting option as well as the view highlighting option if desired.