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 |
| _version_ | 1797720514025750528 |
|---|---|
| author | Hitesh Kumar SHARMA S.C. NELSON |
| author_facet | Hitesh Kumar SHARMA S.C. NELSON |
| author_sort | Hitesh Kumar SHARMA |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-03-12T09:20:39Z |
| format | Article |
| id | doaj.art-d319f867641941c490118f8af3710451 |
| institution | Directory Open Access Journal |
| issn | 2069-3230 2069-3230 |
| language | English |
| last_indexed | 2024-03-12T09:20:39Z |
| publishDate | 2017-07-01 |
| publisher | Bucharest University of Economic Studies |
| record_format | Article |
| series | Database Systems Journal |
| spelling | doaj.art-d319f867641941c490118f8af37104512023-09-02T14:33:19ZengBucharest University of Economic StudiesDatabase Systems Journal2069-32302069-32302017-07-01VIII13139Explain Plan and SQL Trace the Two Approaches for RDBMS TuningHitesh Kumar SHARMA0S.C. NELSON1University of Petroleum & Energy Studies, Dehardun, Uttarakhand, IndiaUniversity of Petroleum & Energy Studies, Dehardun, Uttarakhand, IndiaProbably 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.http://www.dbjournal.ro/archive/27/27_4.pdfSQL tuningOracle databaseExplain PlanSQL Trace |
| spellingShingle | Hitesh Kumar SHARMA S.C. NELSON Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning Database Systems Journal SQL tuning Oracle database Explain Plan SQL Trace |
| title | Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning |
| title_full | Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning |
| title_fullStr | Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning |
| title_full_unstemmed | Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning |
| title_short | Explain Plan and SQL Trace the Two Approaches for RDBMS Tuning |
| title_sort | explain plan and sql trace the two approaches for rdbms tuning |
| topic | SQL tuning Oracle database Explain Plan SQL Trace |
| url | http://www.dbjournal.ro/archive/27/27_4.pdf |
| work_keys_str_mv | AT hiteshkumarsharma explainplanandsqltracethetwoapproachesforrdbmstuning AT scnelson explainplanandsqltracethetwoapproachesforrdbmstuning |