How many memory layers are in the shared pool?

Question Posted / narmada kumari

3 Answers
7848 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many memory layers are in the shared pool?..

Answer / chandra mohan

LIBRARY CACHE,DATA DICTIONARY CACHE

Is This Answer Correct ?

4 Yes

0 No

How many memory layers are in the shared pool?..

Answer / 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

How many memory layers are in the shared pool?..

Answer / 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

More DB Administration Interview Questions

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers Value Labs,

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers TCS,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

how can you communicate with operating system files from oracle?

0 Answers Oracle,

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

0 Answers

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers

How do you open a cluster administrator? : sql server DBA

0 Answers

what is incremental checkpoint?

1 Answers CTS,

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?

0 Answers HSBC,

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

For more DB Administration Interview Questions Click Here