Webinar-06 - Performance Tuning || Profiling in Oracle || Oracle Database Performance Tuning
Vložit
- čas přidán 26. 02. 2021
- 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
CZcams: / 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
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg - Věda a technologie
U r really doing awesome job sir
Many thanks Sir.....you're a star
Great thanks Sir.. you rocked it :)
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
Very informative video sir. Thank you so much for making the videos available for all. So kind of you. 👏👍🙏
You are welcome
Thanks for this session 👍. Very informative...
Its very helpful to me Thanks for the session 👍👍👍
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
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.
सोहेल भाई fresher ko core dba me job milti hai kya ye course karna chahiye
Verey useful topic many thanks Sir.
Thanks for liking
Haapy to see your videos🙂
Thanks
Thank you very much
Very informative session 👏
Glad you liked it
Very nice webinar
Great explanation Sir
Keep watching
Good session .
Thank you .
Welcome 😊
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....
Thank you
nice session Malli
Thanks
Good session sir
Thanks
Nice session
Thank you 👍
Thanks for the informative video. Please can you share the queries?
Very deep knowledge 👍
Thanks malik.
Is there any course for sql learning please ? From medium to advance ??
Malik sir it is bind variable not blind variable, anyways good informative session 👍
Hello, It us a good video. It will highly appreciated of you can share the code for the Get the Explain Plan SQL script
If table is recently last analyzed, do we still need to re-build indexes.
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
Its already shared on our telegram group.
U can get it on our DBA telegram group @mallik034
@@Mallik034 can you share me the documents
Can you pls upload a video on thread and triggers
Hi @mallik please provide MOS doc for SQL profiling
whats the query to compare the explain plain from its previous execution
Mallik,
Can you please tell what is Blind variable in Oracle. I heard this for the very first time.
Thanks for providing, can you please share the document..
I am sharing all these documents on our DBA telegram group.
Join our DBA group @mallik034 on telegram
How to Gather stats for multiple tables
Please suggest.
Where from I get the entire webinar series on Oracle DBA
Thank you.. Can we get those queries for practice please..
I have already shared in our Telegram DBA group
You are welcome
@@Mallik034 Is it possible for me to be added to the Telegram DBA group?
You can reach @mallik034 on Telegram you will see our DBA group and you can join
@@Mallik034 Thank you Sir, and thanks for sharing your efforts and knowledge!
It’s very useful, could you please share this document
Its available on my blog amd telegram group
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
Hi Mallik,
request you to please let me know ...from where i can get the awr_sql_history_orig.sql file ?
Its been already shared on our telegram group.
U can join DBA telegram group @mallik034
How can we revert back once the profiling is done..as u told its a temporary plan
Hi, can you give me one favour, is this whole activities doing DBA team or developers??
can you pls share the awr_sql_history.sql script which was used in this
Its already shared on our Telegram group
Can we get those queries please. I am not there in Telegram DBA group.
Can you pls share the queries
Can u share the doc file for study
Can you share the queries used
Please
HI FRIEND CAN YOU PLEASE SHARE THIS PERFORENCE DOC'S WITH US.
Hi Mallik... when is the next batch starts ... please let me know. Thank you. Could you please share your contact details.
hi sir where from i get the telegram channel link
You can install telegram APP abd search for @mallik034 and join group
can u provide the pdf
Kindly share Telegram Link
Search @mallik034 on Telegram
Terrifying english
Where can I get the entire webinar series on Oracle DBA