DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle 9i XML Type

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Question

    Hi! All,

    HAs anyone used the XML Type Datatype of Oracle 9i for production or Development environment? If Yes, then what is the performance of the system? Any limitations which are not document?
    Any experience sharing will be highly appriciated.

    Thanks in Advance
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    I've only used it as a test:

    http://www.oracle-base.com/Articles/...peDatatype.asp
    http://www.oracle-base.com/Articles/...neration9i.asp

    It seems OK but I'm not really sure what circumstances I would use it in. In previously projects it has always been necessary to explode the XML into relational tables. I can't see that requirement changing in those projects for some time. I couldn't give you an indication of performance as I've not done anything big with it yet.

    Oracle9i Release2 (available in March) will include XDB which makes takes XML integration to the next level. It is meant to make the storage, extraction and use of XML almost seamless. Don't know what this means in reality

    If you do some bigger tests let me know.

    [Edited by TimHall on 02-01-2002 at 07:10 AM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Hi! Tim,
    First of all I would like to congratulate you on creating such a informative site. Socondly Thanx again for the valueable information.
    In my current project I need to store large amount information as XMLTYPE and then create view on them so that BusinesS Object can generate report out of it.
    I wil surely keep you updated on the proceeding
    There Nothing You cannot Do, The problem is HOW.

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I'd additionally be interested in the XMLdatatype performance with large amounts of data. We will be upgrading a system later this year from 8.1.7 to 9i to utilise the XML functionality. I've seen the query run etc, but only on small volumes of data. We originially created intermedia indexes based on a CLOB filed under 8.1.7. A couple of problems, a), You cannot perform > < = or caluculation on numeric tags, date tags and you CAN'T sort the data. Which made it all pretty pointless.
    So we had to revert to standard oracle referential tables.

    In 9i using the xml databtype you can now do this. But to what extent (i.e. volume) I don't know. We'd be utilising 9i on tables inserting 5 Million reocrds daily. I'm interested to see a). How the xmldatatype indexes are handled and b). query performs on large amounts of data.

    Let me know how you go.

    Email: Johnsog123@hotmail.com

    Cheers,

    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width