Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle how to maintain the consistency of read?     - DB2 Version SQLJ to access Oracle Server (Database)

- Laravel configuration PhpStorm + Xdebug + Chrome settings Debug Environment (Server)

- MySQL password on those things you should know (Database)

- Docker + OpenvSwitch build experimental environment VxLAN (Server)

- CentOS 6.4 (64bit) install Python 2.7.5 (Linux)

- Ubuntu install perfectly handsome terminal Guake 0.8.1 (Linux)

- RedHat Linux 6 desktop installation (Linux)

- C # Future: Method Contract (Programming)

- Java regular expression syntax (Programming)

- Node.js installed on Ubuntu Upstream version (Linux)

- Ubuntu Apache virtual host configuration (Server)

- Linux how to view the graphics models notebook (Linux)

- CentOS iptables firewall configuration (Linux)

- Comparison of sorting algorithms (Programming)

- 10 Regulation of painless SQL Schema (Database)

- Java Class file format parsing (Programming)

- Detailed LVM2 (Linux)

- Partition and file system under Linux (Linux)

- To use Android RecyclerView (Programming)

- Phoenix agents use P2P WebRTC development (Programming)

  Oracle how to maintain the consistency of read?
  Add Date : 2018-11-21      
  Read the same principle is to query the record this point in time is determined by the query, even if behind the change, but also according to the rewind held before the mirror record, to take the data that point. Oracle is how to ensure it? First, we must be aware of two situations:

1, SCN: System Change Number. This is a decrease not only increase the incremental number is present in the smallest unit block in ORACLE, but a piece of change SCN is incremented.

2, the database rollback segment track, the groove of things are used to allocate space for the rollback. If you update a block, the transaction will be written into the transaction slot. If you do not commit or rollback, the block there is an active transaction, the database blocks read times can recognize the existence of such a situation.

Therefore, Oracle is doing a consistent read, first look launch of SCN SCN is greater than the current query block if less than no doubt get the first image data from the rollback segment. If indeed greater than the current SCN SCN query block, make sure that the block is no active transactions, or otherwise to find the mirror before going.

So ORACLE rollback can either roll back the data, and can ensure the consistency of Reading.
- Difference LVS three scheduling modes (Server)
- Github Getting Started Basic Course (Linux)
- 10 Best Swift Tutorial examples (Programming)
- Use PuTTY to access the virtual machine Linux under Windows xp (Programming)
- Java recognize simple codes (Programming)
- Usage Linux device tree (Programming)
- Linux open handle limit adjustment (Linux)
- Python closure and function objects (Programming)
- Linux Command Line Art (Linux)
- TeamCity continuous integration in the Linux installation (Linux)
- Ora-00020: maximum number of processes (500) exceeded (Database)
- Oracle Client + PL SQL Developer enables remote access to the Oracle database (Database)
- Approach the next Linux shared interrupts (Linux)
- Command line tool Tmux (Linux)
- XtraBackup achieve non-stop use of master-slave synchronization service (Database)
- How to set up HTTPS policies for older browsers (Server)
- Getting Started with Java NIO (Programming)
- Taught you how to build your own VPS server (Server)
- Linux, modify the fstab file system can not start causing solve one case (Linux)
- ORA-12547: TNS: lost contact error Solution (Database)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.