Oracle General (1809)
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?
1193How many redo logs should you have and how should they be configured for maximum recoverability?
567Describe 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?
589Where 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?
610You 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?
541
Explain the use of control file?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How many types of synonyms in Oracle?
State the difference between a primary key and foreign key?
What is an index associated with a constraint?
Which is faster join or subquery in oracle?
Does oracle database need java?
Discuss row chaining, how does it happen?
Is there any function in oracle similar like group_concat of mysql?
What is a synonym? What are its various types?
How many types of v variables'? Where will appear for variables in odi?
What are the daily activities of oracle dba?
How do you tell what your machine name is and what is its IP address?
What is the difference between conversions and interfaces? : oracle accounts receivable
can we implement package in package?