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 is the difference between rman and a traditional hotbackup?
How do you install statspack?
What is a dba why is this position necessary?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What is pga_aggregate_target?
What do you understand by the term 'system change number (scn)'?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
What is the difference between truncate and delete? How would a full table scan behave after?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What are the daily activities of oracle dba?
What is the difference between cold backup and hot backup?