How many memory layers are in the shared pool?

Answer Posted / narmada kumari

1/3 of physical memory, can be 2/4k depending on bit of 32 or 64

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What authentication modes does sql server support? : sql server DBA

705


What would you do with an "in-doubt" distributed transaction?

1423


what are the performance views in an oracle rac environment?

575


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1882


How would you go about verifying the network name that the local_listener is currently using?

2768






What are the operating modes in which database mirroring runs? : sql server DBA

621


What are the different types of upgrades that can be performed in sql server? : sql server DBA

695


what is grd?

646


how can you connect from 10g user to 11g user??

1689


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?

2010


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1981


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1549


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2981


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

591


What is the importance of a recovery model? : sql server DBA

566