Re: CPU is 0% idle- Performance issue in 10g database

From: Shastry(DBA) <shastry17_at_gmail.com>
Date: Mon, 28 Apr 2008 07:19:34 +0530
Message-ID: <5b294dab0804271849t2aa7a465x3f75e0a92b4e2169@mail.gmail.com>

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.

Reg,
Ann

On 4/19/08, ~Jeff~ <jifjif_at_gmail.com> wrote:
>
> either of the top 2 posts here might have something to do with it:
> http://blogs.sun.com/glennf/
>
> - Jeff Wong
> EDS NZ.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 27 2008 - 20:49:34 CDT

This message: [ Message body ]
Next message: Srinivas Chintamani: "Re: Is it possible to add existing datafiles to an oracle database?"
Previous message: David Aldridge: "Re: New form of sql injection hack documented"
In reply to: ~Jeff~: "Re: CPU is 0% idle- Performance issue in 10g database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message