What is a Shared SQL pool ?

Answer Posted / rashid ansari

shared pool contain data dictionary and library
cache.oracle make a execution plan into sheared pool

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1824


What privilege is needed for a user to connect to oracle server?

780


How to drop an index in oracle?

829


Is there any function in oracle similar like group_concat of mysql?

827


What is Undo Management Advisor in Oracle?

832


How to return top 5 rows in oracle?

812


How do I manually uninstall oracle client?

783


defination of bitmap index

1835


What is a trigger and what are its types?

829


What are the various oracle database objects?

897


How to create a new view in oracle?

851


How to display row numbers with the records?

821


How to write numeric literals in oracle?

922


What is Data Dictionary Cache in Oracle?

929


What is proxy method?

756