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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What happens on checkpoint? : sql server DBA
what are the differences of where and if in SAS?
What is the importance of a recovery model? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Query processing is slow(eg select query)how will u solve that
what do you understand by flashback feature of oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can you redefine a table online?
What purpose does the model database server? : sql server DBA
Why would you use sql agent? : sql server DBA
Where would you look for errors from the database engine?
