Webinar-06 - Performance Tuning || Profiling in Oracle || Oracle Database Performance Tuning
Вставка
- Опубліковано 26 лют 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
UA-cam: / 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
UA-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg - Наука та технологія
![Database Performance Issue - Basic Guidelines and OS Analysis [top, vmstat, free, iostat,sar] - PT 1](/img/n.gif)
U r really doing awesome job sir
Thanks for this session 👍. Very informative...
Great thanks Sir.. you rocked it :)
Very informative video sir. Thank you so much for making the videos available for all. So kind of you. 👏👍🙏
You are welcome
Many thanks Sir.....you're a star
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
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
Its very helpful to me Thanks for the session 👍👍👍
Very nice webinar
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
Good session .
Great explanation Sir
Keep watching
If table is recently last analyzed, do we still need to re-build indexes.
nice session Malli
Thanks
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
Thank you .
Welcome 😊
Thanks for the informative video. Please can you share the queries?
Hi @mallik please provide MOS doc for SQL profiling
How to Gather stats for multiple tables
Please suggest.
whats the query to compare the explain plain from its previous execution
Hello, It us a good video. It will highly appreciated of you can share the code for the Get the Explain Plan SQL script
Can you pls upload a video on thread and triggers
Where from I get the entire webinar series on Oracle DBA
Very deep knowledge 👍
Thanks malik.
Is there any course for sql learning please ? From medium to advance ??
Good session sir
Thanks
Mallik,
Can you please tell what is Blind variable in Oracle. I heard this for the very first time.
Nice session
Thank you 👍
Malik sir it is bind variable not blind variable, anyways good informative session 👍
How can we revert back once the profiling is done..as u told its a temporary plan
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
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, can you give me one favour, is this whole activities doing DBA team or developers??
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
Can u share the doc file for study
Can we get those queries please. I am not there in Telegram DBA group.
can you pls share the awr_sql_history.sql script which was used in this
Its already shared on our Telegram group
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
Can you pls share the queries
can u provide the pdf
HI FRIEND CAN YOU PLEASE SHARE THIS PERFORENCE DOC'S WITH US.
It’s very useful, could you please share this document
Its available on my blog amd telegram group
Hi Mallik... when is the next batch starts ... please let me know. Thank you. Could you please share your contact details.
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!
hi sir where from i get the telegram channel link
You can install telegram APP abd search for @mallik034 and join group
Can you share the queries used
Please
Kindly share Telegram Link
Search @mallik034 on Telegram
Terrifying english
Where can I get the entire webinar series on Oracle DBA