Hi All,

When I was going through some stuff online, I have found that soft parse's reduces the scalability of an system and a SQL statement should be more likely parsed once and executed many times. I am kind of confused over here, soft parse will always consume less resources and less time-memory latches which is a good thing and more over many dba's expect the session connecting to database issue sql statements that are already present in shared pool, so can you please explain why many soft parses would reduce the scalability of the system. Thanks in advance for your help.