Re: Oracle 9i performance problems on Tru64

Yes, we did. No effect. We also installed patch kit four on the operating system. We tried turning off asynchronous IO. Setting the swap mode to lazy to increase free memory. We're in real trouble here, so any ideas would be greatly appreciated.

Thanks,

Warren

Anton Dischner <nospam_at_nospam.org> wrote in message news:<010720041721429580%nospam_at_nospam.org>...
> Hi Warren,
>
> did you try different sizes of SGA?
>
> greetings
>
> Toni
>
> In article <ff5a9593.0407010635.6664cc4c_at_posting.google.com>, warren
> weis <wgweis_at_omsoft.com> wrote:
>
> > Hi:
> > We recently installed Oracle 9.2.0.5.0 on a machine running UNIX
> > Tru64 version 5.1B. We are seeing very high CPU usage for almost
> > anything done on the 9i test databases we set up: Logging in causes
> > CPU usage to spike up to about 90%. Doing things like a simple select
> > (select * from all_tables) causes the CPU usage to go up to about 98%.
> >
> > We tried fiddling with the databases initialization parameters, but
> > nothing there seems to have effect.
> >
> > Anyone have any idea what's going on here? We still have the
> > previous version of Oracle on the machine (8.0.5) and we don't see
> > anything like the cpu usage for similar queries on similar sized
> > databases.
> >
> >
> > Thanks,
> >
> > Warren
Received on Thu Jul 22 2004 - 12:41:19 CDT