Re: Datawarehouse Load Performance?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 07 Feb 2000 19:17:19 +0800
Message-ID: <389EA9BF.7F6B@yahoo.com>

Stephen Darlington wrote:
>
> I'm just starting to design a datawarehouse load and was beginning to get a
> little worried about the performance.
>
> What are other people's experience loading a datawarehouse? We're using 8i
> on a 4 processor (Xeon, 550Mhz) NT box and are looking to process around 1.2
> million rows. Some very rough metrics indicated that this could take a week
> to load!
>
> I appreciate that there are too many variables here to get a very precice
> answer, but I'd like to hear any experiences you have.
>
> Cheers,
> --> Stephen
> ---------------------------------------------------------------
> Stephen Darlington (http://www.zx81.org.uk)
> "Never put a sock in a toaster"
> ---------------------------------------------------------------

1.2 million rows can be loaded in minutes (not hours, days or weeks).

Some things to look at:

• direct load SQL Loader
• direct load insert (insert /*+ APPEND */)
• nologging on tables
• building indexes after loading (dropping before)
• parallel load

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Feb 07 2000 - 05:17:19 CST