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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Where would you look for errors from the database engine?
how can you record information about current session?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Explain about your sql server dba experience? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Why would you use sql agent? : sql server DBA
how can you create a user-defined lock?
how can you find out if a table can be redefined?
what do you understand by fine-grained auditing?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
