# Bug V17.0.163 : invalid object - selection, CPU 100% **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [July 25, 2023, 11:48am UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893 "2023-07-25T11:48:18Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 25, 2023, 11:48am UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/1 "2023-07-25T11:48:18Z")
I am connected with SYSTEM user. I browse Invalid objects of a schema. I want to select one (PL/SQL), the TOAD process is 50% CPU, and not responding. ![image](https://global.discourse-cdn.com/quest/original/2X/a/a97cf0f754c42264b0132e0bef2104d6946026c9.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 25, 2023, 12:16pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/3 "2023-07-25T12:16:44Z")
As a diagnostic tool, do this: 1. Go to help-\> about. 2. When the window opens, type in the word: freeze (there is no "place" to type it, just start typing) 3. A "freeze detection" dialog will appear. Check the box and click ok. ![image](https://global.discourse-cdn.com/quest/original/2X/e/ece052764a6c4a045334c692b359540edf9b7a0c.png) 4. Go back to the schema browser and make the problem happen. 5. At some point you will see this. Check where it says "click here". ![image](https://global.discourse-cdn.com/quest/original/2X/2/269dcf0d41d262e71a860a0c6f87fd169dcfa7fe.png) 6. Then you'll see something like this: ![image](https://global.discourse-cdn.com/quest/original/2X/f/fb6fee2eabf033505869dffb0e3445f200a08754.png) 7. Check where it says "copy to clipboard" (please don't just CTRL+C yourself, you won't get everything). 8. Click OK, come back to this thread and paste the result here. That should tell me what's happening. Thanks. (After that, you can go back to help -\> about and type "Freeze" again to disable freeze detection, or just restart Toad) ---
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 26, 2023, 8:15am UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/4 "2023-07-26T08:15:30Z")
Diag. after freeze [TOAD\_DEBUG\_17Beta\_freeze.log](https://forums.toadworld.com/uploads/short-url/crEYilMxwhLhPa6rm5rqGLGErFe.log) (68.2 KB) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 26, 2023, 12:02pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/5 "2023-07-26T12:02:15Z")
Thank you for sending that. The parser is taking a long time to parse your database package. Can you send it to us? My email is [john.dorlon@quest.com](mailto:john.dorlon@quest.com) -John ---
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 26, 2023, 2:27pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/6 "2023-07-26T14:27:32Z")
On a new DB Oracle 12c, I created one package Y8\_MAP with error on schema TOAD. When I choose Invalid Objects, I clic on package body, TOAD freezes. On pacage is OK. ![Y8_MAP](https://global.discourse-cdn.com/quest/original/2X/1/1bcd30fa3841626c040f9433930c656c718db836.jpeg) I sent the PCK by mail. ---
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 26, 2023, 2:34pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/7 "2023-07-26T14:34:35Z")
Same on Package tab on Spec : ok on Body : freeze ![Y8_MAP_pck](https://global.discourse-cdn.com/quest/original/2X/7/70e95d1695fa638652daeab0a04dd1a01d2f3f07.jpeg) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 26, 2023, 2:37pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/8 "2023-07-26T14:37:44Z")
Hi Mara, Thank you for sending it. I tested it with your package. For me, the package loads quickly, and the package body takes about 10 seconds. Does it finish loading for you if you wait? I have a fast new laptop. If you have an older PC, maybe it will take up to a minute to load. I will see if there is something we can do to make it load faster. -John ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 26, 2023, 3:35pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/9 "2023-07-26T15:35:25Z")
I tested it with Toad 16.2 and it was faster. In version 16.3, we added an option to display package references in the navigator. That seems to be what slowed things down. As of now, turning off the option doesn't improve speed because that only controls the display, not the actual parsing. Starting in the next beta, you can right-click in the Editor navigator and uncheck "Show References" and that should help. ---
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 27, 2023, 12:06pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/10 "2023-07-27T12:06:32Z")
Perahps, you need to get the package reference only if the package is valid ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 27, 2023, 12:14pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/11 "2023-07-27T12:14:00Z")
No, the references are internal so it doesn't matter if the package is valid or not. So, for example in the screen shot below - the variable `g_post_tc_hook_exists` is used at line 640, column 13. And I can click where I've indicated to jump down to that line. ![image](https://global.discourse-cdn.com/quest/original/2X/c/ccc637b4bce3113b750396bd662a094e4d9e56df.png) ---
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 27, 2023, 2:11pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/12 "2023-07-27T14:11:03Z")
Yes, the problem is on all package body, with the Schema Browser (package Valid or NOT). I can see the code and references after 2 clics on popup message Freeze : ![Annotation 2023-07-27 160720](https://global.discourse-cdn.com/quest/original/2X/5/55cfdf80366ef440f06c7c1c32894903a5fbc43b.jpeg) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 27, 2023, 2:15pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/13 "2023-07-27T14:15:33Z")
In the next beta, these steps should make it faster: 1. Right-click in the Editor's navigator and choose "Navigator Options" 2. Then uncheck "Show References" You can actually do these steps now but they won't help performance now. In Monday's beta, performance will be better if the "Show References" option is unchecked. ---
**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\ **Post date:** [July 27, 2023, 2:30pm UTC](https://forums.toadworld.com/t/bug-v17-0-163-invalid-object-selection-cpu-100/57893/14 "2023-07-27T14:30:31Z")
Yes, I'll try it