What is a shared pool?



What is a shared pool?..

Answer / nishi

Memory area of oracle which consists of Library cache (recently executed sql and pl/sql statements) and Data Dictionary cache(recently used tables and indexes).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How to use in conditions in oracle?

0 Answers  


1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  


How to load a large xml file?

0 Answers  


which clause we are not used in where clause?

3 Answers   Semantic Space,


What is the relation of a user account and a schema in oracle?

0 Answers  






What is BBED in Oracle?

0 Answers   MCN Solutions,


What do you mean by merge in oracle?

0 Answers  


what is the syntax of DROP command?

10 Answers  


Whats the benefit of dbms_stats over analyze?

0 Answers  


How many types of synonyms in Oracle?

0 Answers   MCN Solutions,


What is the function of Redo Log ?

1 Answers  


What is an oracle user role?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)