What is Shared SQL Area ?

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.
  • Interview Candidate
  • 1
  • 8541

Showing Answers 1 - 1 of 1 Answers

partho sarathi konar

  • Oct 1st, 2006
 

Hi

Shared SQL  areas are shared memory areas; 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.

thanks

partho

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions