What are some indications that you need to increase the shared_pool

What are some indications that you need to increase the shared_pool_size parameter?

Question Posted / alok kumar

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle DBA (Database Administration) Interview Questions

You see multiple fragments in the system tablespace, what should you check first?

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

What is oracle archived redo log?

Why do we need a database?

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

what does the no logging option do? Why would we use it?

What are the various ingredients of sga?

Which dba certification is best?

How to uncatalog backup?

What do you understand by the term 'system change number (scn)'?

I am getting error "no communication channel" after changing the domain name? What is the solution?

How many types of database software are there?

For more Oracle DBA (Database Administration) Interview Questions Click Here