Hi Readers Finally I’ve successfully passed 1Z0-338, Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 71 questions related to Exadata and Cloud Services. To earn this certification you need to get 63% marks. This was the result of the […]
Articles Tagged: Exadata
Top Sql in Exadata
SELECT * FROM ( SELECT sql_id, executions, physical_read_bytes FROM v$sqlstats WHERE io_cell_offload_eligible_bytes = 0 ORDER BY physical_read_bytes DESC ) WHERE ROWNUM <= 10 /
Show Exadata cell versions
SELECT cellname cv_cellname , CAST(extract(xmltype(confval), ‘/cli-output/interdatabaseplan/objective/text()’) AS VARCHAR2(20)) objective , CAST(extract(xmltype(confval), ‘/cli-output/interdatabaseplan/status/text()’) AS VARCHAR2(15)) status , CAST(extract(xmltype(confval), ‘/cli-output/interdatabaseplan/name/text()’) AS VARCHAR2(30)) interdb_plan , CAST(extract(xmltype(confval), ‘/cli-output/interdatabaseplan/catPlan/text()’) AS VARCHAR2(30)) cat_plan , CAST(extract(xmltype(confval), ‘/cli-output/interdatabaseplan/dbPlan/text()’) AS VARCHAR2(30)) db_plan FROM v$cell_config WHERE conftype = ‘IORM’ ORDER BY cv_cellname /