What are some indications that you need to increase the shared_pool_size parameter?
No Answer is Posted For this Question
Be the First to Post Answer
If you see contention for library caches how you can fix it?
Tell me about standby database? What should we watch out for?
When should an artificial (or derived) primary key be used?
Explain the various modes of normalization?
What happens when the default and temp tablespace clauses are left out from create user statements?
What are the daily activities of oracle dba?
How many types of dba are there?
What database block size should I use?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What are the beneficial tools for administering the database?
How many control files should you have?
What happens if a tablespace clause is left off of a primary key constraint clause?