What is a Shared SQL pool?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

421. What is a Shared SQL pool?

The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users.

(Continued on next question...)

Other Job Interview Questions

• What are the Large object types suported by Oracle?
• Do View contain Data?
• Define Transaction?
• What is a “trigger”?
• What is a “trigger”?
• How do you resize a data file?
• What are the different Parameter types?
• What is a VIEW? How to get script for a view?
• Give the stages of instance startup to a usable state where normal users may access it.
• What is a DBA?
• More...