Home » RDBMS Server » Enterprise Manager » Is there a way to set these HOST related metric settings? (11.2.0.4 SE, Windows 2012 r2)
Is there a way to set these HOST related metric settings? [message #651540] Thu, 19 May 2016 20:40 Go to next message
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?


SELECT DISTINCT metrics_name 
FROM   dba_thresholds 
ORDER  BY metrics_name; 


results

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 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
memory utilization% should always approach 100%; otherwise RAM is being wasted.
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 Go to previous message
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

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:
  


Current Time: Thu Mar 28 06:01:40 CDT 2024