Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning
Probably the best way to determine whether your SQL statements are properly optimized is by using the Oracle SQL Trace facility and the EXPLAIN PLAN command. You can use the SQL Trace facility and the Oracle program TKPROF, which is used to translate trace files, to trace production SQL statements,...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Bucharest University of Economic Studies
2017-07-01
|
| Series: | Database Systems Journal |
| Subjects: | |
| Online Access: | http://www.dbjournal.ro/archive/27/27_4.pdf |
| Summary: | Probably the best way to determine whether your SQL statements are properly optimized is by using the Oracle SQL Trace facility and the EXPLAIN PLAN command. You can use the SQL Trace facility and the Oracle program TKPROF, which is used to translate trace files, to trace production SQL statements, and gather statistics about those statements. You use SQL Trace to gather information into a trace file; the Oracle program TKPROF formats the trace information into useful, understandable data. |
|---|---|
| ISSN: | 2069-3230 2069-3230 |