This content has been marked as final. Show 4 replies
Application tracing tool is here..
956684 wrote:Get familiar with Oracle tracing tools mentioned above <tt> (<font style="background-color: #FFFFCC">trcsess, TKPROF</font>) </tt>
i am very new for <font style="background-color: #FFFFCC">performance tuning</font>, please any1 explain me about how to take trace for existing and what needs to be done..
<font style="background-color: #FFFFCC">
With these tools at your disposal, you can readily see where your performance bottleneck and hotspots take place.
Addition to the tools mentioned by stefan nebesnak.
DBMS_HPROF -- available in oracle 11g,
DBMS_SQLTUNE --it is a tuning advisor for the SQL queries. You can crate task and monitor the report.