Oracle Database Transactions and Locking Revealed (2nd Ed., 2nd ed.) Building High Performance Through Concurrency
Auteurs : Kuhn Darl, Kyte Thomas
- Avoid application lockups due to conflicts over accessing the same resource
- Understand how Oracle prevents one application from overwriting another?s modifications
- Create transaction designs that mesh with how Oracle Database is designed
- Build high-throughput applications supporting thousands of concurrent users
- Design applications to take full advantage of Oracle?s powerful database engine
- Gain a fundamental knowledge of Oracle?s transaction and locking architecture
- Develop techniques to quickly diagnose and resolve common locking issues
1. Getting Started
2. Locking and Blocking
3. Locks, Latches, and Mutexes
4. Concurrency and Multiversioning
5. Transactions
6. Redo and Undo
7. Investigating Redo
8. Investigating Undo
9. Troubleshooting
Gives you quick troubleshooting advice when you are faced with urgent locking conflicts
Provides a deep explanation of how Oracle’s locking mechanisms enable high throughput
Covers best practices for transaction design aimed at high throughput and high concurrency
Date de parution : 10-2020
Ouvrage de 265 p.
17.8x25.4 cm