Interested to Buy Any Domain ? << Click Here >> for more details...
What is tkprof and how can we use it?
- 1 Answers
- 7 Views
- I also Faced
- E-Mail Answers
Answer / Birbal Singh
TKPROF is a utility provided by Oracle to explain execution plans of SQL statements. It takes trace files generated during session analysis as input and generates formatted output that includes parse call stack, execution statistics, and optimizer statistics. To use TKPROF, you need to run the command 'tkprof <tracefile> <outputfile>', replacing '<tracefile>' with the name of the trace file and '<outputfile>' with the desired output file name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Where does the clusterware write when there is a network or storage issue?
What is the load balancing advisory?
What is table partitioning?
How can we collect the statistics of different database objects?
What is new feature in oracle asm 12c?
Mention what is the difference between instance recovery and crash recovery?
Mention how oracle flex asm works?
What do you understand from cache fusion?
What are the tools provided in oracle enterprise manager?
What are the various benefits of using rac architecture?
How is clustered index different from non-clustered index?
What are the different types of backups that are available in oracle?
Oracle General 
