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
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.
Your doing fabulous job. God always with you.
Thank you
excellent video with good technical questions
Great teaching👌❤
Great explanation.
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
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.
It will hit direct read and write access from disk that will cause slowness of the query rather than reading from memory
Sir can u give this questions on pdf
Yet to write answers. Once ready i will share them
@@VismoTechnologies ok sir