Prashant Dixit

Prashant Dixit

26
85 525

Подписаться

I have been working as a Database Architect/Administrator with a passion for database performance for the past 17 years. I enjoy sharing my knowledge, conducting experiments, and researching databases. Stay updated by following me on www.fatdba.com

Blog : www.fatdba.com
Twitter: PrashantTdixit
GitHub Repo: github.com/fatdba
LinkedIn Profile : \tin.linkedin.com/in/prashant-dixit-426445b

What is SQL Performance Analyzer or SPA

5:49

What is SQL Performance Analyzer or SPA

5 месяцев назад

Oracle Real Application Testing RAT Architecture

3:20

Oracle Real Application Testing RAT Architecture

5 месяцев назад

PostgreSQL DBA Essentials - Day 4

1:24:18

PostgreSQL DBA Essentials - Day 4

Год назад

PostgreSQL DBA Essentials - Day 3

1:19:54

PostgreSQL DBA Essentials - Day 3

Год назад

PostgreSQL DBA Essentials - Day 2

1:44:54

PostgreSQL DBA Essentials - Day 2

Год назад

PostgreSQL DBA Essentials - Day 1

1:53:34

PostgreSQL DBA Essentials - Day 1

Год назад

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

10:33

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

2 года назад

Generate correct estimation details in an execution plan using GATHER PLAN STATISTICS hint in Oracle

14:55

Generate correct estimation details in an execution plan using GATHER PLAN STATISTICS hint in Oracle

2 года назад

What is Outline data in Oracle Database - How to use it to stabilize SQL performance

9:52

What is Outline data in Oracle Database - How to use it to stabilize SQL performance

2 года назад

Interpreting execution plans in Oracle Part 1

26:04

Interpreting execution plans in Oracle Part 1

2 года назад

How to use SQL Health Check SQLHC report for a slow SQL in Oracle database

15:37

How to use SQL Health Check SQLHC report for a slow SQL in Oracle database

2 года назад

Where to start from in Oracle AWR report Average Active Sessions

10:38

Where to start from in Oracle AWR report Average Active Sessions

2 года назад

Troubleshoot Oracle Database using Operating System Metrics

20:15

Troubleshoot Oracle Database using Operating System Metrics

2 года назад

How to do real time monitoring of Oracle database using oratop utility

11:05

How to do real time monitoring of Oracle database using oratop utility

2 года назад

16:57

Oracle SQL Plan Hash Value Flip : How to create SQL Profile identify and Fix

2 года назад

Oracle Database Histograms : What are they

22:12

Oracle Database Histograms : What are they

2 года назад

Interpreting Oracle AWR report and understand the allocate ITL entry wait event

44:51

Interpreting Oracle AWR report and understand the allocate ITL entry wait event

2 года назад

SQLcl the SQL Developer Command Line: Some of the cool features

16:10

SQLcl the SQL Developer Command Line: Some of the cool features

2 года назад

Troubleshooting Oracle database using ASH

56:48

Troubleshooting Oracle database using ASH

2 года назад

Why the Oracle optimizer picked incorrect index : One perspective

12:00

Why the Oracle optimizer picked incorrect index : One perspective

2 года назад

Interpreting Oracle 10046 extended SQL Trace

18:00

Interpreting Oracle 10046 extended SQL Trace

2 года назад

Generating AWR reports using Oracle SQL Developer and much more

7:39

Generating AWR reports using Oracle SQL Developer and much more

2 года назад

Understanding cost using Oracle 10053 optimizer trace

17:24

Understanding cost using Oracle 10053 optimizer trace

2 года назад

Oracle Database performance analysis using AWR Reports

1:25:51

Oracle Database performance analysis using AWR Reports

2 года назад

Oracle Database performance tuning using AWR reports

1:26:18

Oracle Database performance tuning using AWR reports

2 года назад

Комментарии

@codetoday101 15 дней назад

cleared somany doubts about user and DBA works

@shbhmgpt48 Месяц назад

Do you have any course for performance tuning?

@navdeepbhatia5030 4 месяца назад

Sir in ash_wait_source query u used , what is "where rownum 0.1" (go to minute 4.55)

@dharampal2641 4 месяца назад

Excellent video.. keep it up..

@thefatdba 4 месяца назад

Thanks a lot

@navdeepbhatia5030 4 месяца назад

thanks SIr very nicely explained , kindly share rea.sql as well

@pankajconnect1384 5 месяцев назад

Wow awesome 👌 thank you so much

@thefatdba 5 месяцев назад

Most welcome 😊

@sunitsharma118 5 месяцев назад

Great Session.. Your are best 💯

@thefatdba 5 месяцев назад

I appreciate that!

@roiceborruso8120 5 месяцев назад

🤦 Promo-SM

@Daniel-fm7qg 5 месяцев назад

Can we please have the url for Sibal Ghosh article?

@thefatdba 5 месяцев назад

Hi Daniel, which article ?

@PKBIJ82 5 месяцев назад

After creating custom profile , still SQL is picking bad execution plan , how can I fix then, please suggest.

@s..a6461 6 месяцев назад

Hi sir how can I contact you....

@tanveermohammed6875 7 месяцев назад

Very well explained, we don't get this kind of explanation in paid courses as well, thanks much, i looking to learn advanced postgresql, can you suggest any links or book please, thanks

@deepjitsaha7532 7 месяцев назад

Hi Prashant, could you please tell me how to release PHV value from sql ID after lock PHV value. It will be really helpfull for me if you can.

@appiahgodfred387 7 месяцев назад

Great content. Where to get the Performance Tuning Tips & Tricks Book(.pdf) ??

@thefatdba 5 месяцев назад

There are many, but I will recommend 'Troubleshooting Oracle Performance' by Cristian Antognini

@LoveIndia3 7 месяцев назад

Thanks

@poshanpandey7068 8 месяцев назад

Really Nice explained in all PG videos. please upload such interesting videos on PG DB, replications and clusters as well.

@sharathtin 8 месяцев назад

Hi Prashanth, this is Sharath am working with oracle core dba and can you please suggest which other db will learn and it will more help to me

@gourangapaul9623 9 месяцев назад

Great session

@RitulRastogi 10 месяцев назад

thanku sir for this amazing videos ...keep posting sir it helps alot :)

@RitulRastogi 10 месяцев назад

amazing learning sir ... thanks alot :)

@antustephen 10 месяцев назад

does this work for AWS RDS as well ?

@thefatdba 5 месяцев назад

Of course!

@VenkyPotla369 10 месяцев назад

@Prashanth could you please share the rea.sql script

@thefatdba 5 месяцев назад

Though all of them are available on my GitHub public repo, which in particular you are looking for and I will dhare the direct link

@ramkumarsharma5490 5 месяцев назад

rea.sql Kindly share

@palamol 10 месяцев назад

came here to know how to run it, but it is total timepass video...dislike

@thefatdba 5 месяцев назад

Hi Palamol, I am sorry this is mainly to review and interpret SQLHC reports. I will soon post something on how to generate the report

@shbhmgpt48 11 месяцев назад

Greatt work!!

@chakshujain7246 11 месяцев назад

Best ever seen video on AWR sir. Thank you very much for this informative session. I will go through other videos as well. Learned lot of things in this session. Seems you are not much happy with DBAs :) , Just kidding please don't mind.

@fancystacy 11 месяцев назад

There are nmon and htop with human understandable interfaces. )

@thefatdba 5 месяцев назад

Correct, this is for scenarios where you dont have permissions to download any external packages like htop, sarmon or nmon and have to deal with it using inbuild tools

@himanshukaushik25 Год назад

Hi Prashant Ji Well explained about the indexes, MVCC architecture, Vacuuming etc. kindly upload more videos on Postgres Database.

@himanshukaushik25 Год назад

Appreciate for this it will really helpful who are new or coming from Oracle db.

@himanshukaushik25 Год назад

Nicely Explained Prashant Ji Really Appreciate. kindly upload more videos on Postgres Database

@ganeshbb1 Год назад

Sirji please make some videos on RAT and SPA

@thefatdba 5 месяцев назад

Hi Buddy, recently have posted some videos on RAT please check

@himanshukaushik25 Год назад

Hi Prashant you have nicely explained the architecture in a easy way. Appreciate for this it will really helpful who are new or coming from Oracle db.

@potlasivaji8161 Год назад

How can I join PT training may I have your contact number or mail id

@Nitheesan Год назад

Here Stats Gathering the Good index aslo fix the issue or only the index rebuild will fix ?

@saibabakolla-xi2ms Год назад

I love it amazing video Boss

@haseeburrahmansyed7641 Год назад

i would like to join the PT classes, please let me know how we can connect

@nnreddy22 Год назад

If you start a PT class please let us know. Any link or mail to reach you

@harishharish.r3338 Год назад

Hi Prashanth, very well explained , could you please share the query rea.sql

@surebalu Год назад

@Prashanth Dixit: I see you are teaching people via zoom/GoToMeeting. Can you please share the details of those sessions? I really want to learn the DB tuning. I have Tuning & Diagnostic pack license.

@sunitapolaki3403 Год назад

Very Informative session Thanks for sharing !

@thefatdba Год назад

My pleasure

@sherifelia3389 Год назад

Could anyone share ASH_wait_source.txt script ?

@arghoghosh1421 Год назад

Very Rational Approach to the problem

@sameerahmad7592 Год назад

XXXXcellent Mr.Prashant... 🙂

@mdhasibullah318 Год назад

Prashant it's very nice , please upload more .

@manishjindal6044 Год назад

Pls give contact etc to join this PT training.

@Mrpro119 Год назад

Hello Prashant , Really very good video and you explaining very well . if possible could you please share code snippet which you are using .

@kusumsharma1268 Год назад

👍🤘❤️😍

@Farhan640 Год назад

Great video

@thefatdba Год назад

Thanks for the visit

@Zaid_Alam Год назад

Very informative...

@shyamsunder9422 Год назад

Can we used this in ORACLE SE?

@vigneshn1121 Год назад

Good Day Prashant, Thank you so much for this explanation. I need to know that, How we should track session details(start and end time, elapsed time, still how much rows pending to complete the session). Kindly suggest.