Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning

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,...

Full description

Bibliographic Details
Main Authors: Hitesh Kumar SHARMA, S.C. NELSON
Format: Article
Language:English
Published: Bucharest University of Economic Studies 2017-07-01
Series:Database Systems Journal
Subjects:
SQL tuning
Oracle database
Explain Plan
SQL Trace
Online Access:http://www.dbjournal.ro/archive/27/27_4.pdf

Similar Items

Similar Items