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
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?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the default port no on which sql server listens? : sql server DBA
how can you schedule a job in database?
what functionality does oracle provide to secure sensitive information?
what is a user-defined lock?
What is a correlated sub-query? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What is dcl? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
how can you record information about current session?
What is dbcc? : sql server DBA
how can you communicate with operating system files from oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
