How can we use tkprof?
Answer / Prakash Kumar
To use tkprof, you need to run a SQL statement with the 'explain' or 'explain plan' option and redirect its output to a trace file. Then, you can use tkprof utility to generate an explanatory report for the trace file. This report includes information about SQL statements executed, their execution plans, and performance statistics.
| Is This Answer Correct ? | 0 Yes | 0 No |
What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?
What is the function of cache fusion in oracle rac?
What are the key characteristics of rac or why to use rac?
Mention what is the difference between instance recovery and crash recovery?
What is oracle real application clusters?
What is the difference between instance recovery and crash recovery?
Explain the hardware architecture used in oracle rac?
What are the file systems and volume management techniques used in oracle rac?
Explain the oracle real application clusters architecture?
Mention how can you determine what protocol is being used for interconnect traffic?
What is the load balancing advisory?
What is the function of having virtual internet protocol address (vip) in oracle rac?