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
How to drop an oracle database?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
Explain the wait events in statspack report 'db scattered read'?
When should the default values for oracle initialization parameters be used as is?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
What do you mean by oracle database?
What is pct free/pct used/pct increase parameter in segment?
How many types of dba are there?
How can you determine if an oracle instance is up from the operating system level?
How many redo logs should you have and how should they be configured for maximum recoverability?
How do you prevent output from coming to the screen?
What does a dba stand for?