Re: design question, use of partitioned tables?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sat, 9 Aug 2003 17:11:29 +0300
Message-ID: <3f350131_1@news.estpak.ee>

Hi!

> I don't think it's just that. In my system, the deltas for these two
> consistently largely exceed the deltas for the direct read (lob) and
> direct write (lob) counters. During the load, of course.
> It's not even a small number: we're talking a LOT more.

I agree. Actually I wanted to make a point, that controlfiles get regularly updated even on idle system, thus the statistics constantly increase.

> Controlfile I/O is definitely a bottleneck if NOLOGGING and loading lobs.
> With LOGGING, I get "normal" numbers on these counters and much better
> performance. Probably because my redo logs are as fast as they can get
> in this system and they are the bottleneck with LOGGING.

Great. It seems sensible that for loading large number of small LOBs, CACHE+LOGGING is better performance wise, but for very large LOBs, NOCACHE NOLOGGING works better.

Tanel. Received on Sat Aug 09 2003 - 09:11:29 CDT