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?
No Answer is Posted For this Question
Be the First to Post Answer
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What file will give you oracle instance status information? Where is it located?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What are the daily activities of oracle dba?
What is oracle full backup?
What is the meaning of database backup?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
I am getting error "no communication channel" after changing the domain name? What is the solution?
How to uncatalog backup?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
Explain procedure to change characterset of a database.