When downtime matters you need to determine high availability ratios, this is often expressed as the percentage (%) of uptime in a year. The following table shows the approximate downtime that is allowed for a specific percentage of high availability: The following table from the International Organization for Standardization (ISO) illustrates the correlation from a ...
Who should read this white paper? This white paper is intended to be accessible to those who are not relatively new to the Real Applications Cluster performance. Familiarity with advanced Oracle concepts and SQL language is assumed. About Technical Reviewers Pablo Albeck – Oracle Practice Manager at Oracle Corporation, with several years of experience in ...
Background Processes From 10g and over, Real Application Cluster databases has two new background processes: LMON – The Global Enqueue Service Monitor monitors the entire cluster to manage the global enqueues and the cluster resources. LMON manages instance and process failures and the associated recovery for the Global Cache Service (GCS) and Global Enqueue Service ...
The contention in blocks can be measured by using the block transfer statistic. The first step is to determine block transfer time examining the gv$sysstat view: global cache cr block receive time global cache cr blocks received. The time is determined by calculating the ratio of global cache cr block receive time to global cache ...
UAYOR – Use at your on risk. OS: Linux CentOS 5.4 CFS: OCFS2 - /u01 Oracle clusterware installation (11.1.0.6.0) finished successfully , but when trying to run root.sh in the first node I’m getting the following error: [root@prod10 oracle]# sh -x /u00/clusterware/11.1.0/crs/root.sh + /u00/clusterware/11.1.0/crs/install/rootinstall + /u00/clusterware/11.1.0/crs/install/rootconfig Checking to see if Oracle CRS stack is ...
The Query Processing category includes the statistics used to calculate the hit ratio for the database. In this post are just explained the most important. This information is related to the dynamic statistic table v$sysstat. The main purpose of this post is to add basic knowledge when trying to tune queries in oracle database environments ...
Clusterware internals Let to me make a brief introduction, the Oracle clusterware software is installed in the cluster with its own set of binaries. CRS Home and Oracle Home are in different locations, it means that there are two installations initially. The clusterware software installs and configures both the Voting Disk file and the OCR ...
During 2007 I wrote a spanish white paper about the use of clusterware to protect single instances, this is not a well known use of clusterware, not translated to english. Step by Step – “Cluster Filesystem Case” Abril 2007 Version 1.05 Step-by-Step: Utilizando el Clusterware de Oracle para proteger una base Oracle single instance “Entienda ...
UPDATE 02-JUL-2010 : Please read my white paper here. The effect of accessing blocks in the global cache and maintaining coherency is represented by “The Global Cache Service” statistics for current and cr blocks, for example, gc current blocks received, gc cr blocks received, and so on Much of these GC waits are blamed on ...
Yes, I did! … but you’re are not allowed to use use asmcfs. Questions to info@jose-valerio.com.ar, subject: 11g R2-CentOS My cheap lab: RAC 11g R2 – Two nodes Storage: Openfiler (iscsi) – Standalone Server Hardware: Two PC Dual Core 2Ghz, 2 GB RAM, Ether Lan cards GB. Networking : Two Generic Switches 2 GB Database ...