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 ...
Still reviewing. Thanks for your interest. I wrote a White Paper that actually is under revision. It will be distributed the first month exclusively from http://oracleracsig.org Bookmark this page and come back after Jun 21, 2010. Regards, J ...
This utility was introduced in Oracle 11.1, it is an excellent tool to understand if your actual workload is overloading your disks or file systems. I/O is very important in an Oracle database so I really recommend to all DBAs the use of this great utility to know the actual capacity of your hardware. Below ...
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 ...
Premier Support for the 10gR2 database ends in July 2010. If you haven’t already started planning your 11g database upgrade, we recommend that you start as soon as possible . ...
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 ...
PL/SQL can often add to program functionality and programmer efficiency, and there are certainly many cases in which a procedural language such as PL/SQL can do things that a nonprocedural language such as SQL cannot. For a number of reasons, a PL/SQL approach might offer great performance improvements over a traditional SQL approach. Why to ...
Some useful awr queries, change according your needs. Top 10 queries by resource usage across all executions SELECT * FROM (SELECT SQL_ID, SUM(disk_reads_delta) AS “Disk Reads” FROM DBA_HIST_SQLSTAT S WHERE SNAP_ID > 209 AND SNAP_ID <= 210 AND S.MODULE = ‘ClaimCenter’ GROUP BY SQL_ID HAVING SUM(disk_reads_delta) >= 0 ORDER BY 2 DESC) DERIVED_TABLE WHERE ROWNUM ...
Yes, it does. Capture is still not supported by GoldenGate, but I know Oracle actually is evaluating the possibility. Sources From an old GoldenGate WhitePaper (This WP was wrote before Oracle acquire TimesTen) … Comprehensive Platform Support GoldenGate can replicate data bi-directionally between any combination of Oracle, DB2,Microsoft SQL Server, Sybase, Informix, NonStop SQL and ...