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

Home -> Community -> Usenet -> c.d.o.server -> Re: sql tuning

Re: sql tuning

From: Karen Abgarian <abvk_at_ureach.com>
Date: Fri, 27 Sep 2002 07:39:30 GMT
Message-ID: <3D940A9C.D0D55052@ureach.com>


>
> >
> > I sense a shovel load of 'horse manure' on it's way o:)
> >
>
> Nah, only when excrement of another kind is posted first. Which you never
> do.
> (Though references to a certain "pop singer" come close!!)
>
> ;-)

For the sake of completeness, here is this excrement:

> I do not think that it really suffers. The effects should decrease with the
number
> of extents in your rollback segment. If there is too many there is always a
question
> whether they were sized correctly. There should be no impact if the
tablespace
> hosting your rollback segments is an LMT.

Not to discourage others who dare to post to the forum when you are around ....

:-) Received on Fri Sep 27 2002 - 02:39:30 CDT

Original text of this message

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