OraFAQ Forum: Enterprise Manager » Is there a way to set these HOST related metric settings?

Home » RDBMS Server » Enterprise Manager » Is there a way to set these HOST related metric settings? (11.2.0.4 SE, Windows 2012 r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there a way to set these HOST related metric settings? [message #651540]

Thu, 19 May 2016 20:40

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

I've hit Bug 20878834 : JAVA.LANG.NULLPOINTEREXCEPTION WHEN CLICKING THE LOAD LINK OF HOST CPU
Quote:

Problem Description
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
When Clicking the LOAD link of HOST CPU, the java.lang.NullPointerException
error occurs.
Environment Information
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
Reproduced the problem in 11.2.0.4
EM:
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Agent Version is 10.2.0.4.5
OMS Version is 10.2.0.4.5

that is to say If I want to set host related metrics like

Disk Device Busy (%) and Memory Utilization (%), I'm not able to set through Enterprise Manager.

https://docs.oracle.com/cd/E11882_01/server.112/e25494/monitoring.htm#ADMIN11253 has shown how to set metric through pl/sql.

I realize that from http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_server_alert.htm#ARPLS67996
there's only a list of metric that is supported
Quote:

Table 130-3 List of Supported Metrics

AVG_FILE_READ_TIME

So my question is If I were to set threshold for Disk Device Busy (%) and Memory Utilization (%) from http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_server_alert.htm#ARPLS67996

what metric_name should I use?

I also have another question.

In 11.2.0.4 window server 2008

I've just set memory utilization through OEM to warning threshold 90 and critical threshold 95, but I could not see the changes in dba_thresolds why is this so?

Code: [Select all] [Show/ hide]

SELECT DISTINCT metrics_name 
FROM   dba_thresholds 
ORDER  BY metrics_name;

results

Code: [Select all] [Show/ hide]

SYS@192.168.56.3/nowatzki>SELECT DISTINCT metrics_name FROM dba_thresholds ORDER 
BY metrics_name; 

METRICS_NAME 
---------------------------------------------------------------- 
Average Users Waiting Counts 
Blocked User Session Count 
Current Open Cursors Count 
Database Time Spent Waiting (%) 
Logons Per Sec 
Session Limit % 
Tablespace Bytes Space Usage 
Tablespace Space Usage 

8 rows selected.

why is memory utilization not inside dba_thresolds?

many thanks in advance!

[Updated on: Thu, 19 May 2016 21:17]

Report message to a moderator

Re: Is there a way to set these HOST related metric settings? [message #651541 is a reply to message #651540]

Thu, 19 May 2016 21:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

memory utilization% should always approach 100%; otherwise RAM is being wasted.

Report message to a moderator

Re: Is there a way to set these HOST related metric settings? [message #651542 is a reply to message #651541]

Thu, 19 May 2016 21:26

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

firstly I have found a way to set host related metrics in OEM, just click the hostname hyperlink and are you in host/machine mode not in database instance mode. so whatever metric settings u set it will be related to host.

okay agree with you, but then can we set host related metric through pl/sql? that's my first question

In 11.2.0.4 windows server 2008

I've just set Disk Device Busy (%) to warning threshold 90 and critical threshold to 95 through oem

still I cold not see any thing being reflected in dba_thresholds

Code: [Select all] [Show/ hide]

SYS@192.168.56.3/nowatzki>SELECT DISTINCT metrics_name FROM dba_thresholds ORDER 
BY metrics_name; 

METRICS_NAME 
---------------------------------------------------------------- 
Average Users Waiting Counts 
Blocked User Session Count 
Current Open Cursors Count 
Database Time Spent Waiting (%) 
Logons Per Sec 
Session Limit % 
Tablespace Bytes Space Usage 
Tablespace Space Usage 

8 rows selected.

my second question: why is it not being reflected in dba_thresholds?

many thanks in advance!

[Updated on: Thu, 19 May 2016 22:48]

Report message to a moderator

Previous Topic:	changing em url https to http
Next Topic:	EM 12c Cloud Control Install

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 08:41:49 CDT 2025