what is the difference between hard parse and soft parse in oracle?
soft parse. Oracle SQL is parsed before execution, and checked for syntax (and parts of the semantic check) before the SQL is loaded into the library cache. ... (the "hard" parse step) Syntax parse - Oracle parses the syntax to check for misspelled SQL keywords.