How can you tell if a tablespace has excessive fragmentation?

Question Posted / sarvendra kumar

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

More Oracle DBA (Database Administration) Interview Questions

How many types of dba are there?

What do you understand by recovery catalog?

using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?

What is the meaning of database backup?

What are the steps involved in instance recovery in oracle?

If you see contention for library caches how you can fix it?

What are the different types of backup available in the oracle?

How can you find all the processes on your system?

You see multiple extents in the temporary tablespace. Is this a problem?

How do you set up tablespaces during an oracle installation?

While taking hot backup (begin end backup) what will happens back end?

What is dba training?

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