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
What do you understand by a control file?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
How do you install statspack?
Explain the term 'oracle grid architecture'?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
Does dba need to know programming?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
How many control files should you have?
How can you determine the number of sqlnet users logged in to the unix system?
What is the difference between raid 5 and raid 10? Which is better for oracle?
What file will give you oracle instance status information? Where is it located?