RAC architecture concepts

Oracle Real Application clusters (RAC) allows multiple instances to access a single Oracle database. These instances often run on multiple nodes. The Component Diagram with explanation shows all the components that inter-relate to each other and together make up THE “Oracle RAC architecture“.   RAC is the principal component for the Oracle Grid Architecture. It’s […]

View Oracle hidden parameters

Hidden parameters in Oracle always start with an underscore. It is not possible for the DBA to see the hidden parameters with the SQL*Plus command “show parameter” or by querying v$parameter. Unless the hidden parameter is explicitly set in spfile/init.ora file. How Can I list all Hidden Parameters set in The database? As they are […]