XML Database (MOSC)

MOSC Banner

How to improve xmltype insert performance?

edited Dec 20, 2010 2:27AM in XML Database (MOSC) 1 commentAnswered
   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>');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center