Interested to Buy Any Domain ? << Click Here >> for more details...
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?
648A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
596You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
623If 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?
1227How many redo logs should you have and how should they be configured for maximum recoverability?
598Describe 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?
624Post New Oracle DBA (Database Administration) Questions
Explain the term 'oracle grid architecture'?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What are the different responsibilities of a dba?
If you see contention for library caches how you can fix it?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What does an oracle dba do?
What degree do database administrators need?
What are some indications that you need to increase the shared_pool_size parameter?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
Tell me about standby database? What should we watch out for?
While taking hot backup (begin end backup) what will happens back end?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
System tablespace cant be exported from one database and imported into another why?
