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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.