-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Scenario 1) Default transaction using AUTONOMOUS TRANSACTION and checking records in table called APP_LOG at each step. The store procedure… READ MORE
Example of how AUTONOMOUS_TRANSACTION, it allows one to isolate a DML statements, the DML statements with the AUTONOMOUS transaction are… READ MORE
Examples of using “SAVEPOINT” and “ROLLBACK TO” SQL> select * from scott.test; no rows selected SQL> insert into scott.test values… READ MORE
In 10g, there is a column in V$session called blocking_session to find the session id that is blocking. Session 1)… READ MORE
The following 2 links explains transaction isolation. http://www.acs.ilstu.edu/docs/Oracle/server.101/b10743/consist.htm http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 