Below is a snippett of what my test xml looks like: A single xml can contain up to about 15 different schemas. SQL> select xmltype.getclobval(x) from test Ħ49 bytes received via SQL*Net from clientġ rows processedAlthough this test xml I am using doesn't have a schema, the actual xml I have does. | 1 | TABLE ACCESS FULL| TEST | 1 | 87 | 3 (0)| 00:00:01 |ħ1659353 bytes sent via SQL*Net to clientġ4365304 bytes received via SQL*Net from client | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | SQL> select dbms_lob.getlength(xmltype.getclobval(x)) from test ĭBMS_LOB.GETLENGTH(XMLTYPE.GETCLOBVAL(X)) The test xml contains about 50,000 object entry that is contained in a single xml. I am unable to post my actual xml, but I created a test case by making an xml document out of dba_objects.
Something I noticed is that when I select the entire xml from the table, there are alot of logical reads, but when I pull the xmltype.getclobval of the same xml it is instant with hardly any logical reads. The average size of my xml's is about 12K, which the extractvalue works pretty quickly against, but I have some larger xml's around 10MB that takes forever. I am noticing that for many of my xml's that extractvalue is taking a long time to complete. I have a table built that contains and xmltype column.
0 kommentar(er)
