Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
No Answer is Posted For this Question
Be the First to Post Answer
How many control files should you have? Where should they be located?
How can you determine the number of sqlnet users logged in to the unix system?
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 are the steps involved in instance recovery in oracle?
If you are not sure what command does a particular unix function what is the best way to determine the command?
Discuss row chaining, how does it happen? How do you correct it?
Explain the wait events in statspack report 'db scattered read'?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
What are dba privileges?
What are the roles and responsibilities of oracle dba?
Who is a database user?
Describe 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?