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 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 do u place it in required folder
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
Can we invoke one form from another in a multi-forms application?
what are bind variables?
What is responsibility and how u attach How to create user and how u attach with responsibility.
What is an oracle report?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
all steps of bitmap report?
List out the oracle forms configuration files?
a text item is there what r the different types of triggers associated with it
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
How can we expand Parameter Form Canvas on Reports 6i?
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