Re: Log file sync and log file parallel write.

On Wed, Mar 5, 2008 at 8:37 PM, Johnson, William L (TEIS) < WLJohnson_at_tycoelectronics.com> wrote:

> Can someone help point me to documentation that will show me the silver
> bullet for not rebuilding indexes? I can provide countless examples over
> the past several years where rebuilding indexes corrected performance
> problems that developed over months. Are we saying that something else
> fixed the problem and that the index rebuild was not the real solution? Is
> the index rebuild forcing explain plans out of the shared_pool and giving
> false results? If so, wouldn't a DB stop/start accomplish the same result?
> I am by no means an optimizing expert, but won't Oracle switch to something
> like full table scans if the index is no longer an effective method to
> obtain your data? This quickly becomes a problem when joining multiple
> tables with 10+ million rows each. I deal a lot with third party
> applications like SAP, Click Commerce and Matrix One Engineering modules
> where we can not alter the sql running behind the scenes.
>
>
>
> I would really like to understand.
>
>
>
> Bill
>

Bill,

It depends.
Did the clustering factor change? ;P

ducking, running and signing off for the night...

Pd

>
> ------------------------------
>
> *From:* Jared Still [mailto:jkstill_at_gmail.com]
> *Sent:* Wednesday, March 05, 2008 7:39 PM
> *To:* asif_oracle_at_yahoo.com
> *Cc:* Johnson, William L (TEIS); oracle-l_at_freelists.org
> *Subject:* Re: Log file sync and log file parallel write.
>
>
>
>
> Lastly, why are you rebuilding your indexes???
> Regards
> Asif Momen
> http://momendba.blogspot.com
>
>
>
>
>
> Same question. Why are you rebuilding the indexes?
>
> You *could* just stop doing that.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
-----------------------------------------------------------------
USADA and WADA are broken and not worth fixing. Boycott professional sports.
Avoid patronizing their advertisers. Don't buy tickets to NBA, NFL, MLBB,
NHL and especially Pro Cycling.

--
http://www.freelists.org/webpage/oracle-l