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 degree do database administrators need?
What is dba training?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What happens if a tablespace clause is left off of a primary key constraint clause?
What are the different types of database users?
What is oracle archived redo log?
What does >> do?
What database block size should I use?
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?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What do you understand by the term 'system change number (scn)'?
What should a dba know?
Are database administrators in demand?
What do you mean by dba?
What do you understand by the term 'normalization'?