SQL Engine - Soft parse (Library cache hit)

Oracle Database Sql Processing


Oracle Database Sql Processing

A soft parse is any SQL parse that is not a hard parse.

If the submitted statement is the same as a reusable SQL statement in the shared pool, then Oracle Database reuses the existing code. This reuse of code is also called a library cache hit.

Soft parses can vary in the amount of work they perform. For example, configuring the session shared SQL area can sometimes reduce the amount of latching in the soft parses, making them “softer.”

In general, a soft parse is preferable to a hard parse because the database skips:

steps, proceeding straight to execution.

Discover More
Oracle Database Sql Processing
SQL Engine - SQL Parser

The parser in an SQL engine parse a Sql statement. It's the first stage of SQL processing. This stage involves separating the pieces of a SQL statement into a SQL Tree where each node is a SQL token...
Oracle Database Sql Processing
SQL Engine - Execution

Execution is the last step of sql processing. The SQL engine executes each row source in the tree produced by: the row source generator (within an hard parse) or a soft parse. This step is the...

Share this page:
Follow us:
Task Runner