Re: Parallel Index Building.
From: Tony Jambu <aaj_at_phantom.telecom.com.au>
Date: 1995/06/16
Message-ID: <3rrmtq$4v_at_newsserver.trl.OZ.AU>#1/1
Date: 1995/06/16
Message-ID: <3rrmtq$4v_at_newsserver.trl.OZ.AU>#1/1
In article <3qnvkl$bfc_at_mhaal.inhouse.compuserve.com>,
Arthur_Chung.RICS_at_notes.compuserve.com (Arthur Chung) writes:
> Does anyone have experience with Parallel Index Building for Oracle
> 7.1.x?
>
> I tried out Parallel Load without building index ( it works unbelivably
> fast! - what used to take 6~7 hours takes 10 minutes --- loading 3.5
> million records on SunSparc 10 ).
>
Can you please share your experience with the above observation.
How many CPUs were there?
How many spindle were there?
Are you using Disk arrays?
Etc.
ta
tony
-- _____ ________ / ___ |Tony Jambu, Database Consultant /_ _ /_ __ / |Wizard Consulting,Aust (ACN 065934778) /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559 \_______/ |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905Received on Fri Jun 16 1995 - 00:00:00 CEST