-
Soft Parse
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|