#DBAchallenge

#DBAchallenge -3 || Interview Questions on RMAN, SGA, PGA, Patching, Password fIle and Query Running Slow
Please refer the answers here:
mallik034.blogspot.com/2022/0...
#DBAchallenge -3
Please refer the blog for Answers:
#DBAchallenge, Do submit your questions using below Link
forms.gle/EsU8wgxhrSN4CCaF6
More information refer our blog:
mallik034.blogspot.com/
#ASM #RMAN #RAC #Patch #SGA #PGA #interview #question #answers #DBAchallenge #oracle #database
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]

[@esaval4419]

excellent video with good technical questions

[@meghakaradi]

Great teaching👌❤

[@WorkRakuten-mc6jp]

Great explanation.

[@BHARARHROYAL]

Your doing fabulous job. God always with you.

[@Mallik034]

Thank you

[@subbu4673]

Hi mallik
My Sga size is 10gb and iam executing one query, output of the query is 50g, swap memory is 20g,then it will execute or not please explain this

[@WorkRakuten-mc6jp]

Seems it's would be work cause buffer memory is reusable. Make sure you have enough undo retention and undo tablespace for changing this query block need to reconstruct for read consistency for other sessions.

[@somnathmukherjii2446]

It will hit direct read and write access from disk that will cause slowness of the query rather than reading from memory

[@satyasaichodisetty9755]

Sir can u give this questions on pdf

[@Mallik034]

Yet to write answers. Once ready i will share them

[@satyasaichodisetty9755]

@@Mallik034 ok sir