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?
560A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
510You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
538If 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?
1146How many redo logs should you have and how should they be configured for maximum recoverability?
518Describe 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?
540Post New Oracle DBA (Database Administration) Questions
Describe 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?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
Do you need a commit after ddl statements?
What is a production dba?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What is a dba?
What is oracle partial backup?
Which function is used to find the largest integer less than or equal to aspecific value?
What is the difference between a database and instance?
How can you determine if an index needs to be dropped and rebuilt?
I am getting error "no communication channel" after changing the domain name? What is the solution?
What does a senior database administrator do?
What are elements of administration?
How many types of dba are there?
