explain tkprof?
Answer / sikdar
TKPROf is one of the most useful utilities available to
DBAs for diagnosing performance issues. It essentially
formats a trace file into a more readable format for
performance analysis. The DBA can then identify and
resolve performance issues such as poor SQL, indexing, and
wait events.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can a text file be attached to a report while creating in the report writer?
Explain how can you use the same lov for 2 columns?
WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?
With which function of summary item is the compute at options required?
State any three mouse events system variables?
What is the difference between $$DATE$$ & $$DBDATE$$
what are Navigational Triggers?
can u call procedure or function is sq l query in reports
What are the different types of Delete details we can establish in Master-Details?
What is WHEN-Database-record trigger?
What is responsibility and how u attach How to create user and how u attach with responsibility.
what is the diffrence between before parameter form triger & formate trigger