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 ...
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 ...
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 ...
Sometimes Oracle job background demon hangs or stops working. In this situation all the scheduled jobs will never run again until you kill the process or just bounce your database. Take a look to your trace files dir probably you’ll find traces confirming this issue. Before starts please check the init parameter job_queue_processes, should be ...
Worried about how to trace shared connections?, relax, Oracle provides the trcsess command-line utility that consolidates tracing information based on specific criteria, trcsess is useful for consolidating the tracing of a particular session for performance or debugging purposes. The syntax for the trcsess utility is: trcsess [output=output_file_name] [session=session_Id] [clientid=client_Id] [service=service_name] [action=action_name] [module=module_name] [trace_files] where: output ...
To understand re-mastering please read in my blog the previous post explaining differences between versions. 1. Log in as SYSDBA and find the segment object number SELECT data_object_id FROM dba_objects WHERE owner = ‘JVALERIO’AND object_name = ‘TESTDRM1′; data_object_id ————— 23098 data_object_id: Object number of the segment which contains the object. If you want to remaster at ...