How to improve xmltype insert performance?
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>');