Skip to main content

Posts

Showing posts with the label Retrive Exadata Versoin and Configuration Information

Retrive Exadata Version and Configuration Information

Option 1: Use DBMS_LOB package to get cell configuration information, as column CONFVAL is CLOB spool confval.txt and search for text make in text file you will see get value in tag <makeModel>  </makeModel> set pagesize 0 SELECT dbms_lob . substr (CONFVAL,4000,1) from V$CELL_CONFIG; spool off This option is good if you don't  have privilege to access storage node and can't execute command Cellcli. You would be able to find out interleaving attribute about Celldisk also as follows. <interleaving>none</interleaving> Explore about interleaving attribute of Celldisk at https://uhesse.com/2011/05/18/exadata-part-vii-meaning-of-the-various-disk-layers/amp/ http://basededonnyes.blogspot.com/2012/01/creating-interleaved-grid-disks.html?m=1 Option 2: From Tanel Podder Blog. I have modified some format to display Make Model properly. COL cv_cellname       HEAD CELL_NAME        FOR A30 COL cv...