What are the goals of dba?
- 0 Answers
- 308 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How can you find dead processes?
What is the difference between truncate and delete? Why is one faster?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What parameters control copy latches?
How can you tell if a tablespace has excessive fragmentation?
Which process writes data from data files to database buffer cache?
List five most important parameter in 9i affecting performance?
What do you understand by the term 'system change number (scn)'?
While taking hot backup (begin end backup) what will happens back end?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
Oracle General 
