Oracle System Architecture Question:

Download Job Interview Questions and Answers PDF

Explain what is Shared SQL Area?

System Architecture Interview Question
System Architecture Interview Question

Answer:

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

Download System Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what do Redo Log Buffers contain?Tell me why oracle is called kernel package, components of oracle table, sql system variables, local and global variables?