Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Shared SQL pool ?
- 2 Answers
- 7267 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rashid ansari
shared pool contain data dictionary and library
cache.oracle make a execution plan into sheared pool
| Is This Answer Correct ? | 1 Yes | 2 No |
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
Explain the difference between sap and oracle?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What are a collation and state the different types of collation sensitivity?
How to get a list of all user accounts in the database?
What is oracle update statement with inner join ?
What is Database Buffers ?
What is transaction control statement and how many types of transaction control statement in Oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
Explain what are synonyms used for?
what are different types of locks?
How to convert characters to dates in oracle?
Oracle General 
