Re: High Utilization Problem

From: BN <BN.BN.COMO>
Date: Fri, 02 Sep 2005 12:20:59 -0400
Message-ID: <11hguvbk8b3g17d@news.supernews.com>

HansF wrote:
> On Fri, 02 Sep 2005 11:54:30 -0400, BN interested us by writing:
>
>

>>I have an oracle process at high utilization. It is running at about 98%
>>as reported by top utility under unix, all the time. What steps can I
>>take to resolve this? I do have access to em online.

>
>
> First question - why does this need to be resolved? Is it a problem (eg:
> are customers/users having a response issue), or is it just an irritating
> stat?
>
> What do the advisors (EM's advisor central) say?
>

There are no users doing anything on the system currently.                          

Select All | Select None
[Previous functionality disabled] Previous Next 9 [Select to view next set]

Select	SQL ID	SQL Type	Activity (%) [Sorted in descending order] 	CPU
(%)	Wait (%)

	8qcqkskshyyqq	PL/SQL EXECUTE	90.65	0.00	98.98
	2umvfdn2qu9tt	SELECT	1.87	22.22	0.00
	25jpmvsm171xd	PL/SQL EXECUTE	1.56	18.52	0.00
	257rmrxgvaj4z	SELECT	0.93	11.11	0.00
	0mjbmu9169pm8	SELECT	0.62	0.00	0.68
	8ff3pdmvzzyzz	SELECT	0.31	3.70	0.00
	bfzd6w0q8a103	PL/SQL EXECUTE	0.31	3.70	0.00
	75mz0g5h4r2qq	SELECT	0.31	3.70	0.00
	4cvqvs489pd6k	SELECT	0.31	3.70	0.00
	cmjf0y5s3t51t	INSERT	0.31	3.70	0.00
	
[Previous functionality disabled] 		Previous 				Next 9		[Select to view

next set]                                            

90.65% of the activity comes from :

SQL ID 8qcqkskshyyqq :

/* OracleOEM */ BEGIN

    dbms_server_alert.set_threshold(:metrics_id,

                            :warning_operator, :warning_value,
                                          :critical_operator,
    :critical_value,                                          1,
    :consecutive_occurrences,
         :instance_name,
    :object_type, :object_name);          END;

Received on Fri Sep 02 2005 - 11:20:59 CDT