How does one coalesce free space?
No Answer is Posted For this Question
Be the First to Post Answer
You see multiple extents in the temporary tablespace. Is this a problem?
Explain the wait events in statspack report 'db scattered read'?
How many control files should you have? Where should they be located?
What do you mean by dba?
What database block size should I use?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
What is dba training?
When should an artificial (or derived) primary key be used?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What is a dba?