Un-Answered Questions { Oracle DBA (Database Administration) }

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?

499


You 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?

453


If you have an example table, what is the best way to get sizing data for the production table implementation?

401


What file will give you oracle instance status information? Where is it located?

413


A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

406


How would you find total size of database in os level?

399


What is ora-1555 snapshot too old error? Explain in detail?

499


What is an artificial (derived) primary key?

425


What is different type of rman backup?

450


You see multiple fragments in the system tablespace, what should you check first?

422


Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

390


Explain 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?

427


How do you set up your tablespace on installation level: low?

407


If you see the value for reloads is high in the estat library cache report is this a matter for concern?

455


If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

446