Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

        
 
   Oracle Tips by Burleson

Oracle 10g Easier Transaction Recovery Monitoring

During the second phase of instance recovery, Oracle rolls back uncommitted transactions. Oracle uses two methods: 'Fast-start on-demand rollback' and 'fast-start parallel rollback'. Together, these two features help to increase the efficiency of the recovery phase.

Using the fast-start on-demand rollback feature, the required transaction's recovery is handled first. If a user attempts to access a row that is locked by a terminated transaction, Oracle rolls back only those changes necessary to complete the transaction; in other words, it rolls them back on demand. Consequently, new transactions do not have to wait until all parts of a long transaction are rolled back.

In the fast-start parallel rollback method, the background process SMON acts as a coordinator and rolls back a set of transactions in parallel using multiple server processes. This feature is particularly useful when a system has transactions that run a long time before committing, especially parallel INSERT, UPDATE, and DELETE operations. SMON automatically decides when to begin parallel rollback and disperses the work among several parallel processes.

You can monitor the progress of fast-start parallel rollback by examining the v$fast_start_servers and v$fast_start_transactions views. v$fast_start_servers provides information about all recovery processes performing fast-start parallel rollback. v$fast_start_transactions contains data about the progress of the transactions.

There are three new columns in the 10g release that assist monitoring. They are XID, PXID, and RCVSERVERS, as shown in the description below.

SQL> desc V$FAST_START_TRANSACTIONS

 Name                         Null?    Type

 ---------------------------- -------- ------------

 USN                                   NUMBER

 SLT                                   NUMBER

 SEQ                                   NUMBER

 STATE                                 VARCHAR2(16)

 UNDOBLOCKSDONE                        NUMBER

 UNDOBLOCKSTOTAL                       NUMBER

 PID                                   NUMBER

 CPUTIME                               NUMBER

 PARENTUSN                             NUMBER

 PARENTSLT                             NUMBER

 PARENTSEQ                             NUMBER

 XID                                   RAW(8)

 PXID                                  RAW(8)

 RCVSERVERS                            NUMBER
 


Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://www.rampant-books.com/book_2003_2_oracle10g.htm


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.