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 the term 'normalization'?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What is the relation between database and instance?
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?
What are the requirements of simple database?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
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 database block size should I use?
If you see contention for library caches how you can fix it?
Who is a database user?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What does a senior database administrator do?