Muhammad Nadeem Chaudhry's Blog

What is shared SQL area?

Posted in Uncategorized by Muhammad Nadeem Chaudhry on December 21, 2010

A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution plan for the corresponding statement. Any Oracle process can use a shared SQL area. The use of shared SQL areas reduces memory usage on the database server thereby increasing system throughput.

Shared SQL areas are aged out of the shared pool by way of a least recently used algorithm (similar to database buffers). To improve performance and prevent reparsing you may want to prevent large SQL areas from aging out of the shared pool.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: