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 purpose does the model database server? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
when does an alert gets signaled?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What authentication modes does sql server support? : sql server DBA
Query processing is slow(eg select query)how will u solve that
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What are the different ways you can create databases in sql server? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How would you go about verifying the network name that the local_listener is currently using?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different types of indexes available in sql server? : sql server DBA