Тёмный

Getting historical performance stats using Active Session History ASH dynamic views in Oracle 

Prashant Dixit
Подписаться 2,4 тыс.
Просмотров 1,5 тыс.
50% 1

Active Session History (ASH) is part of the Diagnostics and Tuning Pack. It samples information from the [G]V$ views allowing you to see current and historical information about active sessions on the database. They are loaded with lot of crucial data which you can utilize at the time of any issue or when you are doing advance troubleshooting.
Keep Watching & Learning!
My Blog : www.fatdba.com
GitHub: github.com/fatdba/Oracle-Data...

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

 

7 май 2022

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@kusumsharma1268
@kusumsharma1268 Год назад
👍🤘❤️😍
@madhusudanaraonallamothu2792
@madhusudanaraonallamothu2792 2 года назад
Very insightful. Thank you.
@nnreddy22
@nnreddy22 Год назад
If you start a PT class please let us know. Any link or mail to reach you
@navdeepbhatia5030
@navdeepbhatia5030 4 месяца назад
Sir in ash_wait_source query u used , what is "where rownum 0.1" (go to minute 4.55)
@appiahgodfred387
@appiahgodfred387 7 месяцев назад
Great content. Where to get the Performance Tuning Tips & Tricks Book(.pdf) ??
@thefatdba
@thefatdba 5 месяцев назад
There are many, but I will recommend 'Troubleshooting Oracle Performance' by Cristian Antognini
@mukeshsinghrawat7211
@mukeshsinghrawat7211 2 года назад
Hi Prashant, i want to learn how to fix problems in sql text. As a dba we can see explain plan but how to fix those issues ourselves without referring to developer. Can you suggest any book which targets this area only?
@sherifelia3389
@sherifelia3389 Год назад
Could anyone share ASH_wait_source.txt script ?
@pushpakpattewar7098
@pushpakpattewar7098 2 года назад
are you taking online class on PT ?
@thefatdba
@thefatdba 2 года назад
Yes, I am thinking of starting the batch soon
@gmuthu100
@gmuthu100 2 года назад
Please let me know if you start class. I want to join your classes sir.
@nnreddy22
@nnreddy22 Год назад
If you start a PT class please let us know. Any link or mail to reach you
@navdeepbhatia5030
@navdeepbhatia5030 4 месяца назад
Sir I am also interested , How can I reach you
Далее
Troubleshooting Oracle database using ASH
56:48
Просмотров 6 тыс.
Interpreting execution plans in Oracle Part 1
26:04
Просмотров 4 тыс.
МАРИЯ ГОЛУБКИНА О БАБУШКЕ #shorts
00:43
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
Просмотров 6 млн
ASH Hacking Session - Part 1: ashtop and asqlmon
1:11:30
ASH Mash! A tour of the amazing Active Session History
1:04:40
This Is Why Python Data Classes Are Awesome
22:19
Просмотров 796 тыс.
Which Database Model to Choose?
24:38
Просмотров 47 тыс.
МАРИЯ ГОЛУБКИНА О БАБУШКЕ #shorts
00:43