Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
1237How many redo logs should you have and how should they be configured for maximum recoverability?
606Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
628Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
576Users 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?
657You 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?
841You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
642If you are not sure what command does a particular unix function what is the best way to determine the command?
602You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
583
What skills should a dba have?
What is the difference between restoring a database and recovering a database?
Explain the process of recievables in oracle financials. : oracle accounts receivable
How to use select statement to count the number of rows in oracle?
What are privileges and grants?
How to revoke create session privilege from a user in oracle?
why dont we assign not null constraint as table level constraint.
What is Reduced List of Values?
Mention what is cluster?
How many types of dimensions in oracle?
What are the variable types?
What are a collation and state the different types of collation sensitivity?
What is the difference between view and materialized view in Oracle?
How to test null values?
what is the difference between substr and instr function in oracle?