- 3,741,291 Users
- 2,248,405 Discussions
- 7,861,726 Comments
- 5.1K All Categories
- 8 Introduce Yourself!
- 300 Community Feedback - NEW! (No Product Questions)
- 68 General Community Platform Concerns/Kudos/Feedback
- 56 Community Platform Bug Reports
- 66 How Do I Use the Community?
- 15 Where is the...? (Community Platform Locations)
- 11 Ideas and Suggestions for the Community Platform
- 65 Personal Document & Blog Archive
- 2 Community Programs
- 2 Get-Togethers
- 4.7K Certification Community
- 4.6K Certification Community Discussions
- 20 Oracle Certified Master Profiles
- 26 Oracle Database 12c Administrator Certified Master Profiles
- 40 Visual Builder Cloud Service
Commit statements wait for gc current grant 2-way
I need help in understanding critical functionality of COMMIT statement.
As per my knowledge after a commit is issues below things takes place:
1. Transaction table is modified and a SCN number generated is marked to the UNDO record.
2. LGWR writes the redo log buffer entries to redo log files.
3. LGWR post the confirmation to server process -- prompt reture to the user.
4. Locks release,etc...
Now here in my case what i see is a COMMIT statment (RAC) is waiting for "gc current grant 2-way" as per TKPROF/TRACE
wait event gc current grant 2-way is associated with the Data Blocks that are not present on the SGA for any node and hence it has to be get from remote node,
but the doubt here is why and which blocks a COMMIT statment is expecting from remote node...