Re: High Cpu Usage After 9i Migration

From: Access <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 23 Nov 2004 23:45:22 +0100
Message-ID: <41a3bd84$0$7821$ba620e4c@news.skynet.be>

"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

Did you compare all the initialization parameters (pfile/spfile) between the old and the new db ? Are the statistics of the new db gathered the same way ?

Matthias Received on Tue Nov 23 2004 - 16:45:22 CST