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).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Source: Oracle Corporation.
- 2.
BAST (Blocking asynchronous system trap), a notification mechanism to release a block used by the global cache service.
- 3.
Metalink Note # 22908.1.
- 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.
Underscore parameters should be modified only after consultation with Oracle support.
- 6.
In previous versions of Oracle, this was based on parameters _GC_AFFINITY_MINIMUM and _GC_AFFINITY_TIME.
- 7.
GV$DYNAMIC_REMASTER_STATS is based on X$KJDRMAFNSTATS.
- 8.
Underscore parameters should be changed only with prior approval and discussion with Oracle support.
- 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.
Underscore parameters should be enabled only with prior consultation with Oracle Support.
Author information
Authors and Affiliations
Rights 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
DOI: https://doi.org/10.1007/978-1-4302-6710-2_13
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6709-6
Online ISBN: 978-1-4302-6710-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books