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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
internal architecture
how can you communicate with operating system files from oracle?
what is a user-defined lock?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how can a session indicate its interest in receiving alerts?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you initialize log miner?
What would you do with an "in-doubt" distributed transaction?
Explain materialized views and how they are used.
when does an alert gets signaled?
what do you understand by fine-grained auditing?
