You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
No Answer is Posted For this Question
Be the First to Post Answer
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Tell me about standby database? What should we watch out for?
How do you analyze table partition using oracle provided package?
Explain the term 'oracle grid architecture'?
How would you find total size of database in os level?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What skills do you need to be a database administrator?
I am getting error "no communication channel" after changing the domain name? What is the solution?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
What are the different responsibilities of a dba?
What is pct free/pct used/pct increase parameter in segment?
What does the no logging option do? Why would we use it? Why would we be careful of using it?