skip to main content
10.1145/1739041.1739119acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
research-article

Logging last resource optimization for distributed transactions in Oracle WebLogic server

Published: 22 March 2010 Publication History

Abstract

State-of-the-art OLTP systems execute distributed transactions using XA-2PC protocol, a presumed-abort variant of the Two-Phase Commit (2PC) protocol. While the XA specification provides for the Read-Only and 1PC optimizations of 2PC, it does not deal with another important optimization, coined Nested 2PC. In this paper, we describe the Logging Last Resource (LLR) optimization in Oracle WebLogic Server (WLS). It adapts and improves the Nested 2PC optimization to/for the Java Enterprise Edition (JEE) environment. It allows reducing the number of forced (synchronous) writes and the number of exchanged messages when executing distributed transactions that span multiple transactional resources including a SQL database integrated as a JDBC datasource. This optimization has been validated in SPECjAppServer2004 (a standard industry benchmark for JEE) and a variety of internal benchmarks. LLR has been successfully deployed by high-profile customers in mission-critical high-performance applications.

References

[1]
Barga, R., D. Lomet, T. Baby, and S. Agrawal: Persistent Client-Server Database Sessions. In Proceedings of 7th Int'l Conference on Extending Database Technology (EDBT), Konstanz, Germany, Mar 2000: 462--477
[2]
Gray, J.: Notes on Data Base Operating Systems. In Advanced Course: Operating Systems, Springer, 1978: 393--481
[3]
Lampson, D. and D. Lomet: A New Presumed Commit Optimization for Two Phase Commit. In Proceedings of the 19th Int'l Conference on Very Large Data Bases, Dublin, Ireland, Aug 1993, Morgan Kaufmann, San Francisco, CA, USA: 630--640
[4]
Mohan, C. and B. Lindsay: Efficient Commit Protocols for the Tree of Processes Model of Distributed Transactions. In Proceedings of the 2nd ACM SIGACT/SIGOPS Symposium on Principles pf Distributed Computing, Montreal, Quebec, Canada, Aug 1983: 76--88
[5]
Mohan, C., B. Lindsay, and R. Obermark: Transaction Management in the R* Distributed Database Management System. In ACM Transactions on Database Systems, 11(4), Dec 1986: 378--396
[6]
Oracle Corp.: Oracle Benchmark Results, http://www.oracle.com/solutions/performance_scalability/benchmark_results.html
[7]
Oracle Corp.: Oracle Fusion Middleware. http://www.oracle.com/products/middleware/index.html
[8]
Oracle Corp.: Programming WebLogic JTA: Logging Last Resource Transaction Optimization. http://download.oracle.com/docs/cd/E12840_01/wls/docs103/jta/llr.html
[9]
SPEC: SPECjAppServer2004, http://www.spec.org/jAppServer2004/
[10]
Sun Microsystems: Java EE at a Glance. http://java.sun.com/javaee/.
[11]
Sun Microsystems: Java Transaction API Specification 1.0.1, http://java.sun.com/javaee/technologies/jta/
[12]
The Open Group: Distributed Transaction Processing: The XA Specification. X/Open Company Ltd., UK, 1991
[13]
Weikum, G. and G. Vossen: Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery. Morgan Kaufmann, San Francisco, CA, USA, 2001

Cited By

View all
  • (2012)Optimizing JMS Performance for Cloud-Based Application ServersProceedings of the 2012 IEEE Fifth International Conference on Cloud Computing10.1109/CLOUD.2012.136(828-835)Online publication date: 24-Jun-2012
  1. Logging last resource optimization for distributed transactions in Oracle WebLogic server

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Other conferences
    EDBT '10: Proceedings of the 13th International Conference on Extending Database Technology
    March 2010
    741 pages
    ISBN:9781605589459
    DOI:10.1145/1739041
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 22 March 2010

    Permissions

    Request permissions for this article.

    Check for updates

    Qualifiers

    • Research-article

    Conference

    EDBT/ICDT '10
    EDBT/ICDT '10: EDBT/ICDT '10 joint conference
    March 22 - 26, 2010
    Lausanne, Switzerland

    Acceptance Rates

    Overall Acceptance Rate 7 of 10 submissions, 70%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)1
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 10 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2012)Optimizing JMS Performance for Cloud-Based Application ServersProceedings of the 2012 IEEE Fifth International Conference on Cloud Computing10.1109/CLOUD.2012.136(828-835)Online publication date: 24-Jun-2012

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media