What is a shared pool?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why packages are used in oracle?

547


How to use "if" statements on multiple conditions?

723


What is an oracle and why it is used?

627


How to assign data of the deleted row to variables?

584


WHAT IS ecc 6.0

1666






What privilege is needed for a user to create indexes in oracle?

580


What is instant client oracle?

546


does the query needs a hint to access a materialized view?

1469


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

592


Explain what are the advantages of views?

614


How to create a table interactively?

562


What happens if recursive calls get out of control?

551


Which are the five query types available in oracle?

532


Does oracle partitioning improve performance?

554


How to retrieve data from an explicit cursor?

562