SQL Engine - Soft parse (Library cache hit)

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > RDBMS - Sql Processing (Engine)

Table of Contents

1 - About

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.

Advertising
data/type/relation/engine/soft_parse.txt · Last modified: 2017/10/27 15:54 by gerardnico