GeekInterview.com
Series: Subject: Topic:
Question: 348 of 490

How to trace PL/SQL Package?
How to trace PL/SQL procedures?
How to trace SQL statement?
what is DBMS_TRACE? How to use?
SET AUTOTRACE ON; ?
If anyone tell me how we can use trace and create log that would be great?

Asked by: Interview Candidate | Asked on: Jul 21st, 2006
Showing Answers 1 - 2 of 2 Answers
Jian Zhang

Answered On : Oct 10th, 2006

When you want to see the execute plan of a SQL statement, you need to use TRACE function of Oracle.

  
Login to rate this answer.
sunflower

Answered On : Feb 22nd, 2007

DBMS_TRACE package can be used to keep track of the calls between the subprograms and trace of execution by sub-program, procedures, functions or an exception. It gives a large amount of trace data. To make this particular trace data more readable. TKPROF tool , is used to make the trace data in a report format. A typical session involves:Starting PL/SQL tracing in session (DBMS_TRACE.SET_PLSQL_TRACE). Running an application to be traced. Stopping PL/SQL tracing in session (DBMS_TRACE.CLEAR_PLSQL_TRACE).

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.