How can you tell if a tablespace has excessive f

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How can you tell if a tablespace has excessive fragmentation?

Level: Intermediate
If a select against the dba_free_space table shows that the count of a tablespaces extents is greater than the count of its data files, then it is fragmented.

(Continued on next question...)

Other Job Interview Questions

• What is a deadlock? Explain.
• What are the type of Synonyms?
• What are the Built-ins used for sending Parameters to forms?
• How is link tool operation different bet. reports 2 & 2.5?
• Explain iostat, vmstat and netstat.
• Can objects of the same Schema reside in different tablespaces?
• How can you tell if a database object is invalid?
• To execute row from being displayed that still use column in the row which property can be used?
• What is Two-Phase Commit?
• What is an LOV?
• More...