Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle multi-user concurrency and transaction processing     - Scala REPL Shell call (Programming)

- Use the Find command to help you find those files that need to be cleaned (Linux)

- Linux command binlog by filtering out the complete SQL statement (Database)

- Java threads in the life cycle (Programming)

- Using Vagrant create cross-platform development environment (Linux)

- Install MATE desktop environment adjustment tools Mate Tweak 3.3.6 (Linux)

- C ++ 11 feature: auto keyword (Programming)

- Spring multi data source configuration (Programming)

- QEMU image file used: qcow2 and raw (Linux)

- Nginx Module Development - get user ip (Server)

- Modern Objective-C syntax and new features (Programming)

- To install the Contiki development toolchain on Ubuntu (Linux)

- How to build a custom exclusive Ubuntu Live CD (Linux)

- Vim useful plugin: YouCompleteMe (Linux)

- MySQL enabled SSD storage (Database)

- How do I cancel (almost) any operations in Git, (Linux)

- Linux System Getting Started Learning: compile and install ixgbe driver in Ubuntu or Debian (Linux)

- Linux kernel to achieve soft RPS network to receive soft interrupt load balancing to distribute (Linux)

- Common DDOS attacks (Linux)

- To install Ganglia configuration of experience under CentOS 5.5 (Linux)

 
         
  Oracle multi-user concurrency and transaction processing
     
  Add Date : 2018-11-21      
         
         
         
  Oracle multi-user concurrent access
Services: an integral role in the operation of certain data
 
Lock: write lock, mutex (can only be used by a process) read lock, shared lock (can be used by multiple processes)
 
Lost update
Dirty read
Non-repeatable read
Phantom read
 
Isolation level:
1 READ COMMITTED get a complete view of each statement
2 SERIALIZABLE transaction level to implement serialization
 
Oracle Concurrency Features
1 rollback: Store "undo" the data structure information
redo log is used to record all transactions in the database; for providing rollback transaction rollback and read consistency
2 system change number SCN: guarantee the order of transaction execution
3 Data block locks: each lock affects only one row of data blocks
 
Conflict writing process:
1 A update operation
2 Get SCN, read the target data block
3 rows lock information
4-modify-write redo log buffer
5 write rollback
6 B update operations
7 Get SCN, read data block
8 found locked, if it is READ COMMITTED wait to continue after it is executed; if it is SERIALIZABLE, an error is returned
9 A commit the transaction
10 If B READ COMMITTED, continue
 
Workspace: Isolation and variable data, creating specific time version of the data space

Online transaction processing OLTP
 
Atomicity
consistency
Isolation
Persistence
 
OLTP General features:
1 transaction throughput and greater concurrent users
2 specific performance requirements
3 High Availability
4 Scalability
 
Concurrent with the general performance:
1 Non row locks technology: only the transaction row locking, not to upgrade level lock to also level or table level
Over 2 version read consistency: in the case without a read lock statement and transaction level to ensure data consistency
3 Shared SQL: is parsed and optimized SQL stored in the shared memory pool shared SQL area within
4 Memory Summary: Support for the implementation of the stability program
 
Scalability:
MTS multithreaded server
Oracle Net Connection Pooling: allows clients to share a physical network connection pool
Oracle Net Connection Manager: assign a network connection for multiple clients. There is no "time out"
 
Real-time application clusters:
Cache Fusion: all data stored in the Real Application Clusters in each cache on each host, these data are available for any other host of anxious people.
 
High availability:
1 standby database:
2 transparent failover TAF: When the host instance fails, another automatically connect to the oracle instance
3 oracle stream / Advanced Queuing AQ: between an asynchronous communication method or system extension
4 Oracle stream copy: use built-in replication feature provides data redundancy
     
         
         
         
  More:      
 
- Nginx Proxy timeout Troubleshooting (Server)
- CentOS source installation GitLab Chinese Version (Server)
- Grading defense against Linux server attacks (Linux)
- Spring AOP (Programming)
- Applications in Objective-C runtime mechanism (Programming)
- The several technical presentation Raid under Linux (Linux)
- Amazon EC2 server using Rsync + Inotify real-time synchronization (Server)
- Linux use chattr and lsattr commands to manage file and directory attributes (Linux)
- installation and configuration of the PHP environment (Apache2) under Linux (Server)
- HomeKit Human Interface Guidelines (Linux)
- CentOS 6 Install Linux kernel source (Linux)
- Linux environment variable configuration and save places (Linux)
- SQLite3 simple operation (Database)
- Linux Quick Install MongoDB (Database)
- Grep how to find files based on file contents in UNIX (Linux)
- UNIX file permissions in the "set user ID bit" (Linux)
- When should I use Angular 2 (Programming)
- CentOS and RHEL installation under GAMIT10.6 (Linux)
- Java to create a table in the database SYBase (Database)
- How to Create a file can not be changed under Linux (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.