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 ...
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 ...
This is an amazing feature but you need at least two RAC nodes configured to use it, see below: Output of TimesTen 11.2 installation … Would you like to use TimesTen Replication with Oracle Clusterware? [ no ] yes Please provide the path to the Oracle Clusterware installation on this machine (s=skip)? [ ] /app/oracle/product/11.2.0/gridhome ...
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 ...
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 ...
Unlike Unix ports of Oracle Database, Oracle on windows is implemented as a single operating system process. From this way typically processes such process monitor (PMON) and log writer (LGWR) have been converted to threads, native windows threads running in a large Oracle process. The process address space on 32-Bit Windows is 4GB. However, Microsoft ...