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?
285A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
288You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
310If 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?
815How many redo logs should you have and how should they be configured for maximum recoverability?
297Describe 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?
310Post New Oracle DBA (Database Administration) Questions
What is the meaning of database backup?
What is the dba role in oracle?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
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?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What is oracle dba role?
What skills do you need to be an administrator?
What is the easiest method to create a file on unix?
What is the main function of database?
Discuss row chaining, how does it happen?
What are the different responsibilities of a dba?
How do you generate file output from sql?
What database block size should I use?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
What is oracle partial backup?
