Тёмный

Query Tuning with tkprof 

Stephen Frein
Подписаться 729
Просмотров 60 тыс.
50% 1

Demonstration of generating Oracle trace files and then turning these into tuning reports with the tkprof utility.

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@randhirdhillon
@randhirdhillon 10 лет назад
Such a nice explained tutorial thanks for your free and priceless work
@kdhairyavan
@kdhairyavan 6 лет назад
This is really good and very informative in a short time, can you post a link for the document that can be used for reference so that I can refer when I have a situation to look for it. Thank you
@nikhilgothankar7398
@nikhilgothankar7398 11 лет назад
A very nice tutorial to understand tkprof utility. Do you have similar stuff on Explain Plan? I am also looking for some video showing how optimize query performance even for a very simple queries using explain plan or any other tool.
@AstorSkywalker
@AstorSkywalker 11 лет назад
Thanks Stephen, just two questions, what user should log in or could this be done with any particular user? and the other question is should we turn off the two session parameters when finished or by disconnected oracle automatically does it for us? Thanks alot.
@arthurbabayev2196
@arthurbabayev2196 12 лет назад
Great video, thanks! More on reading the output would be nice. Thank you.
@chaitanya1987
@chaitanya1987 13 лет назад
Thank you very much for your quick response.
@Syed0945
@Syed0945 12 лет назад
Very Nice video on TKPROF. Could you please put some video on AWR and STATSPACK.
@sreekumarvg2786
@sreekumarvg2786 10 лет назад
Well explained and very nice!
@hohohann
@hohohann 12 лет назад
I like your video... especially the report_yay.txt.
@eng3mmm
@eng3mmm 9 лет назад
Well done, thank you so much !!
@chaitanya1987
@chaitanya1987 13 лет назад
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.
@binaryconsole
@binaryconsole 7 лет назад
Dont find files on his system, try on your own system.
@chuck77k
@chuck77k 9 лет назад
Excellent, but... man use right mouse button to paste text into terminals :)
@thedinezh87
@thedinezh87 9 лет назад
nice video
@erobiniet
@erobiniet 7 лет назад
Good one
@l.ashokreddy5182
@l.ashokreddy5182 8 лет назад
good
@jmbharathram
@jmbharathram 7 лет назад
Hi Ashok - How are you learning to tune SQLs? Have you tried any courses or read any books ?
@JustmeAgainOk
@JustmeAgainOk 10 лет назад
mmff
@binaryconsole
@binaryconsole 7 лет назад
Sorry... you are breaking with the info and flow of teaching... its to lose further knowledge if we watch this.
@jmbharathram
@jmbharathram 7 лет назад
Hi Ravi - Just curious what prompted you to look for SQL/Performance Tuning videos on RU-vid.
Далее
tkprof for trace analysis
12:56
Просмотров 14 тыс.
Interpreting Oracle 10046 extended SQL Trace
18:00
Просмотров 2 тыс.
XML Report Bursting
35:08
Просмотров 20 тыс.
Interpreting Oracle Explain Plan Output - John Mullins
1:00:16
1. Oracle SGA Architecture Overview (Part 1)
10:14
Просмотров 163 тыс.