OraFAQ Forum: SQL & PL/SQL » Huge XML data in BLOB columns

Home » SQL & PL/SQL » SQL & PL/SQL » Huge XML data in BLOB columns (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Huge XML data in BLOB columns [message #674972]

Tue, 26 February 2019 11:37

Danny Freeman
Messages: 21
Registered: December 2015
Location: UK

Junior Member

Hi. Just a curious question. Need a little guidance or suggestions. Suppose there is a huge XML data in BLOB columns. Now, to run an insert from these XML blobs they just put it in jobs. Now my question is, I'm trying to apply primary and secondary indexes on this field and it's taking 3+ hrs. Any suggestions?

Report message to a moderator

Re: Huge XML data in BLOB columns [message #674973 is a reply to message #674972]

Tue, 26 February 2019 11:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Danny Freeman wrote on Tue, 26 February 2019 09:37

Hi. Just a curious question. Need a little guidance or suggestions. Suppose there is a huge XML data in BLOB columns. Now, to run an insert from these XML blobs they just put it in jobs. Now my question is, I'm trying to apply primary and secondary indexes on this field and it's taking 3+ hrs. Any suggestions?

IMO, XML should be stored as XMLtype or CLOB; not BLOB.

ALWAYS post Oracle version to 4 decimal places.

We don't know what you have.
We don't know what you do.

we need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

Report message to a moderator

Re: Huge XML data in BLOB columns [message #674974 is a reply to message #674972]

Tue, 26 February 2019 13:44

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you mean b"primary and secondary indexes"?
As BlackSwan says, post all what can lead to understand what you do and enable us to do the same thing.

Report message to a moderator

Previous Topic:	INSERT and SELECT statements
Next Topic:	How to denormalize multiple records into 1 row-

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 18 16:25:11 CDT 2025