Friday , March 29 2024

Querying information about Exadata cellnode

We can query all the information about the cellnodes on Exadata from any database.

It is possible to query information from v$cell_config. With this view, all information about the following can be queried.

  • IORM (I/O Source Management)
  • CELLDISKS (Cell Disk Informations)
  • GRIDDISKS (Grid Disk Informations)
  • CELL (Information about Cell)
  • LUNS (Lun Informations)
  • PHYSICALDISKS  (Physical Disk Informations)

In this view, it is possible to access the requested information by parsing the xml data in the clob area named CONFVAL. Cell, ASM information can be queried globally from all db nodes. So you don’t need to query with gv $. v$ will also query globally.

A sample query is specified below.

You can use the following query to access cellnode physical disk information:

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories