Apart from parsing
A transaction is nothing but SQL statements which is tracked with an unique transaction ID until commit / rollback / DDL are issued. ooh ooh hold on, before i get into the internals lets have a quick view on the basic's of Locks.
Is this true - "Picture Speaks Louder Than Words"
For the next series of diagrams concentrate on the below arrow in each diagram-
Lets start with a basic query and check what happens
Step-1
Step-2
Step-3
Step-4
Step-5
Step-6
Step-7
does these diagrams helped you to understand something, will continue internals soon
- What happens when i issue an update statement ?
- How does Oracle comply with the properties of a Database Transaction aka ACID properties
A transaction is nothing but SQL statements which is tracked with an unique transaction ID until commit / rollback / DDL are issued. ooh ooh hold on, before i get into the internals lets have a quick view on the basic's of Locks.
Is this true - "Picture Speaks Louder Than Words"
For the next series of diagrams concentrate on the below arrow in each diagram-
Lets start with a basic query and check what happens
Step-1
Step-2
Step-3
Step-4
Step-5
Step-6
Step-7
does these diagrams helped you to understand something, will continue internals soon
No comments:
Post a Comment