Oracle parallel transaction Rollback related parameters and views

Source: Internet
Author: User

/****** Related Parameters ****/
Fast_start_parallel_rollback
1. There are 3 kinds of values: False,low,high
2. Value Meaning: False---Disable the parallel rollback feature
Low---Parallel rollback max is 2*cpu_count
High---Parallel rollback maximum is 4*cpu_count
3. This parameter applies to parallel DML or parallel DDL that was not completed before system crash
4. Determine the degree of parallelism for parallel rollback
5. This parameter applies the rollback phase after the roll-forward is completed for the undo block operation

/****** related views ****/
V$fast_start_servers
1. View the working status of a recovery subprocess that implements parallel transaction recovery
2. Sub-process status: idle,recovering
Number of Undo Block applied
Transaction ID
Process ID of the child process

V$fast_start_transactions
Review the progress of the recovery several important columns:
USN--Recovery transaction undo segment Number
State---Restore the status of the transaction: recovery complete, not recovered
The process ID of the PID---recovery transaction
Udnoblocksdone-Number of undo blocks applied
Undoblockstotal--Total number of undo blocks
XID---transaction ID
Parentusn--undo segment number for the parent transaction of the parallel DML transaction


/****** related sql****/
Select
Undoblockstotal "Total",
Undoblocksdone "Done",
Undoblockstotal-undoblocksdone "ToDo",
To_char (sysdate, ' yyyy-mm-dd hh24:mi:ss ')
From V$fast_start_transactions;

Oracle parallel transaction Rollback related parameters and views

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.