First page Back Continue Last page Graphics
Shared Pool Reuse…
“Parse once, execute many”
Increase performance and scalability by eliminating the hard parse step
Increase performance by eliminating soft parse
Notes:
As we learned earlier in this course, the shared pool stores parsed versions of executed queries. This eliminates the need for constant reparsing, which would be a tremendous drag on database performance and seriously limits scalability. As Tom Kyte of Oracle Corp and asktom.oracle.com says, “parse once, execute many”.
By default, when Oracle checks the shared pool for a statement it is looking for an identical statement. Additional control over this is available in Oracle9i and is discussed later in this lesson (see the section on Cursor Sharing).