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 do you trace the traffic hitting a sql server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Where would you look for errors from the database engine?
what is the use of recording information about current session?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you schedule a job in database?
What is transparent data encryption? : sql server DBA
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
how can a session indicate its interest in receiving alerts?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the different sql server versions you have worked on? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
