explain tkprof?
Answer / 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 |
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
What is the built_in routine used to count the no of rows in a group?
what is place holder column
Which is the cheapest and quality Oracle Education provider in Bangladesh?
plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example
What are the types of visual attribute settings?
Can you change the color of the push button in design time?
a text item is there what r the different types of triggers associated with it
What is the difference between keystartup and pre-form ?
What is an User Exits ?
Name the different triggers associated with oracle forms having a master-detail relationship.
Can you attach an lov to a field at run-time? if yes, give the build-in name.