How to Purge SQL statements from the Shared Pool

  • Posted on
  • Posted in SQL
Context: When Oracle database receives a SQL statement for execution, it checks if there is already a execution plan stored in the shared pool area. If it finds one, it will use it. This is called a library cache hit, or a soft parse. If it does not find one, it will create it. This
Read more

Bind vs Literal variables in SQL execution

  • Posted on
  • Posted in SQL
When it comes to best practices, don’t just believe everything you hear. You need to understand what you are implementing and why you implement it in a certain way. In order to make a best practice part of your work ethic ,you need to know two things: The why   – understand the reason/logic behind it
Read more
Privacy Policy | Terms and Conditions | Cookie Policy
Copyright 2019 NDMSoft - All Rights Reserved
We care your business.
BACK TO TOP