sql server 2005 - How to run a trace in oracle which can capture reads, writes, cpu and duration of queries -


In the SQL Server terminology, this is PROFILER

what is in the ORACLE vocabulary (What is the title question) ?

Or is there a third party tool (FREE) that does a job?

Thanks for

please

You will use in Oracle. There is a lot to go for in a reply to the SO, but the essence is that you "turn on" the SQL Trace session level (usually), resulting in a trace file written on the server as your information. . Use the TKPROF program to convert the trace file to a readable report.

To turn on SQL Trace in SQL Plus session:

  SQL & gt; Set session sql_trace = true;  

After that everything is logged in the trace file until you release it:

  SQL & gt; Set session sql_trace = false;  

You will then need to find the generated .trc file on the server and convert it to a report using TKPROF in some way:

  OS & gt; ; Tkprof xxxx.trc mytrace.txt  

You see mytrace.txt with a text editor. There are several options in the tkprof command that are listed in the above link.

DBMS ICSSEST


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -