Huge IOTs, issues?

  • From: Bill Coulam <bcoulam@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 24 Aug 2005 18:16:21 -0500

Who among you have used Oracle's IOT for really large tables (250-500GB+)?

I use IOTs all the time for our small, reference tables, but this is a
first for me with a table approaching a terabtye at certain clients.

I had an issue with space management that a kind member of this list
helped me through (turned out to be an index leaf-splitting problem).

Other than that, have any of you encountered glaring bugs or subtle
problems with large IOTs?

We have a client that claims IOTs present problems in maintenance and
gathering statistics. Unfortunately, no further details were provided.
I just put that out in case it jogs your collective memory.

Thanks!
-- 
bill coulam
bcoulam@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l

Other related posts: