Re: High Utilization Problem

From: BN <BN.BN.COMO>
Date: Fri, 02 Sep 2005 12:19:10 -0400
Message-ID: <11hgus1o67qb64e@news.supernews.com>

Robert Klemme wrote:
> BN wrote:
>

>>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.
>>
>>I am running oracle 10g under Solaris 9 on Sparc.

>
>
> If you have access to EM did you check performance figures?
>
> robert
>
                                           

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:19:10 CDT