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
did u p prepared complex 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
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
List the different types of columns in oracle reports.
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
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What do you understand by lov?
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
difference between global n context sensitive segments?
How can we generate report output in excel format?
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
What is responsibility and how u attach How to create user and how u attach with responsibility.
Is it possible to have multiple layouts in a report?
what is oracle forms?