Using the V$CELL and GV$CELL Views to Display Oracle Exadata Storage Server Identification

C.1.1 Using the V$CELL and GV$CELL Views to Display Oracle Exadata Storage Server Identification

The V$CELL view provides identifying information about cells.

Table C-1 V$CELL View Columns and Descriptions

Column Description

Column	Description
`CELL_HASHVAL`	A numeric hash value for the cell. For example: 138889696 Note: The cell hash value is often contained in the `P1` argument for cell-related wait events in the `V$SESSION_WAIT` and `V$ACTIVE_SESSION_HISTORY` views. You can join to this column to identify the corresponding cell.
`CELL_PATH`	A character string (maximum 400) that specifies the IP addresses of the cell. These are the IP addresses specified in the `cellip.ora` file.
`CELL_TYPE`	The type of storage cell. Either `EXADATA` or `BDSQL`.

CELL_HASHVAL

A numeric hash value for the cell. For example:

138889696

Note: The cell hash value is often contained in the P1 argument for cell-related wait events in the V$SESSION_WAIT and V$ACTIVE_SESSION_HISTORY views. You can join to this column to identify the corresponding cell.

CELL_PATH

A character string (maximum 400) that specifies the IP addresses of the cell. These are the IP addresses specified in the cellip.ora file.

CELL_TYPE

The type of storage cell. Either EXADATA or BDSQL.

The GV$CELL view contains the same columns as the V$CELL view, and includes the INST_ID column. The INST_ID column displays the instance number from which the associated V$ view information was obtained. Querying a GV$ view retrieves the V$ view information from all qualified instances.

Parent topic: Oracle Database Dictionary Views