Avoid Hard Parsing in Oracle |
Vložit
- čas přidán 21. 07. 2024
- In this episode of daily DBA, I pick up 5 important #DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!
00:00 When ever you are into Oracle DBA interview?
0:44 How flashback works for multi-tenant architecture? Like if I have 2 pdbs named HR and Sales inside a single CDB and I am performing any change/release in either of pdb and due to some failure I need to revert changes to original state, before changes. How will it work?
04:37 How to avoid hard parsing?
14:40 After installing 11gR2 for RAC Configuration, why we have compatible.asm=11.2.0.0.0 & compatible.rdbms=10.1.0.0.0?
17:52 What is FAL_CLIENT and FAL_SERVER? What's their purpose?
20:48 Can you please help me understand the use of swap?
Bonus Question
24:46 How to clear multiple rounds of DBA interview?
29:07 # dba Challenge!
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis - Věda a technologie
Thank you arun
You are giving me an excellent push to think about the database in smart way.
Nice Explanation of avoiding Hard Parsing!
Awesome, Great Insight and Advise
Great assistance..thanks Arun.
Great sir..how much ever video I go for learning..finally I end up in Ur video..because I can really understand the way u explain its simple to understand and very clear.thanl u so much..also pls make a video on 12c Architecture
Nice bonus questions Sirji ..!!!
Thank you so much ...
Most welcome
Thanks Arun.
Thank you, it was helpful
Glad it helped!
Sir your explanation style is awesome 👍, please explain step by step how do I create new database in windows server oracle 11.2.0.1.0 which performs very good , any necessary things will do with new database?
Can you please explain cursor sharing instead of bind variables
Hi Arun Sir, Flashback feature possible for a dba on table level?
Hi Arun,
It interests me as you spoke of hard parsing and performance impact,. When bind variables are not in use,
as in the earlier statements and though the sql_id's differ, plan hash value wont change as optimizer wont generate a complete new plan to the second or 3rd statements inturn it shares the same plan to the subsequent statements which we commonly know as ACS. Is there any significance in optimizer's work as it act's smart understanding similarity of statements but still the parsing goes as hard parsing between these 3 statements due to the negligence of bind?
I won't directly answer your question but request you to read about "How SQL ID is generated"
In dataguard scenario case , why for all 3 standby's , we kept log shipping from primary , fal_server as primary . In that case while role switch happens between primary and 1st standby , then 2nd and 3rd standys will become out of sync or invalid . Rather we could use cascading standbys as 2nd and 3rd standbys will be getting logs from 1st standby as fal_server for rest of standbys , in such case after role switch also , all will be in sync .. please correct me if I am wrong
Thats just an example !! There are 1000 scenarios and we cannot talk about each to explain a scenario. What happens on a switchover? what if there is logical standby? what if there is active DG? what if... what if.. and what if..
Focus on what being said in what context! Keep it relevant..
@@dbagenesis I have been watching and enjoying your videos since long back . Always eagerly waiting for dailydba videos upload .. thanks a lot .
For Upgrade, I'd like to know first are, whether it is in same server or or other? same os or on different os? present version and db size? downtime? single instance or rac? flashback enabled?
Sachin Bhatia upgrade to which version will be good as well 😇
Why and when we gather stats what happened at background?
Hi Arun. Could you please explain the difference between dbms stats gather and analyze.
very important topic, i believe. Please, explain stat gather and analyze explain plan in details on BOARD!
Picked up for upcoming episodes !!.. Will answer it soon!
@@dbagenesis Thank you so much...
Hi Arun, Can you explain cost in explain plan, what is men's of cost ,where is going to effect if cost has high number and if cost is low number ,I asking regarding performance
Sure, will take this up in upcoming videos.
Before that i have ask interviewer that our database is having same comparability with developer version..
Why we configure fal_client and fal_server in DG ?
Just like that ;)
To define primary and bcp
Can I have your email please
support@dbagenesis.com