When administrating a RAC system use the dictionary views of GV$ and not V$.
GV$ has additional columns inst_id .
For almost every V$ view described in this chapter, Oracle has a corresponding GV$ (global V$) view. In Real Application Clusters, querying a GV$ view retrieves the V$ view information from all qualified instances.
In addition to the V$ information, each GV$ view contains an extra column named INST_ID of datatype NUMBER. The INST_ID column displays the instance number from which the associated V$ view information was obtained. The INST_ID column can be used as a filter to retrieve V$ information from a subset of available instances
| GV$ | V$ |
| Across all the nodes: The beauty of system dictionary views of GV$ which reflect information across the various nodes of a RAC system | Only the current node The V$ views of the data dictionary, which relate to the current status of the single node you are connected to |
For example;
| select distinct(username) from v$session; |
It only reflects connections to the connected node and not the entire RAC.
Whereas;
| select distinct(username) from gv$session; |
It gives the view of all sessions within the RAC.
The GV$ dictionary views have the additional INST_ID column which give the node that the action is occurring in
No comments:
Post a Comment