{"id":6583,"date":"2018-12-14T08:26:37","date_gmt":"2018-12-14T08:26:37","guid":{"rendered":"https:\/\/dbtut.com\/?p=6583"},"modified":"2018-12-14T08:26:37","modified_gmt":"2018-12-14T08:26:37","slug":"how-to-report-exadata-disk-topology","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/","title":{"rendered":"How To Report Exadata Disk Topology"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>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 <code>gv$<\/code> instead of <code>v$<\/code> used in script. When you query with <code>v$<\/code>, you can get information from all cells.<\/p>\n<p>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.<\/p>\n<p>It will be easier to save and run the following commands in a file such as exadatadisktopology.sql<\/p>\n<p>&nbsp;<\/p>\n<p><strong>exadatadisktopology.sql :<\/strong><\/p>\n<pre class=\"lang:default decode:true \">COL cellname HEAD CELLNAME FOR A20\r\nCOL celldisk_name HEAD CELLDISK FOR A30\r\nCOL physdisk_name HEAD PHYSDISK FOR A30\r\nCOL griddisk_name HEAD GRIDDISK FOR A30\r\nCOL asmdisk_name HEAD ASMDISK FOR A30\r\n\r\nBREAK ON asm_diskgroup SKIP 1 ON asm_disk\r\n\r\nPROMPT Showing Exadata disk topology from V$ASM_DISK and V$CELL_CONFIG....\r\nWITH\r\npd AS (\r\nSELECT \/*+ MATERIALIZE *\/\r\nc.cellname\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/name\/text()') AS VARCHAR2(100)) name\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/diskType\/text()') AS VARCHAR2(100)) diskType \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/luns\/text()') AS VARCHAR2(100)) luns \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/makeModel\/text()') AS VARCHAR2(100)) makeModel \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/physicalFirmware\/text()') AS VARCHAR2(100)) physicalFirmware \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/physicalInsertTime\/text()') AS VARCHAR2(100)) physicalInsertTime\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/physicalSerial\/text()') AS VARCHAR2(100)) physicalSerial \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/physicalSize\/text()') AS VARCHAR2(100)) physicalSize \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/slotNumber\/text()') AS VARCHAR2(100)) slotNumber \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/status\/text()') AS VARCHAR2(100)) status \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/id\/text()') AS VARCHAR2(100)) id \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/key_500\/text()') AS VARCHAR2(100)) key_500 \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/predfailStatus\/text()') AS VARCHAR2(100)) predfailStatus \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/poorPerfStatus\/text()') AS VARCHAR2(100)) poorPerfStatus \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/wtCachingStatus\/text()') AS VARCHAR2(100)) wtCachingStatus \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/peerFailStatus\/text()') AS VARCHAR2(100)) peerFailStatus \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/criticalStatus\/text()') AS VARCHAR2(100)) criticalStatus \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/errCmdTimeoutCount\/text()') AS VARCHAR2(100)) errCmdTimeoutCount\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/errHardReadCount\/text()') AS VARCHAR2(100)) errHardReadCount \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/errHardWriteCount\/text()') AS VARCHAR2(100)) errHardWriteCount \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/errMediaCount\/text()') AS VARCHAR2(100)) errMediaCount \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/errOtherCount\/text()') AS VARCHAR2(100)) errOtherCount \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/errSeekCount\/text()') AS VARCHAR2(100)) errSeekCount \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/physicaldisk\/sectorRemapCount\/text()') AS VARCHAR2(100)) sectorRemapCount \r\nFROM\r\nv$cell_config c\r\n, TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(c.confval), '\/cli-output\/physicaldisk'))) v\r\nWHERE \r\nc.conftype = 'PHYSICALDISKS'\r\n),\r\ncd AS (\r\nSELECT \/*+ MATERIALIZE *\/\r\nc.cellname \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/name\/text()') AS VARCHAR2(100)) name\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/comment \/text()') AS VARCHAR2(100)) disk_comment\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/creationTime \/text()') AS VARCHAR2(100)) creationTime\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/deviceName \/text()') AS VARCHAR2(100)) deviceName\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/devicePartition\/text()') AS VARCHAR2(100)) devicePartition\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/diskType \/text()') AS VARCHAR2(100)) diskType\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/errorCount \/text()') AS VARCHAR2(100)) errorCount\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/freeSpace \/text()') AS VARCHAR2(100)) freeSpace\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/id \/text()') AS VARCHAR2(100)) id\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/interleaving \/text()') AS VARCHAR2(100)) interleaving\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/lun \/text()') AS VARCHAR2(100)) lun\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/physicalDisk \/text()') AS VARCHAR2(100)) physicalDisk\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/size \/text()') AS VARCHAR2(100)) disk_size\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/celldisk\/status \/text()') AS VARCHAR2(100)) status\r\nFROM\r\nv$cell_config c\r\n, TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(c.confval), '\/cli-output\/celldisk'))) v\r\nWHERE \r\nc.conftype = 'CELLDISKS'\r\n),\r\ngd AS (\r\nSELECT \/*+ MATERIALIZE *\/\r\nc.cellname \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/name\/text()') AS VARCHAR2(100)) name\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/asmDiskgroupName\/text()') AS VARCHAR2(100)) asmDiskgroupName \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/asmDiskName \/text()') AS VARCHAR2(100)) asmDiskName\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/asmFailGroupName\/text()') AS VARCHAR2(100)) asmFailGroupName\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/availableTo \/text()') AS VARCHAR2(100)) availableTo\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/cachingPolicy \/text()') AS VARCHAR2(100)) cachingPolicy\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/cellDisk \/text()') AS VARCHAR2(100)) cellDisk\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/comment \/text()') AS VARCHAR2(100)) disk_comment\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/creationTime \/text()') AS VARCHAR2(100)) creationTime\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/diskType \/text()') AS VARCHAR2(100)) diskType\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/errorCount \/text()') AS VARCHAR2(100)) errorCount\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/id \/text()') AS VARCHAR2(100)) id\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/offset \/text()') AS VARCHAR2(100)) offset\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/size \/text()') AS VARCHAR2(100)) disk_size\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/griddisk\/status \/text()') AS VARCHAR2(100)) status\r\nFROM\r\nv$cell_config c\r\n, TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(c.confval), '\/cli-output\/griddisk'))) v\r\nWHERE \r\nc.conftype = 'GRIDDISKS'\r\n),\r\nlun AS (\r\nSELECT \/*+ MATERIALIZE *\/\r\nc.cellname \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/cellDisk \/text()') AS VARCHAR2(100)) cellDisk \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/deviceName \/text()') AS VARCHAR2(100)) deviceName \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/diskType \/text()') AS VARCHAR2(100)) diskType \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/id \/text()') AS VARCHAR2(100)) id \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/isSystemLun \/text()') AS VARCHAR2(100)) isSystemLun \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/lunAutoCreate \/text()') AS VARCHAR2(100)) lunAutoCreate \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/lunSize \/text()') AS VARCHAR2(100)) lunSize \r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/physicalDrives \/text()') AS VARCHAR2(100)) physicalDrives\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/raidLevel \/text()') AS VARCHAR2(100)) raidLevel\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/lunWriteCacheMode\/text()') AS VARCHAR2(100)) lunWriteCacheMode\r\n, CAST(EXTRACTVALUE(VALUE(v), '\/lun\/status \/text()') AS VARCHAR2(100)) status \r\nFROM\r\nv$cell_config c\r\n, TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(c.confval), '\/cli-output\/lun'))) v\r\nWHERE \r\nc.conftype = 'LUNS'\r\n)\r\n, ad AS (SELECT \/*+ MATERIALIZE *\/ * FROM v$asm_disk)\r\n, adg AS (SELECT \/*+ MATERIALIZE *\/ * FROM v$asm_diskgroup)\r\nSELECT \r\nadg.name asm_diskgroup\r\n, ad.name asm_disk\r\n, gd.name griddisk_name\r\n, cd.name celldisk_name\r\n, pd.cellname\r\n, SUBSTR(cd.devicepartition,1,20) cd_devicepart\r\n, pd.name physdisk_name\r\n, SUBSTR(pd.status,1,20) physdisk_status\r\n, lun.lunWriteCacheMode\r\n-- , SUBSTR(cd.devicename,1,20) cd_devicename\r\n-- , SUBSTR(lun.devicename,1,20) lun_devicename\r\n-- disktype\r\nFROM\r\ngd\r\n, cd\r\n, pd\r\n, lun\r\n, ad\r\n, adg\r\nWHERE\r\nad.group_number = adg.group_number (+)\r\nAND gd.asmdiskname = ad.name (+)\r\nAND cd.name = gd.cellDisk (+)\r\nAND pd.id = cd.physicalDisk (+)\r\nAND cd.name = lun.celldisk (+)\r\n--GROUP BY\r\n-- cellname\r\n-- , disktype\r\n-- , status\r\nORDER BY\r\n-- disktype\r\nasm_diskgroup\r\n, asm_disk\r\n, griddisk_name\r\n, celldisk_name\r\n, physdisk_name\r\n, cellname\r\n\/<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6583\" class=\"pvc_stats all  \" data-element-id=\"6583\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; 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 &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6583\" class=\"pvc_stats all  \" data-element-id=\"6583\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6583","post","type-post","status-publish","format-standard","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Report Exadata Disk Topology - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Report Exadata Disk Topology - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"&nbsp; 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 &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-14T08:26:37+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Report Exadata Disk Topology\",\"datePublished\":\"2018-12-14T08:26:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\"},\"wordCount\":109,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\",\"name\":\"How To Report Exadata Disk Topology - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-14T08:26:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Report Exadata Disk Topology\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"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.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Report Exadata Disk Topology - Database Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/","og_locale":"en_US","og_type":"article","og_title":"How To Report Exadata Disk Topology - Database Tutorials","og_description":"&nbsp; 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 &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-14T08:26:37+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Report Exadata Disk Topology","datePublished":"2018-12-14T08:26:37+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/"},"wordCount":109,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/","name":"How To Report Exadata Disk Topology - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-14T08:26:37+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/14\/how-to-report-exadata-disk-topology\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Report Exadata Disk Topology"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"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.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6583"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6583\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}