Re: VARRAYS for VLDB

The only general point I would make is that varrays need to be unpacked to be used - so there is no high-precision access to them.

This may be memory and CPU intensive,
and is perhaps an area where the code
may not have been stressed by other
users very often - i.e. higher-risk because it is closer to the leading edge.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May x 2
____Estonia___June 4th - 6th
____Australia_June 18th - 20th (Perth)
____Australia_June 23rd - 25th (t.b.a)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Karsten Schmidt" <groups_at_karsten-schmidt.com> wrote in message
news:c6711ac4.0304280001.298803f6_at_posting.google.com...


> Thanks Jonathan ,

>  I am most likely going with Oracle 9.2.0.3.0 on HPUX 11.11, 64 bit.

>

>  a) sounds a little scary. I suppose, I really have to benchmark the

> two options.

>

>  b) should not be an issue for me, as you already figured, the

inserts


> are always going to the right-hand side of the primay key index.

>  Apart from that, there is still the option to re-build the

partition


> once no new data is coming in. (create ... as select, exchange

> partition...)

>  I am doing that successfully with other databases with partitioned

> IOT's.

>

>  Is there anything in particular that I should watch for when

testing


> the VARRAY option ? - i.e. is it bogus exexution plans for queries,

> excessive cpu usage, memory issues etc. ?

>  Most likely, the entire thing will be i/o bound, so at this point,

I


> am not too concerned to spend a few cpu cycles on object un-nesting.

>

> best regards

>  Karsten