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
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 tripstop report?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
Is it possible to have multiple layouts in a report?
how do u place it in required folder
What is the difference between flex mode and confined mode?
What do you understand by oracle forms?
What is an SQL FORMS ?
from where do u receive the information to develop report
What is a matrix report and how many minimum groups are required to prepare the same?
What are the various configuration files that are used by oracle forms?
What do we mean by record group in oracle forms?
List the different types of columns in oracle reports.
difference between global n context sensitive segments?
