Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
526Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
612You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
794You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
590If you are not sure what command does a particular unix function what is the best way to determine the command?
565You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
541What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
638Post New Oracle DBA (Database Administration) Questions
What is the dba role in oracle?
How many redo logs should you have and how should they be configured for maximum recoverability?
What is oracle dba role?
Are database administrators in demand?
Which function is used to find the largest integer less than or equal to aspecific value?
System tablespace cant be exported from one database and imported into another why?
How does one coalesce free space?
What is oracle archived redo log?
What are the important tasks of common oracle dba?
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?
Explain force logging feature in 9i.
I have applied the following commands: now what will happen, will the database will give an error / it will work?
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?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
What is the advantage of using rman?