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 the different types of replication and why are they used? : sql server DBA

571


what is grd?

642


What is the difference between dropping a database and taking a database offline? : sql server DBA

582


How do you trace the traffic hitting a sql server? : sql server DBA

848


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1510






I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3811


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2039


Query processing is slow(eg select query)how will u solve that

6529


What is transparent data encryption? : sql server DBA

568


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1529


when does an alert gets signaled?

586


What the different topologies in which replication can be configured? : sql server DBA

666


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1969


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1552


what is the use of recording information about current session?

574