Re: AWR Sample Report

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 18 Nov 2008 13:36:31 -0800 (PST)
Message-ID: <f2582ffd-ac53-4b44-aae7-6321ada4458d@40g2000prx.googlegroups.com>


On Nov 18, 1:38 am, raja <dextersu..._at_gmail.com> wrote:

What is the issue with all of this, any way?

It looks like you had an average of 30% USER CPU for the duration of the snap (92,000 seconds of USER CPU, with 14 CPU's over six hours of available CPU to be used). That's not too bad? Is an SLA not being met?

Also, why did you set these ?

init.ora Parameters

Parameter Name                value

>> _newsort_enabled FALSE
>> _optim_peek_user_binds FALSE
Received on Tue Nov 18 2008 - 15:36:31 CST

Original text of this message