Re: Increased IO Overhead in 10g?

Robert Klemme wrote:
>
> Hi,
>
> I know this question is going to sound a bit fuzzy as I cannot disclose
> a lot of detail. However my intention is to get a rather general
> statement about your experience. My question is basically: is anybody
> here aware of higher overhead in Ora 10g disk IO vs., say 8.1.7? One
> thing that came to mind are all the management features; I know that
> they are using functionality that has been available for several
> versions but maybe more of these introspecting features are enabled by
> default.
>
> Thanks for any feedback!
>
> Kind regards
>
> robert

I/O patterns do change a bit. For one thing, in 10g you should be using Automated Undo instead of manually managed rollback segments. I can't remember if tempfiles were introduced in 8i or 9i, but in 10g, your TEMP tablespace should be using tempfiles. This has a different I/O requirement than using datafiles for TEMP. Most importantly, redo is not logged.

In a well-tuned system, you should not notice the I/O overhead of running Oracle 10g. But if you put all data on one disk spindle, the I/O impacts may be noticed. This can be true of previous Oracle versions too.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com