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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: How to speed up parsing?

Re: Re[2]: How to speed up parsing?

From: Jeffrey Weiss <jrweiss_at_SESCVA.ESC.EDU>
Date: Thu, 1 Feb 1996 16:00:09 -0500
Message-Id: <9602012112.AA00646@alice.jcc.com>


Just double-checked, and all tables are in 1 or 2 extents at most.

Jeff

--------------------<included message>--------------------

Subj: Re[2]: How to speed up parsing?

     One more question for you:
        On a table by table, index by index basis, do the number of extents
     used match? (Hopefully at a number close to 1).
        It's easy to get different initial/next extents if your exports
     were made a different dates. This assumes you used compress=y in the
     export. Having many extents, as you probably know, can ruin
     performance.

     David White
     dwhite_at_mccus.jnj.com

Received on Thu Feb 01 1996 - 16:12:34 CST

Original text of this message

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