Thank you arun You are giving me an excellent push to think about the database in smart way.
@5002Fahad
4 жыл бұрын
Nice Explanation of avoiding Hard Parsing!
@Silverdragon517
2 жыл бұрын
Awesome, Great Insight and Advise
@AniketPatil-yr1iw
3 жыл бұрын
Nice bonus questions Sirji ..!!! Thank you so much ...
@dbagenesis
3 жыл бұрын
Most welcome
@talkies7074
4 жыл бұрын
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
@phanikumarstudies1032
4 жыл бұрын
Thanks Arun.
@prasadd1324
4 жыл бұрын
Hi Arun. Could you please explain the difference between dbms stats gather and analyze.
@5002Fahad
4 жыл бұрын
very important topic, i believe. Please, explain stat gather and analyze explain plan in details on BOARD!
@dbagenesis
4 жыл бұрын
Picked up for upcoming episodes !!.. Will answer it soon!
@prasadd1324
4 жыл бұрын
@@dbagenesis Thank you so much...
@girija1kp
4 жыл бұрын
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
@dbagenesis
4 жыл бұрын
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..
@girija1kp
4 жыл бұрын
@@dbagenesis I have been watching and enjoying your videos since long back . Always eagerly waiting for dailydba videos upload .. thanks a lot .
@SACHLIFE
4 жыл бұрын
Great assistance..thanks Arun.
@hassanabdelrahman9782
4 жыл бұрын
Thank you, it was helpful
@dbagenesis
4 жыл бұрын
Glad it helped!
@SACHLIFE
4 жыл бұрын
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?
@charanmg9437
4 жыл бұрын
Sachin Bhatia upgrade to which version will be good as well 😇
@rahulgoel3882
3 жыл бұрын
Hi Arun Sir, Flashback feature possible for a dba on table level?
@nishanthajay
4 жыл бұрын
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?
@dbagenesis
4 жыл бұрын
I won't directly answer your question but request you to read about "How SQL ID is generated"
@sandeepbhatia2298
3 жыл бұрын
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?
@chandudevarapu1578
3 жыл бұрын
Can you please explain cursor sharing instead of bind variables
@matheenahamed2692
4 жыл бұрын
Why we configure fal_client and fal_server in DG ?
@dbagenesis
4 жыл бұрын
Just like that ;)
@asifsoft7861
4 жыл бұрын
To define primary and bcp
@durgavenkatesh2114
4 жыл бұрын
Before that i have ask interviewer that our database is having same comparability with developer version..
@lsrao7661
4 жыл бұрын
Why and when we gather stats what happened at background?
@bipintube2009
2 жыл бұрын
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
Пікірлер: 33