Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
564Users 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?
643You 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?
829You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
627If you are not sure what command does a particular unix function what is the best way to determine the command?
591You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
576What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
667Post New Oracle DBA (Database Administration) Questions
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What happens if the constraint name is left out of a constraint clause?
When using oracle export/import what character set concerns might come up? How do you handle them?
What are the possible ways to gain information regarding the control file?
What is oracle partial backup?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
What is the most common database language that a db administrator needs to know?
What is oracle dba role?
What do you mean by dba?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
Is oracle dba in demand?
What is pga_aggregate_target?
What is oracle full backup?
How do I become a database administrator?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?