Describing installation on Unix or Linux and omitting Windows or VMS would open me for the accusations of being OS biased.
As I really am biased toward one type of OS, I wanted to hide that fact and cover just the common parts.
Therefore, commiting every so often would fix cause 1, but can do nothing about cause 2.
Are there any other scenarios where ORA-01555 can occurr?
Our courses are designed to help the applicants to acquire the required hands-on skills and knowledge to successfully pass these exams.
The exams are administered by Pearson Vue an independent testing organization, with locations worldwide.
With your OCA certification, you will be able to demonstrate and promote the fact that you have the necessary skills to do your job effectively and you are certified by Oracle Coprporation the leader in Database Management Systems.
Oracle Developer/Administrator Certified Associate program is a unique program combining the required courses to become an Oracle Certified Associate both as a Developer and as an Administrator.That user is updating\inserting\deleting a lot of database records without committing.Oracle clears out any unneeded transactions in the rollback segment but eventually it fills up and the error occurs. User B logs into the data base and is updating\inserting\deleting a lot of database records, but is committing every 100 records.Oracle clears out any unneeded transactions in the rollback segment but eventually it fills up and the error occurs.Oracle cannot clear out any of user B's transaction since they are needed to maintain user A's consistent view of the database, which is before user B logged in.