Re: High Cpu Usage After 9i Migration

From: Chris <_no_spam__at_telstra.com>
Date: Tue, 23 Nov 2004 21:31:54 GMT
Message-ID: <e%Nod.46028$K7.3001@news-server.bigpond.net.au>

"Yegna Balasubramanian" <ybalasub_at_gmail.com> wrote in message news:21a9c364.0411231223.72e1e981_at_posting.google.com...
> All,
>
> I have upgraded our production Oracle databse from 8.1.7.4 to
> 9.2.0.5 recentrly, the CPU usage is 35% normally when we run the DB in
> 8174 but after the migration CPU usage is 70%, sqls are doing lots of
> buffer gets now than it used to before, we are working on tuning those
> queries,have anybody experienced this before? inputs are welcome? My
> DB is running on HP-UX 11.11 with 8CPUs and 16G memory.
>
> Regards
> Yegna

Yegna,

I think for anyone to offer any assistance you'll need to supply execution plans for the 8.1.7 and 9i databases. That way you can tell what has changed. Received on Tue Nov 23 2004 - 15:31:54 CST