What is a Shared SQL pool ?

Answer Posted / sawant

The data dictionary cache is stored in an area in SGA called
the Shared SQL Pool. This will allow sharing of parsed
SQL statements among concurrent users.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to build data dictionary view an new database?

794


Whether any commands are used for months calculation? If so, what are they?

848


what is Single Byte Overhead...?

2296


How to create a new table in your schema?

821


what are actual and formal parameters?

801


How do we represent comments in oracle?

834


How does Oracle guarantee data integrity of data changes?

2147


How to display row numbers with the records?

804


Difference between pre-select and pre-query

795


How to rename an index?

808


How do I find my oracle client driver version?

741


How many types of table in Oracle?

850


is there a tool to trace queries, like profiler for sql server?

826


How to export data to a csv file?

852


Can you create a synonym without having a table?

780