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

What is an oracle recycle bin?

560


How to convert characters to dates in oracle?

569


How to change system global area (sga) in oracle?

580


How to view all columns in an existing table?

555


How to recover a dropped table in oracle?

616






What is the use of oracle?

567


Compare and contrast between sql and sql server and explain its various functions?

549


What is a cognitive schema?

532


State any two functions of oracle?

644


Name the various constraints used in oracle?

574


What is oracle server autotrace in oracle?

622


Explain alias?

723


Explain view?

588


How to delete all rows a table in oracle?

633


How to see the table columns used in an index?

608