Re: Best free Oracle performance tool?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 2 Feb 2003 11:35:59 -0800
Message-ID: <b1jruv029em_at_drn.newsguy.com>


In article <b0d65f38.0301311941.45ecab5f_at_posting.google.com>, vxn96_at_comcast.net says...
>
>Hi friends,
>
>Can someone tell me what's the best free tool for perf. monitoring?
>Hopefully, it's possible to find something like that :) I'm looking
>for semething simple, no fancy staff, although graphs and charts would
>help. Please advise.
>
>TIA
>
>Regards

autotrace in sqlplus for single queries. tkprof + sql_trace + timed_statistics for unit testing/tuning statspack for instance awareness
dbms_profiler for stored procedures

[Quoted] all come with -- you have them already. pretty much all I ever use. black and white text, no colorful graphs to throw you off track..

--
Thomas Kyte (tkyte_at_oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Sun Feb 02 2003 - 20:35:59 CET

Original text of this message