How To Report Exadata Disk Topology

 

Simply run the following script from any database server to query the physical disk, celldisk, griddisk, and flash disks on the cell nodes in Exadata. There is no need to use gv$ instead of v$ used in script. When you query with v$, you can get information from all cells.

Collecting information from individual cellnodes with cellcli and matching them with the information of asm disk groups often turns into grind. You can easily access this information with the following script.

It will be easier to save and run the following commands in a file such as exadatadisktopology.sql

 

exadatadisktopology.sql :

dbtut
Author: 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 *