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 to count groups returned with the group by clause in oracle?

833


What to do if the startbd.bat failed to start the xe instance?

840


What is a snapshot in oracle database?

779


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1990


How can we find out the current date and time in oracle?

843


How to rename an existing table?

796


What is flashback in Oracle?

750


What is instant client oracle?

790


How to specify default values in insert statement using oracle?

818


What is archive log in Oracle?

835


What is an index associated with a constraint?

773


How to start your 10g xe server?

797


What is private procedure oracle?

762


Why use resource manager in Oracle?

867


How to list all tables in your schema?

795