Long connection time with 11.5
Louis BROUILLETTE <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hi all, I recently installed TOAD 11.5 and now the connection time is very long (near 2 minutes in development db). Using SQL Tracker, I can see that it is executing lots (thousands) of this statement (with differents runid et unit_number): SELECT line#, total_time, total_occur, min_time, max_time, text FROM plsql_profiler_data WHERE runid = 2899 AND unit_number = 9; The TOAD.PLSQL_PROFILER_DATA table has more than 429000 rows. I believe the above statement is executed that much times. Do I have to truncate that table or can I inactivate something ? -- Louis Brouillette Chargé de projet informatique et technologique (DBA) Université du Québec à Trois-Rivières Tel: (819) 376-5011 ext. 2435 Email: [email protected] ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/toad/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/toad/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/