Overview of the User Global Area

The UGA is session memory, which is memory allocated for session variables, such as logon information, and other information required by a database session. Essentially, the UGA stores the session state. If a session loads a PL/SQL package into memory, then the UGA contains the package state, which is the set of values stored in … Read more

Global Name Services in RAC

It is small xml file located in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global personality of a node. Each node maintains a local copy of the GPnP Profile and is maintanied by the GPnP Deamon (GPnPD) . So from the above dump we can see that GPnP profile contains … Read more

Categories RAC