How to improve the insert performance for a table with xmltype column
Hi All,
I currently run a database(10.2.0.4) RAC in CentOS(4 Nodes), Shared Storage EMC-CX80, and I want to use the XMLType table in the db, but caught
serious performance issue of insert, the insert to the table with xmltype cost about 10 times of time in the database compare to with CLOB or VARCHAR.
The table I had partitioned with 20 partitions, and create scripts like this:
create table table_x(v_id number, v_time date, v_content xmltype)
partition by range (v_id) as
(partition v_1 where v_id less than ...
...);
then
insert into table_x values(1,to_date(...),'<test> .....this is my contents </test>');
....
I checked from 10046 event, the each sql insert cost about 1/3 more time than the similar table with CLOB, from the set timing on, it cost about 10 times of time than it with CLOB or VARCHAR, how can I improve the performance of the insert with XMLtype?
The XMLtype also store with CLOB, but not sure why so slow..
Thanks & Regards,
-User