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

How to put more than 1000 values into an oracle in clause?

596


How to export data to a csv file?

638


What is the difference between count (*), count (expression), count (distinct expression)?

570


How to insert multiple rows with one insert statement in oracle?

583


Explain constraining triggers.

614






How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1951


Why does for update in oracle 8 cause an ora-01002 error?

560


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1811


What are the attributes that are found in a cursor?

659


How to get execution path reports on query statements?

576


What happens if recursive calls get out of control?

563


How to use regular expression in pattern match conditions in oracle?

587


what is the scripts in data base?

1613


What is translate in oracle?

633


How do I reset a sequence in oracle?

619