If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
No Answer is Posted For this Question
Be the First to Post Answer
What kinds of responsibilities does a dba have in a database environment?
What is a production dba?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What is the most common database language that a db administrator needs to know?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What happens when the default and temp tablespace clauses are left out from create user statements?
What do you understand by recovery catalog?
How do you prevent output from coming to the screen?
What are types of data model?
Does a dba have to file taxes?
How can you find dead processes?