Oracle SQL query parsing explained – the query processing workflow from SQL statement to execution plan, the difference between hard parse and soft parse, cursor caching in the library cache, and how query transformation converts SQL into the optimiser’s internal representation. Part 1 of a two-part series.…