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

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:ogpb9vkamsftl1apont1bq7j0ceb9l4s09_at_4ax.com...
> Today, I recreated an index of our Oracle DB (8.1.7):
> alter index <index_name> rebuild tablespace X storage (initial 32M
> next 32M) nologging;
>
> I have being struggling with slow performance on this server (Sun
> E3500/Solaris 2.7) for a long time now, so I thoroughly looked at
> this process, using a lot of tools: sar, iostat, Adrian Crockcoft's
> zoom tool, proctool, Oracle Performance Manager (Diagnostics Pack of
> the Oracle Enterprise Manager), and the built-in software
> ("Navisphere") of the Clariion Disk Array (EMC CX-400). Believe me, I
> spent hours investigating a lot of different metrics.
[SNIP]
>
> As I said, mistery.
>
> Bye
> Rick Denoire

Are any of your processes depending on external systems like a DB front/backend, management console or other external network references? If yes, then check if your DNS is functioning properly. I've seen many systems sitting idle waiting for DNS quiries to time-out, simply because the referenced systems were not properly resolved.

Do you use FC host adapters with IP-over-Fibre enabled? If you're not using it, disable it.

Rob Received on Fri Apr 11 2003 - 07:16:47 CDT