hardparse

Posted by satish on Jul 02, 2018; 12:39pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/hardparse-tp6339.html

Dear Erman,


1)Hard parsing is very CPU intensive, and involves obtaining latches on key shared memory areas
2)using bind variables will reduce the latch activity in the SGA

How does hard parsing use latching?

Thank you