Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Huge IOTs, issues?

Huge IOTs, issues?

From: Bill Coulam <bcoulam_at_gmail.com>
Date: Wed, 24 Aug 2005 18:16:21 -0500
Message-ID: <f51d330205082416166eeef31d@mail.gmail.com>


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_at_gmail.com
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 24 2005 - 18:18:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US