Skip to main content

Tuning Global Cache

  • Chapter
  • First Online:
Expert Oracle RAC Performance Diagnostics and Tuning
  • 577 Accesses

Abstract

Real Application Cluster (RAC) can be considered as an extension to the single instance configuration. As a concept, this is true, because RAC is a composition of several instances of Oracle. However, there are quite a few differences in the management of these components, the additional background process, the additional files, and the sharing of resources between instances, not to mention the additional layered components present at the operating system level to support a clustered hardware environment. All of these additional components in a RAC system make it different from a single-instance configuration. It is also in a RAC configuration that the real difference between a database and an instance is noticed. Although this difference does exist in a regular single-instance configuration, this is seldom noticed because the database and an instance are not distinguished from each other as they are in a RAC configuration (e.g., in a single-instance configuration, the instance and the database are identified by the same name).

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Source: Oracle Corporation.

  2. 2.

    BAST (Blocking asynchronous system trap), a notification mechanism to release a block used by the global cache service.

  3. 3.

    Metalink Note # 22908.1.

  4. 4.

    Setting of the LMS to run at this priority class is driven by the underscore parameter _HIGH_PRIORITY_PROCESSES, and the values are set to LMS|VKTM. VKTM (Virtual Time Keeper) is a new background process introduced in Oracle Database 11g Release 2 and manages the time across the RAC cluster.

  5. 5.

    Underscore parameters should be modified only after consultation with Oracle support.

  6. 6.

    In previous versions of Oracle, this was based on parameters _GC_AFFINITY_MINIMUM and _GC_AFFINITY_TIME.

  7. 7.

    GV$DYNAMIC_REMASTER_STATS is based on X$KJDRMAFNSTATS.

  8. 8.

    Underscore parameters should be changed only with prior approval and discussion with Oracle support.

  9. 9.

    10046 trace can be enabled using alter session set events "10046 trace name context forever, level 12" and can be disabled using alter session set events "10046 trace name context off." The trace output will be generated in the location defined by the parameter user_dump_dest.

  10. 10.

    Underscore parameters should be enabled only with prior consultation with Oracle Support.

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Murali Vallath

About this chapter

Cite this chapter

Vallath, M. (2014). Tuning Global Cache. In: Expert Oracle RAC Performance Diagnostics and Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6710-2_13

Download citation

Publish with us

Policies and ethics