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?
617A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
558You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
590If 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?
589Post New Oracle DBA (Database Administration) Questions
What parameters control copy latches?
I am getting error "no communication channel" after changing the domain name? What is the solution?
What does a senior database administrator do?
Which database is best to learn?
How can you determine if an oracle instance is up from the operating system level?
How long does it take to learn database administration?
When should the default values for oracle initialization parameters be used as is?
Explain procedure to change characterset of a database.
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
How many types of dba are there?
What is pct free/pct used/pct increase parameter in segment?
How does one coalesce free space?
What are the goals of dba?
What is explain plan and how is it used?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
