Re: Oracle 10g stops responding for a while

Piotr Kujawka wrote:
> Hello,
>
> I have Oracle 10g (10.1.0.3.0) running on RHE box. When I perform a
> pretty simple select, even like select * from dual, I see that Oracle
> stops for 2-3 s. and not responding, then it's OK. This happens every
> 4-5 correct selects.
>
> Any idea what is going on ?
>
> Regards,
>
> --
> Piotr Kujawka

No. You need to use normal diagnostic tools to check the CPU load. Also you need to check (assuming you can still get in) what Oracle is waiting for.

You might have just insufficient memory, and the box is swapping and paging like hell when this happens. Which you could easily check with vmstat and similar programs.
Does your box satisfies Oracle's mimimum requirements?

-- 
Sybrand Bakker
Senior Oracle DBA