What is a Shared SQL pool ?
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 |
How to define and use table alias names in oracle?
various types of joins
What is transaction control statement and how many types of transaction control statement in Oracle?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
candidate key is subset of super key but not vice-verse explain
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are the components of Physical database structure of Oracle Database?
How to recover a dropped index?
What is a Segment ?
How to drop an index in oracle?
How to convert character types to numeric types?