Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sweta
Hi,
in shared pool 2 memory layers are there,
they are,
library cache(to get the recentrly executed sql and pl/sql
statements) and data dictionary cache(to store the sql and
plsql statements and execution path of sql/plsql statemens
i.e explain paln of it) cursor sharing information etc.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different types of indexes available in sql server? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Where do you find the default index fill factor and how to change it? : sql server DBA
what are the performance views in an oracle rac environment?
What would you do with an "in-doubt" distributed transaction?
how can you create a user-defined lock?
What are the recovery models for a database? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
Can you redefine a table online?
What the different components in replication and what is their use? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what are the benefits of flashback feature?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
