Which of the following tool is used to analyze performance problems in a Oracle database
-
TKPROF
-
Jensor
-
SQLProfiler
-
Strobe
A
Correct answer
Explanation
Option A is correct because TKPROF is Oracle's native tool for analyzing SQL performance - it formats trace files to show execution plans, statistics, and timing information for SQL statements. Options B (Jensor), C (SQLProfiler), and D (Strobe) are not Oracle performance analysis tools. TKPROF has been part of Oracle Database for decades and is the standard tool for SQL performance investigation.