Plan

gistfile1.xml

<plan>
    <operation name="SELECT STATEMENT" id="0" depth="0" pos="1843">
        <card>9287</card>
        <bytes>35076999</bytes>
        <cost>1843</cost>
        <io_cost>1809</io_cost>
        <cpu_cost>482733685</cpu_cost>
        <time>00:00:23 </time>
    </operation>
    <operation name="FILTER" id="1" depth="1" pos="1">
        <project>"ID"[NUMBER,22]</project>
        <predicates type="filter">EXTRACTVALUE( (SELECT "SYS"."SYS_IXMLAGG"(SYS_MAKEXML('E566682945A140748850AEB0B3F22151',4117,:B1,"SYS_ALIAS_0"."SYS_NC_ROWINFO$")) FROM "BENCHSCHEMA"."SYS_NTa73XZoraSY2eC/T7shEfjw==" "SYS_ALIAS_0" WHERE "NESTED_TABLE_ID"=:B2),'/property[attribute::key = "MI"]/text()',NULL)='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">1181179280</info>
            <info type="plan_hash_2">1290844528</info>
            <outline_data>
                <hint><![CDATA[INDEX_RS_ASC(@"SEL$C6E346FE" "SYS_ALIAS_0"@"SEL$427A7C8C" ("SYS_NTa73XZoraSY2eC/T7shEfjw=="."NESTED_TABLE_ID" "SYS_NTa73XZoraSY2eC/T7shEfjw=="."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$427A7C8C")]]></hint>
                <hint><![CDATA[MERGE(@"SEL$E112F6F0")]]></hint>
                <hint><![CDATA[OUTLINE(@"SEL$27375A25")]]></hint>
                <hint><![CDATA[OUTLINE_LEAF(@"SEL$1")]]></hint>
                <hint><![CDATA[MERGE(@"SEL$427A7C8C")]]></hint>
                <hint><![CDATA[OUTLINE_LEAF(@"SEL$C6E346FE")]]></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>9287</card>
        <bytes>35076999</bytes>
        <cost>101</cost>
        <io_cost>68</io_cost>
        <cpu_cost>469084369</cpu_cost>
        <time>00:00:02 </time>
        <project>"ID"[NUMBER,22], SYS_OP_NOEXPAND("XMLTYPE_WITHOUT_SCHEMA_BENCH"."SYS_NC00003$")[ABSTRACT,24], "XMLTYPE_WITHOUT_SCHEMA_BENCH"."SYS_NC00004$"[ABSTRACT,4360], "XMLTYPE_WITHOUT_SCHEMA_BENCH"."SYS_NC00005$"[ABSTRACT,4360], "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="SORT" options="AGGREGATE" id="3" depth="2" pos="2">
        <card>1</card>
        <bytes>5892</bytes>
        <project>(#keys=0) "SYS"."SYS_IXMLAGG"(SYS_MAKEXML('E566682945A140748850AEB0B3F22151',4117,:B1,"SYS_ALIAS_0"."SYS_NC_ROWINFO$"))[64]</project>
        <qblock>SEL$C6E346FE</qblock>
    </operation>
    <operation name="TABLE ACCESS" options="BY INDEX ROWID" id="4" depth="3" pos="1">
        <object>SYS_NTa73XZoraSY2eC/T7shEfjw==</object>
        <card>1314</card>
        <bytes>7742088</bytes>
        <cost>6</cost>
        <io_cost>6</io_cost>
        <cpu_cost>47029</cpu_cost>
        <time>00:00:01 </time>
        <project>"SYS_ALIAS_0"."SYS_XDBPD$"[ABSTRACT,4360], "SYS_ALIAS_0"."key"[VARCHAR2,4000], "SYS_ALIAS_0"."value"[VARCHAR2,4000]</project>
        <qblock>SEL$C6E346FE</qblock>
        <object_alias>SYS_ALIAS_0@SEL$427A7C8C</object_alias>
    </operation>
    <operation name="INDEX" options="RANGE SCAN" id="5" depth="4" pos="1">
        <object>SYS_C0010880</object>
        <card>526</card>
        <cost>2</cost>
        <io_cost>2</io_cost>
        <cpu_cost>16243</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$C6E346FE</qblock>
        <object_alias>SYS_ALIAS_0@SEL$427A7C8C</object_alias>
    </operation>
</plan>