If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
568using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 1000What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
554What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
573Post New Oracle DBA (Database Administration) Questions
What is tkprof and how is it used?
What is difference between logical standby database and physical standby database?
What are the daily activities of oracle dba?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
Explain the term 'oracle grid architecture'?
What skills do you need to be an administrator?
How can you find dead processes?
Which dba certification is best?
If you have an example table, what is the best way to get sizing data for the production table implementation?
What is the difference between sga and pga?
How do you analyze table partition using oracle provided package?
What are the types of locks in database?
What is ora-1555 snapshot too old error? Explain in detail?
Are database administrators in demand?