Skip to content

Instantly share code, notes, and snippets.

@nithril
Created October 10, 2011 20:31
Show Gist options
  • Save nithril/1276426 to your computer and use it in GitHub Desktop.
Save nithril/1276426 to your computer and use it in GitHub Desktop.
Plan with element value
<plan>
<operation name="SELECT STATEMENT" id="0" depth="0" pos="18911">
<card>9597</card>
<bytes>220731</bytes>
<cost>18911</cost>
<io_cost>18901</io_cost>
<cpu_cost>141769650</cpu_cost>
<time>00:03:47 </time>
</operation>
<operation name="FILTER" id="1" depth="1" pos="1">
<project>"ID"[NUMBER,22]</project>
<predicates type="filter"> (SELECT "SYS_ALIAS_0"."value617_E" FROM "BENCHSCHEMA"."SYS_NTrN1Mtqp9S/KH8wNP8qHKww==" "SYS_ALIAS_0" WHERE "NESTED_TABLE_ID"=:B1 AND "SYS_ALIAS_0"."value617_E" IS NOT NULL AND "SYS_ALIAS_0"."key"='MI')='MI_1'</predicates>
<qblock>SEL$1</qblock>
<other_xml>
<info type="db_version">11.2.0.1</info>
<info type="parse_schema"><![CDATA["BENCHSCHEMA"]]></info>
<info type="dynamic_sampling">2</info>
<info type="plan_hash">798985136</info>
<info type="plan_hash_2">2075224116</info>
<outline_data>
<hint><![CDATA[INDEX_RS_ASC(@"SEL$764ACA14" "SYS_ALIAS_0"@"SEL$8FB5BDD3" ("SYS_NTrN1Mtqp9S/KH8wNP8qHKww=="."NESTED_TABLE_ID" "SYS_NTrN1Mtqp9S/KH8wNP8qHKww=="."SYS_NC_ARRAY_INDEX$"))]]></hint>
<hint><![CDATA[FULL(@"SEL$1" "XMLTYPE_WITHOUT_SCHEMA_BENCH"@"SEL$1")]]></hint>
<hint><![CDATA[OUTLINE(@"SEL$3C9BE6F6")]]></hint>
<hint><![CDATA[OUTLINE(@"SEL$E112F6F0")]]></hint>
<hint><![CDATA[OUTLINE(@"SEL$DE1FBEA1")]]></hint>
<hint><![CDATA[OUTLINE(@"SEL$8FB5BDD3")]]></hint>
<hint><![CDATA[MERGE(@"SEL$E112F6F0")]]></hint>
<hint><![CDATA[OUTLINE(@"SEL$27375A25")]]></hint>
<hint><![CDATA[OUTLINE_LEAF(@"SEL$1")]]></hint>
<hint><![CDATA[MERGE(@"SEL$8FB5BDD3")]]></hint>
<hint><![CDATA[OUTLINE_LEAF(@"SEL$764ACA14")]]></hint>
<hint><![CDATA[NO_COST_XML_QUERY_REWRITE]]></hint>
<hint><![CDATA[XMLINDEX_REWRITE_IN_SELECT]]></hint>
<hint><![CDATA[XMLINDEX_REWRITE]]></hint>
<hint><![CDATA[XML_DML_RWT_STMT]]></hint>
<hint><![CDATA[FORCE_XML_QUERY_REWRITE]]></hint>
<hint><![CDATA[ALL_ROWS]]></hint>
<hint><![CDATA[DB_VERSION('11.2.0.1')]]></hint>
<hint><![CDATA[OPTIMIZER_FEATURES_ENABLE('11.2.0.1')]]></hint>
<hint><![CDATA[IGNORE_OPTIM_EMBEDDED_HINTS]]></hint>
</outline_data>
</other_xml>
</operation>
<operation name="TABLE ACCESS" options="FULL" id="2" depth="2" pos="1">
<object>XMLTYPE_WITHOUT_SCHEMA_BENCH</object>
<card>9597</card>
<bytes>220731</bytes>
<cost>68</cost>
<io_cost>68</io_cost>
<cpu_cost>4808958</cpu_cost>
<time>00:00:01 </time>
<project>"ID"[NUMBER,22], "XMLTYPE_WITHOUT_SCHEMA_BENCH"."SYS_NC0000800009$"[RAW,16]</project>
<qblock>SEL$1</qblock>
<object_alias>XMLTYPE_WITHOUT_SCHEMA_BENCH@SEL$1</object_alias>
</operation>
<operation name="TABLE ACCESS" options="BY INDEX ROWID" id="3" depth="2" pos="2">
<object>SYS_NTrN1Mtqp9S/KH8wNP8qHKww==</object>
<card>86</card>
<bytes>224804</bytes>
<cost>3</cost>
<io_cost>3</io_cost>
<cpu_cost>21817</cpu_cost>
<time>00:00:01 </time>
<project>"SYS_ALIAS_0".ROWID[ROWID,10], "SYS_ALIAS_0"."key"[VARCHAR2,4000], "SYS_ALIAS_0"."value617_E"[VARCHAR2,1200]</project>
<predicates type="filter">"SYS_ALIAS_0"."value617_E" IS NOT NULL AND "SYS_ALIAS_0"."key"='MI'</predicates>
<qblock>SEL$764ACA14</qblock>
<object_alias>SYS_ALIAS_0@SEL$8FB5BDD3</object_alias>
</operation>
<operation name="INDEX" options="RANGE SCAN" id="4" depth="3" pos="1">
<object>SYS_C0010907</object>
<card>485</card>
<cost>2</cost>
<io_cost>2</io_cost>
<cpu_cost>14443</cpu_cost>
<time>00:00:01 </time>
<project>"SYS_ALIAS_0".ROWID[ROWID,10]</project>
<predicates type="access">"NESTED_TABLE_ID"=:B1</predicates>
<qblock>SEL$764ACA14</qblock>
<object_alias>SYS_ALIAS_0@SEL$8FB5BDD3</object_alias>
</operation>
</plan>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment