Answer Posted / barick prabhudatta
The TKPROF is one of the most useful utilities available to
DBAs for diagnosing performance issues. The TKPROF utility
means Transient Kernel Profiler.
The TKPROF 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 ? | 4 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
Can we invoke one form from another in a multi-forms application?
What is responsibility and how u attach How to create user and how u attach with responsibility.
What is a user exit program in oracle reports?
what is tripstop report?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
if u want to delete all these detail block etc what will happen in form
i am writing a query select EmpNo from Emp how can i call in after parameter form
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
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
Explain the various types of oracle report?
where do u put the report file
how do u place it in required folder
hiding item in report how like that properly,thats manually but at runtime i want to do
