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 ...
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 ...
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 ...
Remastering is the ability to move the ownership of a resource between instances of Real Application Clusters. Dynamic resource remastering is used to implement resource affinity for increased performance. Resource affinity optimizes the system in situations where update transactions are being executed on one instance. When activity shifts to another instance the resource affinity will ...