Shared SQL Area
A shared SQL area contains the parse tree and execution plan for every given SQL statement being run in the instance. Oracle conserves memory by using just one shared SQL area for SQL statements run multiple times. This often happens when many users run the same application or when one user runs the same SQL statement repeatedly (including the same bind variables), using slightly different values for some of the where clauses.
Oracle allocates additional memory from the shared pool to the shared SQL area whenever a new SQL statement is parsed and stores that SQL statement in the shared SQL area. The size of the memory that gets allocated depends on the size and the complexity of the statement in question. If the entire shared ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
