Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning

Hitesh Kumar Sharma () and S.C. Nelson ()
Additional contact information
Hitesh Kumar Sharma: University of Petroleum & Energy Studies, Dehardun, Uttarakhand, India
S.C. Nelson: University of Petroleum & Energy Studies, Dehardun, Uttarakhand, India

Database Systems Journal, 2017, vol. 8, issue 1, 31-39

Abstract: 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.

Keywords: SQL tuning; Oracle database; Explain Plan; SQL Trace (search for similar items in EconPapers)
Date: 2017
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.dbjournal.ro/archive/27/27_4.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:8:y:2017:i:1:p:31-39

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().