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?
361You 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?
271If you have an example table, what is the best way to get sizing data for the production table implementation?
279Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
273Explain 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?
300If you see the value for reloads is high in the estat library cache report is this a matter for concern?
339Post New Oracle DBA (Database Administration) Questions
Discuss row chaining, how does it happen?
What os user should be used for the first part of an oracle installation (on unix)?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
When should you increase copy latches? What parameters control copy latches?
What is the difference between raid 5 and raid 10? Which is better for oracle?
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?
What is a dba?
What is the use of the drop option in the alter table command?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What is the difference between a database and instance?
Explain force logging feature in 9i.
What is explain plan and how is it used?
What is a dba why is this position necessary?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
