So, this assignment is where you take the code shown below (the items highlighte

Question

So, this assignment is where you take the code shown below (the items highlighted in bold). When you run this script, it is supposed to leave you connected as Iggy/oracle.

Next, you start a second instance of Iggy/oracle. Reduce the window size of each instance of sqlplus so that you can view them side by side.

In the LEFT instance, run DELETE FROM child WHERE child_ID=1;
In the RIGHT instance, run DELETE FROM child WHERE child_ID=2;
In the LEFT instance, run DELETE FROM parent WHERE parent_ID=1; (nothing happens in left window.)
In the RIGHT instance, run DELETE FROM parent WHERE parent_ID=2; (nothing happens in right window.)
At this point you will see the error message for the deadlock in the left window.
After creating a deadlock, run SQL Developer and start Tools|Monitor Sessions

Explanation / Answer

Run sqlplus SYSTEM/Oracle11 and START c:S2Script.sql When finished, the script leaves you connected as Iggy/oracle.
Start a second instance of Iggy/oracle. Reduce the window size of each instance of sqlplus so that you can view them side by side.
In the LEFT instance, run DELETE FROM child WHERE child_ID=1;
In the RIGHT instance, run DELETE FROM child WHERE child_ID=2;
In the LEFT instance, run DELETE FROM parent WHERE parent_ID=1; (nothing happens in left window.)
In the RIGHT instance, run DELETE FROM parent WHERE parent_ID=2; (nothing happens in right window.)
At this point you will see the error message for the deadlock in the left window.
After creating a deadlock, run SQL Developer and start Tools|Monitor Sessions

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.