Answer Posted / 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 |
Post New Answer View All Answers
Explain how one can iterate through items and records in a specified block?
What is a user exit program in oracle reports?
What do you understand by oracle forms?
What do you understand by lov?
Why oracle forms required?
if u want to delete all these detail block etc what will happen in form
In what situation u create the BPA.
difference between global n context sensitive segments?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
how do u place it in required folder
What do you understand by lov and how can it be used?
what are bind variables?
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff