Query Tuning with tkprof
Loading...
Loading...
1,200
Loading...
Uploader Comments (stephenfrein)
see all
All Comments (5)
-
Very Nice video on TKPROF. Could you please put some video on AWR and STATSPACK.
-
Great video, thanks! More on reading the output would be nice.
Thank you.
-
Thank you very much for your quick response.
Loading...
2:33
Oracle Hints,by 018sube1,215 views- 14:58
Using Oracle SQL Loaderby stephenfrein2,470 views
- 1:39
Getting AWR Report from SQLPlusby mattdee1,433 views
- 10:40
Using Autotrace in SQL*Plusby stephenfrein318 views
- 7:21
Identifying and Tuning Queries that Cause Oracle Wait Eventsby DBPowerStudio380 views
- 9:38
Diagnostic Tools and Oracle Listener Part 3 of 7by mpastorgmu522 views
- 6:10
Oracle SQL Tuning Setby OracleES688 views
- 8:53
Oracle-performance-tuning-1.aviby asktheoracle15,076 views
- 5 videosOracle SQL Tuning
- 7:39
Oracle SQL Performance Tuningby dwealth21,369 views
- 54:06
Kevin Kline's Magic Formula for SQL Query Tuningby questsoftware17,501 views
- 6:53
Genesis Consulting: Agile vs Waterfallby GenesisConsulting14,737 views
- 1:15:20
Automating SQL Optimizationby questsoftware14,772 views
- 3:00
Oracle Performance Tipsby relianttechnology5,589 views
- 1:00:15
How to Manage, Understand and Maintain Oracle RACby questsoftware21,128 views
- 13:14
Effect of Oracle Block Space Utilization on Performanceby stephenfrein126 views
- 9:10
Rewriting SQL queries for Performance in 9 minutesby roughsealtd17,559 views
- 5:42
Tenu Ghol Ke Shrab Ch Pe Javanby ksmatharoo19834,584 views
- 39:14
Efficient performance analysis and tuning with MySQL Enterprise Monitorby tcation478 views
- 21:15
The Basics of Execution Plans and SHOWPLAN in SQL Serverby LearnItFirst5,964 views
- 2:53
Using Left Outer Joinsby o2solutionsdotnet3,730 views
Hello sir. thanks for your tutorial.I am unable to find the trace file in the directory shown in the video. could you please help me. Thanks.
chaitanya1987 4 months ago
@chaitanya1987 Run this query: "SELECT value FROM v_$parameter WHERE name = 'user_dump_dest';" This should tell you where your trace files will be created.
stephenfrein 4 months ago