Webinar-06 - Performance Tuning || Profiling in Oracle || Oracle Database Performance Tuning

Подписаться 21 тыс.

Просмотров 59 тыс.

50% 1

Performance Tuning - Webinar - 06
Performance Tuning
How to start?
Where to start?
What to look?
Agenda:
What are the queries that are running?
Get the rows fetched
Get the sql_hash_value
Get the sql_Text
Get the explain_plan
Run AWR report and review
Solution
Gather stats
Profiling
Post DB upgrade issues
Join Zoom Meeting - Sat 27-02-2021 @ 7:30 PM
#PerformaceTuning #SQLID #PlanHashValue #PT #SBP #19c # Database #Exadata #RAC #ASM #Oracle
Please do follow me and support me on,
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

Наука

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

26 фев 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 78

@ramyasubramanian6207 2 года назад

U r really doing awesome job sir

@madhankumarkancharla28 3 года назад

To add a point at 38:38 index unique scan is better option than Range scan I.e Select * from emp where emp_id=1;---unique scan will be good compared to Range scan Select * from emp where emp_id between 20 and 50;--+ Range scan will be Good Select * from emp where emp_id>20; Full scan will be good

@munnashiva1509 3 года назад

Very informative video sir. Thank you so much for making the videos available for all. So kind of you. 👏👍🙏

@Mallik034 3 года назад

You are welcome

@intakhabalam8252 3 года назад

Thanks for this session 👍. Very informative...

@eswaraiahv2082 3 года назад

Great thanks Sir.. you rocked it :)

@eriqueemk7885 3 года назад

Many thanks Sir.....you're a star

@ramanak470 2 года назад

Its very helpful to me Thanks for the session 👍👍👍

@madhankumarkancharla28 3 года назад

Really need to appriciate u r effort just yesterday I asked about performance tuning series/playlist today u uploaded it looking forward for more content keep doing

@NewYork0110J 2 года назад

If table is recently last analyzed, do we still need to re-build indexes.

@sohailahmedsyed9351 3 года назад

Thanks a lot. Very informative session in a very short time. explained very clearly. Thank You so much. On a personal note sir. If you take a webinars on 19c it will be very helpful for every one. because companies are constantly moving from 12c-19c and there are no proper individuals to take up.

@nishatchotu Год назад

सोहेल भाई fresher ko core dba me job milti hai kya ye course karna chahiye

@dn9416 2 года назад

Very nice webinar

@meghakaradi 3 года назад

Haapy to see your videos🙂

@Mallik034 3 года назад

Thanks

@kumar-bi1to 2 года назад

Thank you very much

@hassanabdi7491 3 года назад

Verey useful topic many thanks Sir.

@Mallik034 3 года назад

Thanks for liking

@anandparmar6106 3 года назад

Very informative session 👏

@Mallik034 3 года назад

Glad you liked it

@lavanyashri7401 Год назад

We have oracle 12c based billing app which underwent a app upgrade . Performance of a export job from db is very poor and vendor asked to increase PFA from 5 to 10 gb with shared memory already used 50 out of 65 gb .. What shall we do

@lilhanvi2035 3 года назад

How to Gather stats for multiple tables Please suggest.

@balumca1 2 года назад

Good session .

@sirishad4507 Год назад

whats the query to compare the explain plain from its previous execution

@sadiqueali863 3 года назад

Great explanation Sir

@Mallik034 3 года назад

Keep watching

@bitantalapatra4230 2 года назад

Where from I get the entire webinar series on Oracle DBA

@madhusudanaraonallamothu2792 3 года назад

Thank you .

@Mallik034 3 года назад

Welcome 😊

@singhyou Год назад

Mallik, Can you please tell what is Blind variable in Oracle. I heard this for the very first time.

@nilendu11 Год назад

Hello, It us a good video. It will highly appreciated of you can share the code for the Get the Explain Plan SQL script

@satyachollangi 3 года назад

Hi @mallik please provide MOS doc for SQL profiling

@rushindrayenni6321 2 года назад

It very useful information for database administrator Sir... I am feeling bad to get this video too late to my notice.... Anyhow I am very thankful to you....

@Mallik034 2 года назад

Thank you

@sirishad4507 Год назад

How can we revert back once the profiling is done..as u told its a temporary plan

@BewithuNnk Год назад

Hi, can you give me one favour, is this whole activities doing DBA team or developers??

@kids-kh1ij 3 года назад

Thanks for the informative video. Please can you share the queries?

@Eira.2010 3 года назад

Can you pls upload a video on thread and triggers

@BHARARHROYAL 3 года назад

Good session sir

@Mallik034 3 года назад

Thanks

@amar0812 3 года назад

Hi Mallik, request you to please let me know ...from where i can get the awr_sql_history_orig.sql file ?

@Mallik034 3 года назад

Its been already shared on our telegram group. U can join DBA telegram group @mallik034

@rajatsharma-ws6vs 2 года назад

Very deep knowledge 👍 Thanks malik. Is there any course for sql learning please ? From medium to advance ??

@Eira.2010 3 года назад

Nice session

@Mallik034 3 года назад

Thank you 👍

@janardhanchandra5091 2 года назад

Can we get those queries please. I am not there in Telegram DBA group.

@rahulsarkate1234 2 года назад

Can u share the doc file for study

@Nareshreddy-ot3fc 3 года назад

nice session Malli

@Mallik034 3 года назад

Thanks

@mahenderdbaaccount5081 3 года назад

please share the above text document or paste that content here so that we can follow thanks for good explanation further we look for you some other good topics

@Mallik034 3 года назад

Its already shared on our telegram group. U can get it on our DBA telegram group @mallik034