Re: IMPORT - CLOCK TIME

On Wed, 12 Aug 1998 06:37:11 -0400, D S Tharpe <i5t_at_ornl.gov> wrote:
>Does anyone know how to calculate the clock time that it will take
>to import tables that have been exported and dropped? I am wanting to
>compress extents on several of our production tables and need to know if
>I have enough weekend time to get this task accomplished.

I've seen it take 3 to 10 times export time. According to O support, it shouldn't take 10 times. There seem to be some critical tuning parameters that only affect certain sized imports on certain combinations of Oracle version and platform. I was unpleasantly surprised on 7.3.4, Solaris 2.6, after having tested smaller-scale. Similar complaints are posted periodically, but I haven't seen any resolutions. This is assuming that objects are properly sized and pre-extended, and the systems are otherwise well-tuned.

>
>Thanks,
>
>D. Tharpe

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Aug 13 1998 - 19:31:17 CDT