A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
679You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
603If you have an example table, what is the best way to get sizing data for the production table implementation?
547Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
527Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
568If you see the value for reloads is high in the estat library cache report is this a matter for concern?
622Post New Oracle DBA (Database Administration) Questions
What are some indications that you need to increase the shared_pool_size parameter?
What is different type of rman backup?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What is a dba programmer?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
What are the important tasks of common oracle dba?
What is ora-1555 snapshot too old error? Explain in detail?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
What happens if a tablespace clause is left off of a primary key constraint clause?
What is the advantage of using rman?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What does >> do?
What is the purpose of the grep command?