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 would you go about verifying the network name that the local_listener is currently using?
Why would you call update statistics? : sql server DBA
What is dcl? : sql server DBA
what are the performance views in an oracle rac environment?
What are the operating modes in which database mirroring runs? : sql server DBA
what is the use of ocr?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Why would you use sql agent? : sql server DBA
what functionality does oracle provide to secure sensitive information?
how can you process messages in order asynchronously?
What is replication? : sql server DBA
how to restore files with rman?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
which background process invoke at the time of upgradation tell me???
