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 ...
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 . ...
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 ...
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 ...
What about Solaris 10 projects? Projects are collections of tasks, which are collections of processes. A new task is started in a project when a new session is opened by a login, cron, newtask, setproject or su command. Each process belongs to only one task, and each task belongs to only one project. Projects are ...
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 ...
Basically the Single Client Access Name (SCAN) is used by clients to connect to any database in the cluster. Having a single name to access the cluster allows clients to use the EZConnect client and the simple JDBC thin URL to access any database running in the clusters independently of which server(s) in the cluster ...
This is a guide to be used as reference, does not replace the original documentation, it’s an Step by Step assuming you’re ready to add a new node or replace one. I know there are other ways to make this, just to be considered. Basic Concepts Source: Cluster node source. Destination: Cluster node to be ...
Parallel in standalone Databases The parallel options invoke multiple processes to utilize spare system resources to reduce the time required to complete tasks or jobs. The parallel options do not reduce the amount of resources required by the processing; rather, they spread the processing burden across multiple CPUs. In order to get the most benefit ...