Users 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?
You 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?
While taking hot backup (begin end backup) what will happens back end?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
If you are not sure what command does a particular unix function what is the best way to determine the command?
If you see contention for library caches how you can fix it?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What are some indications that you need to increase the shared_pool_size parameter?
When should you increase copy latches? What parameters control copy latches?
How should a many-to-many relationship be handled?
If you see statistics that deal with "undo" what are they really talking about?
When should the default values for oracle initialization parameters be used as is?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What is the purpose of the import option ignore? What is its default setting?
