What is a Shared SQL pool ?

Answer Posted / sawant

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.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to test null values?

871


How much memory your 10g xe server is using?

842


What is rowid and rownum in oracle?

790


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2068


How to create a new view in oracle?

852


What is a relational database management system?

886


11. Display the client number and name and the client number and name of the person who referred that client.

2115


What are the most common interview questions on ETL Testing for experience?

886


does the query needs a hint to access a materialized view?

1676


How to create an initialization parameter file?

765


What is Java Pool in Oracle?

860


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1904


How to create an oracle testing table?

826


How many types of segments in Oracle?

813


Why does for update in oracle 8 cause an ora-01002 error?

767