Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: How to speed up parsing?
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.comReceived on Thu Feb 01 1996 - 16:12:34 CST
![]() |
![]() |