Re: CPU waiting for... what? (mistery)

[Fup2 comp.databases.oracle.server]

On 2003-04-11 20:32, Rick Denoire <100.17706_at_germanynet.de> wrote:
> The table itself is 3,5 GB in size with 97 Mio rows. The index was 2.8
> GB. I used the "time" command:
> real: 4h54m
> user: 8h13m
> sys: 35m

You are using almost twice as much CPU user time as real time, which means that you are on average using 2 CPUs at full speed. That doesn't look like an I/O bottleneck to me, more like a CPU bottleneck. I know you have 4 CPUs, but I don't know how well rebuilding a single index can be parallelized.

        hp

-- 
   _  | Peter J. Holzer    | Latein ist das humanoide Äquivalent
|_|_) | Sysadmin WSR       | zu Fortran.
| |   | hjp_at_hjp.at         |
__/   | http://www.hjp.at/ |    -- Alexander Bartolich in at.linux