Articles Tagged: Exadata cell

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 /

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 /