Recently, I attended a corporate training session on Oracle Performance optimization and tuning in which the trainer said that it is better to do DML operations through a PL/SQL Procedure rather than a direct query because number of hard parsings can be saved as the stored procedure will be cached in the SGA Library improving the performance.
My question here is which one is better to avoid: "The context switching between PL/SQL and SQL Engine" OR "the hard parsing of SQL queries?" I did not get a satisfactory answer from him.