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 ...
Yes, I did! … but you’re are not allowed to use use asmcfs. Questions to info@jose-valerio.com.ar, subject: 11g R2-CentOS My cheap lab: RAC 11g R2 – Two nodes Storage: Openfiler (iscsi) – Standalone Server Hardware: Two PC Dual Core 2Ghz, 2 GB RAM, Ether Lan cards GB. Networking : Two Generic Switches 2 GB Database ...
This article provides details on how to create, drop and recreate the Database Control Repository and configuration files in a 11g R2 database. Dropping DB Console emca -deconfig dbcontrol db -repos drop [oracle@hydra admin]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Dec 13, 2009 9:36:36 PM EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright ...
Problem: After a successful 11g R2 grid install and trying y to use dbca you’re getting “CRS is null”. Solution: Just verify the environment, probably you make a mistake setting up the .env file. Verify ORACLE_HOME or ORA_CRS_HOME ...
From October eBS 11i was certified within 11g R2, but checking last information I found that may features still remains underway, I mean, database is certified by not all the features like Dadatabase Vault. In my opinion Oracle had to wait before officially say that database is certified. One more thing, migrate does not mean upgrade database only, ...
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 ...
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 ...
The most easy way to start using APEX it is just using the embedded PL/SQL gateway, it provides Oracle Database with Web Server and infrastructure to create dynamic and fast applications. The Embedded PL/SQL gateway runs in XML DB HTTP Server in Oracle Database and includes core features of the good and knew mod_plsql (apache ...