Re: CPU is 0% idle- Performance issue in 10g database
Date: Mon, 28 Apr 2008 07:19:34 +0530
The issue is resolved now and the cause for this is the internal schemas were anayzed during the upgrade process and unfortunately there was a scheduled job to analyse the whole DB which cause corruption in some internal schema statistics. Now the problem is fixed by scheduling the job to gather only user schemas.
On 4/19/08, ~Jeff~ <jifjif_at_gmail.com> wrote:
> either of the top 2 posts here might have something to do with it:
> - Jeff Wong
> EDS NZ.