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 are Indexes Update ?
How to empty your oracle recycle bin?
What is Java Pool in Oracle?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
what are the diffeenes between oracle 9i,oracle 10g
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to connect the oracle server as sysdba?
Explain oracle 12c new features for developers?
How to login to the server without an instance?
what is cartesian product?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How to use group functions in the select clause using oracle?