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
How to test null values?
How much memory your 10g xe server is using?
What is rowid and rownum in oracle?
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 ?
How to create a new view in oracle?
What is a relational database management system?
11. Display the client number and name and the client number and name of the person who referred that client.
What are the most common interview questions on ETL Testing for experience?
does the query needs a hint to access a materialized view?
How to create an initialization parameter file?
What is Java Pool in Oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to create an oracle testing table?
How many types of segments in Oracle?
Why does for update in oracle 8 cause an ora-01002 error?